Aspose.cell处理Excel2

?

?

?

?

(二）从excel中读取数据写到控制台中

?

using System;
using System.Collections.Generic;
using System.Text;
using Aspose.Cells;
namespace FromExcelToDB
{
??? class Program
??? {
??????? static void Main(string[] args)
??????? {
??????????? Workbook book = new Workbook();
??????????? book.Open("student.xlsx");
??????????? Worksheet sheet = book.Worksheets[0];
??????????? Cells cell = sheet.Cells;
???????????
??????????? for (int row = 0; row < cell.MaxDataRow+1; row++)
??????????? {
??????????????? for (int column = 0; column < cell.MaxDataColumn+1; column++)
??????????????? {
??????????????????? Console.WriteLine(cell[row , column].Value);
??????????????? }
??????????? }

??????? }
??? }
}

?

注：若想导入数据库中参照（一）；数据库是SQLServer