public static void ExportToExcel(DataSet dsExport, string analCombineFile)
{
Workbook workBook = new Workbook();
Worksheet sheet = workBook.Worksheets[0];
sheet.Name = "数据";
Cells cells = sheet.Cells;
int tableCount = dsExport.Tables.Count;
DataTable dt = dsExport.Tables[0];
int columnCount = dt.Columns.Count;
for (int i = 0; i < columnCount; i++)
{
cells[0, i].PutValue(dt.Columns[i].ColumnName);
}
for (int m = 0; m < tableCount; m++)
{
DataTable dtAnal = dsExport.Tables[m];
int rowCount = dtAnal.Rows.Count;
for (int i = 0; i < rowCount; i++)
{
for (int j = 0; j < columnCount; j++)
{
cells[m + 1, j].PutValue(dtAnal.Rows[i][j]);
}
}
}
workBook.Save(analCombineFile);
}
{
Workbook workBook = new Workbook();
Worksheet sheet = workBook.Worksheets[0];
sheet.Name = "数据";
Cells cells = sheet.Cells;
int tableCount = dsExport.Tables.Count;
DataTable dt = dsExport.Tables[0];
int columnCount = dt.Columns.Count;
for (int i = 0; i < columnCount; i++)
{
cells[0, i].PutValue(dt.Columns[i].ColumnName);
}
for (int m = 0; m < tableCount; m++)
{
DataTable dtAnal = dsExport.Tables[m];
int rowCount = dtAnal.Rows.Count;
for (int i = 0; i < rowCount; i++)
{
for (int j = 0; j < columnCount; j++)
{
cells[m + 1, j].PutValue(dtAnal.Rows[i][j]);
}
}
}
workBook.Save(analCombineFile);
}