-
DataGridView内容导出到Excel文件
- public static void ExportToXlsFile(DataGridView dataGridView, string path)
- {
- XlsDocument doc = new XlsDocument();
- Workbook workbook = doc.Workbook;
- Worksheet worksheet = workbook.Worksheets.Add("sheet1");
- DataGridViewColumnCollection columns = dataGridView.Columns;
- foreach (DataGridViewColumn column in columns)
- {
- ushort columnIndex = (ushort)column.DisplayIndex;
- Cell cell = worksheet.Cells.Add((ushort)1, columnIndex + (ushort)1, column.HeaderText);
- cell.Font.Bold = true;
- ColumnInfo info = new ColumnInfo(doc, worksheet)
- {
- ColumnIndexStart = columnIndex,
- ColumnIndexEnd = columnIndex,
- Width = (ushort)(column.Width * 40),
- Hidden = !column.Visible
- };
- worksheet.AddColumnInfo(info);
- }
-
- int i = 2;
- foreach (DataGridViewRow row in dataGridView.Rows)
- {
- foreach (DataGridViewCell cell in row.Cells)
- {
- object value = cell.FormattedValue;
- worksheet.Cells.Add(i, cell.OwningColumn.DisplayIndex + 1, value).Font.Height = 160;
- }
- i++;
- }
- doc.FileName = path;
- doc.Save(true);
- }
-
相关阅读:
Lua笔记——8.Lua & C
Shader笔记——5.渲染纹理
常用工具——2.Mac
Shader笔记——4.纹理基础
设计模式学习笔记四:简单工厂模式抽象工厂模式工厂方法模式
设计模式学习笔记三:策略模式和状态模式
设计模式学习笔记二:单例模式
设计模式学习笔记一:程序设计原则
数据结构和算法学习笔记十六:红黑树
数据结构和算法学习笔记十五:多路查找树(B树)
-
原文地址:https://www.cnblogs.com/juefeiye/p/2117255.html
Copyright © 2020-2023
润新知