DataSet excel导出(winform)
来源:互联网 发布:水果机源码 编辑:程序博客网 时间:2024/06/02 00:21
private bool Export(DataSet dgv)
{
string savefilename;
SaveFileDialog savedialog = new SaveFileDialog();savedialog.DefaultExt = "xls";
savedialog.Filter = "excel文件|*.xls";
savedialog.FileName = "sheet1";
savedialog.ShowDialog();
savefilename = savedialog.FileName;
DataTable dt = dsExport.Tables[0];
int rowNumber = dt.Rows.Count;//不包括字段名
int columnnumber = dt.Columns.Count;
int colIndex = 0;
if (rowNumber == 0)
{
return false;
}
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet wkst = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
//excel.Visible = true;
Microsoft.Office.Interop.Excel.Range rg;
//生成字段名称
List<string> heads = new List<string> { "姓名","编号","日期"};
foreach (string s in heads)
{
colIndex++;
excel.Cells[1, colIndex] = s;
}
object[,] objData = new object[rowNumber, columnnumber];
for (int r = 0; r <rowNumber; r++)
{
for (int c = 0; c < columnnumber; c++)
{
objData[r, c] = dt.Rows[r][c];
}
}
rg = excel.Range[excel.Cells[2, 1], excel.Cells[rowNumber + 1, columnnumber]];
rg.Value2 = objData;
wkst.Range[excel.Cells[2, 1], excel.Cells[rowNumber + 1, 3]].NumberFormat = "yyyy-mm-dd hh:mm";//格式化数据
wkst.Range[excel.Cells[2, 1], excel.Cells[rowNumber + 1, 2]].NumberFormat = "@";
workbook.Saved = true;
workbook.SaveCopyAs(savefilename);
return true;
}
0 0
- DataSet excel导出(winform)
- WinForm导出DataSet到Excel
- DataSet导出到Excel (c#)
- Dataset导出到excel
- DataGrid、DataSet导出Excel
- DataSet导出EXCEL
- DataSet导出为Excel
- DataSet导出Excel
- dataset 导出为 excel
- 通过DataSet导出Excel
- DataSet导出为Excel
- DataSet导出到Excel
- DataSet导出Excel
- 【转】DataSet导出EXCEL
- 通过DataSet导出Excel .
- DataSet导出EXcel
- dataset导出EXCEL文件
- dataset 导出到 excel
- javascript模块化编程及AMD规范
- Pro Android学习笔记(九九):BroadcastReceiver(3):长时间运行Receiver的问题
- mongodb---js脚本操作速记
- 报错:1130-host ... is not allowed to connect to this MySql server
- 11G R2 RAC监听管理---修改端口
- DataSet excel导出(winform)
- RS232接口器件
- Null value was assigned to a property of primitive type setter of
- java project整合spring和hibernate
- 面试题
- 析构函数
- [Unity3D]Unity官方认证考试模拟题
- Dojo Mobile开发学习篇
- Android中Application类用法