110,536
社区成员
发帖
与我相关
我的任务
分享
private void ExportDataSetToExcel(DataSet ds,string savePath)
{
Excel.Application excelApp = new Excel.Application();
Excel.Workbook excelWorkBook = excelApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
foreach (System.Data.DataTable table in ds.Tables)
{
Excel.Worksheet excelWorkSheet = excelWorkBook.Sheets.Add();
excelWorkSheet.Name = table.TableName; //sheet名为datatable表名
for (int i = 1; i < table.Columns.Count + 1; i++)
{
excelWorkSheet.Cells[1, i] = table.Columns[i - 1].ColumnName;
}
for (int j = 0; j < table.Rows.Count; j++)
{
for (int k = 0; k < table.Columns.Count; k++)
{
excelWorkSheet.Cells[j + 2, k + 1] = table.Rows[j].ItemArray[k].ToString();
}
}
//这里可以添加Sheet的格式代码
}
excelWorkBook.Saved = true;
excelWorkBook.SaveCopyAs(savePath);
excelWorkBook.Close();
excelApp.Quit();
MessageBox.Show("导出成功!");
}
using Microsoft.Office.Interop.Excel;
private void ExportDataSetToExcel(DataSet ds)
{
Excel.Application excelApp = new Excel.Application();
Excel.Workbook excelWorkBook = excelApp.Workbooks.Open(@"E:\Org.xlsx");
foreach (DataTable table in ds.Tables)
{
Excel.Worksheet excelWorkSheet = excelWorkBook.Sheets.Add();
excelWorkSheet.Name = table.TableName; //sheet名为datatable表名
for (int i = 1; i < table.Columns.Count + 1; i++)
{
excelWorkSheet.Cells[1, i] = table.Columns[i - 1].ColumnName;
}
for (int j = 0; j < table.Rows.Count; j++)
{
for (int k = 0; k < table.Columns.Count; k++)
{
excelWorkSheet.Cells[j + 2, k + 1] = table.Rows[j].ItemArray[k].ToString();
}
}
//这里可以添加Sheet的格式代码
}
excelWorkBook.Save();
excelWorkBook.Close();
excelApp.Quit();
}