(二)从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