小工具：DataGridView内容导出到Excel文件

一小段代码，很实用

使用了开源类库MyXls

 

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); }