private string ReadExcelCell(
string path,
int row,
int column)
{
Workbook workbook =
new Workbook();
workbook.Open(path);
Cells cells = workbook.Worksheets[
0].Cells;
for (
int i =
0; i < cells.MaxDataRow +
1; i++
)
{
if (i < row)
continue;
for (
int j =
0; j < cells.MaxDataColumn +
1; j++
)
{
if (j < column)
continue;
string s =
cells[i, j].StringValue.Trim();
//一行行的读取数据，插入数据库的代码也可以在这里写
return s;
}
}
return "找不到";
}
private void Read(
string path)
{
System.Data.DataTable dtDesc =
new DataTable();
dtDesc.Columns.Add("CMD",
typeof(System.String));
dtDesc.Columns.Add("PARA",
typeof(System.String));
dtDesc.Columns.Add("VAL",
typeof(System.String));
dtDesc.Columns.Add("MINVLAUE",
typeof(System.String));
dtDesc.Columns.Add("MAXVALUE",
typeof(System.String));
Workbook workbook =
new Workbook();
workbook.Open(path);
Cells cells = workbook.Worksheets[
0].Cells;
System.Data.DataRow currentDataRow;
for (
int i =
1; i < cells.MaxDataRow +
1; i++
)
{
currentDataRow =
dtDesc.NewRow();
for (
int j =
0; j < cells.MaxDataColumn +
1; j++
)
{
currentDataRow[j] =
cells[i, j].StringValue.Trim();
}
dtDesc.Rows.Add(currentDataRow);
}
}
aspose.ExportDataTable对同时包含number和数据的列，只取number忽略string.
转载于:https://www.cnblogs.com/hongjiumu/archive/2013/03/15/2962277.html
相关资源：C#使用Aspose.Cells创建和读取Excel文件
