c# SLDocument读取Excel文件并且转成Datable

话不多说封装起来看代码

public DataTable XlsxToDataTable(string vFilePath)
{
DataTable dataTable = new DataTable();
try
{
SLDocument sldocument = new SLDocument(vFilePath);
dataTable.TableName = sldocument.GetSheetNames()[0];
SLWorksheetStatistics worksheetStatistics = sldocument.GetWorksheetStatistics();
int startColumnIndex = worksheetStatistics.StartColumnIndex;
int endColumnIndex = worksheetStatistics.EndColumnIndex;
int startRowIndex = worksheetStatistics.StartRowIndex;
int endRowIndex = worksheetStatistics.EndRowIndex;
for (int i = startColumnIndex; i <= endColumnIndex; i++)
{
SLRstType cellValueAsRstType = sldocument.GetCellValueAsRstType(1, i);
dataTable.Columns.Add(new DataColumn(cellValueAsRstType.GetText(), typeof(string)));
}
for (int j = startRowIndex + 1; j <= endRowIndex; j++)
{
DataRow dataRow = dataTable.NewRow();
for (int i = startColumnIndex; i <= endColumnIndex; i++)
{
dataRow[i - 1] = sldocument.GetCellValueAsString(j, i);
}
dataTable.Rows.Add(dataRow);
}
}
catch (Exception ex)
{
throw new Exception("Xlsx to DataTable: \n" + ex.Message);
}
return dataTable;
}