110,566
社区成员
发帖
与我相关
我的任务
分享
private void ExportExcel(string fileName, DataGridView myDGV)
{
Microsoft.Office.Interop.Excel.Application exapp = new Microsoft.Office.Interop.Excel.Application();
exapp.Visible = false;
Microsoft.Office.Interop.Excel.Workbooks workbooks = exapp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1
for (int i = 0; i < myDGV.ColumnCount; i++)
{
worksheet.Cells[1, i + 1] = myDGV.Columns[i].HeaderText;
}
for (int r = 0; r < myDGV.Rows.Count; r++)
{
for (int j = 0; j < myDGV.ColumnCount; j++)
{
worksheet.Cells[r + 2, j + 1] = myDGV.Rows[r].Cells[j].Value;
}
}
worksheet.Columns.EntireColumn.AutoFit();
try
{
workbook.SaveCopyAs(fileName);
workbook.Saved = true;
exapp.Quit();
GC.Collect();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
Range rColumCost4 = wst.get_Range(wst.Cells[1, j+1], wst.Cells[dt.Rows.Count + 1, j+1]);