VS 2005 [c#] datagridview导出Excel
来源:互联网 发布:诺基亚E71 软件下载 编辑:程序博客网 时间:2024/06/06 23:50
VS 2005 [c#] datagridview导出Excel
public static void ExportExcel(string fileName, DataGridView gridview)
{
string saveFileName = "";
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.DefaultExt = "xls";
saveDialog.Filter = "Excel文件|*.xls";
saveDialog.FileName = fileName;
saveDialog.ShowDialog();
saveFileName = saveDialog.FileName;
if (saveFileName.IndexOf(":") < 0)
return;
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
MessageBox.Show("无法创建Excel对象,有可能未安装Excel!");
return;
}
Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.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];
for (int i = 0; i < gridview.ColumnCount; i++)
{
worksheet.Cells[1, i + 1] = gridview.Columns[i].HeaderText;
}
for (int r = 0; r < gridview.Rows.Count; r++)
{
for (int c = 0; c < gridview.ColumnCount; c++)
{
worksheet.Cells[r + 2, c + 1] = gridview.Rows
.Cells[c].Value;
}
System.Windows.Forms.Application.DoEvents();
}
worksheet.Columns.EntireColumn.AutoFit();
if (saveFileName != "")
{
try
{
workbook.Saved = true;
workbook.SaveCopyAs(saveFileName);
}
catch (Exception ex)
{
MessageBox.Show("导出错误,有可能文件正在打开!/n" + ex.Message);
}
}
xlApp.Quit();
GC.Collect();
MessageBox.Show("导出成功!");
}
- VS 2005 [c#] datagridview导出Excel
- C#datagridview导出Excel报表
- C#datagridview导出数据到excel
- C#Winform中从datagridview导出Excel
- DataGridView导出excel
- datagridview导出为Excel
- DataGridView导出excel(转载)
- DataGridView导出到Excel
- DataGridView导出到Excel
- c# datagridview 导出excel
- c# datagridview 导出excel
- datagridview导出为Excel
- Datagridview 导出Excel
- DataGridView导出Excel文件
- datagridview导出excel
- DataGridView导出EXCEL
- C# dataGridView导出Excel
- DataGridView导出Excel
- 关于二级指针的使用测试小例子,仅供测试--参数传递的时候用指针最好,因为压栈的时候指针,只是压入一个地址的值,最多4个字节(32位机上),提供的3个测试例子,基于VC6.0的环境。
- php 中的变量 作用域
- 解决SWF加载报错问题 —以及利用该错误防止盗链
- Jan 16, 2005
- 10月份出国前要完成的事
- VS 2005 [c#] datagridview导出Excel
- dojo的事件机制
- 递归
- 转:IBM Emacs在线教程
- ExcelReader.cs
- 一段混乱的日子又要过去了
- javaME基础知识(一)
- 人生应该接受的教育
- 犹豫中