DataTable导出成excel
来源:互联网 发布:上海数据交易中心知乎 编辑:程序博客网 时间:2024/06/05 19:36
没完全看懂,直接复制用.
protected void ExportExcel(DataTable dt) { if (dt == null || dt.Rows.Count == 0) return; Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); if (xlApp == null) { return; } System.Globalization.CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture; System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); 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]; Microsoft.Office.Interop.Excel.Range range; long totalCount = dt.Rows.Count; long rowRead = 0; float percent = 0; for (int i = 0; i < dt.Columns.Count; i++) { worksheet.Cells[1, i + 1] = dt.Columns[i].ColumnName; range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[1, i + 1]; range.Interior.ColorIndex = 15; range.Font.Bold = true; } for (int r = 0; r < dt.Rows.Count; r++) { for (int i = 0; i < dt.Columns.Count; i++) { worksheet.Cells[r + 2, i + 1] = dt.Rows[r][i].ToString(); } rowRead++; percent = ((float)(100 * rowRead)) / totalCount; } xlApp.Visible = true; }
0 0
- DataTable导出成excel
- 把datatable导出成excel文件
- C# web DataTable 导出成Excel
- DataTable中数据导出成Excel文件
- DataTable导出Excel示例
- datatable导出EXCEL
- Datatable 导出到Excel
- DataTable 导出Excel
- 将DataTable导出Excel
- 从DataTable导出Excel
- datatable导出EXCEL
- DataTable导出Excel
- 通过DataTable导出Excel
- DataTable导出到Excel
- Datatable导出为Excel
- C# DataTable导出Excel
- DataTable导出到Excel
- DataTable导出Excel
- Eclipse property文件编辑插件
- 拼图响应式前端框架版响应式后台正式发布
- NotePad++学习总结
- 如何利用LXD来在不同的Ubuntu桌面环境中编译我们的snap
- delphi控制excel ,在指定单元格后插入行
- DataTable导出成excel
- mysql主从复制(测试版)
- CSS中overflow属性
- Total Commander 文件管理
- Android Dialog对话框合集
- 禁用/恢复手机默认的触屏滚动行为
- 众数问题
- Android Studio获取SHA1或MD5的方法
- Qt在Windows下的三种编程环境搭建