private void btn_Export_Click(object sender, EventArgs e) { //创建Excel Workbook wb = new Workbook(); Worksheet sheet = wb.Worksheets[0]; //将datagridview的数据导入工作表 DataTable datatable = this.dataGridView1.DataSource as DataTable; sheet.InsertDataTable(datatable, true, 1, 1); //自适应列宽 sheet.AllocatedRange.AutoFitColumns(); //填充背景色 for (int rowIndex = 0; rowIndex < sheet.Rows.Count(); rowIndex++) { if(rowIndex % 2 == 0) { sheet.Rows[rowIndex].Style.Color = Color.LightYellow; } else sheet.Rows[rowIndex].Style.Color = Color.LightBlue; } //保存文档 wb.SaveToFile("output.xlsx", ExcelVersion.Version2013); } 通过以上方法将数据导入excel, 并自适应列宽和填充颜色,你也可以通过代码自己设置列宽或者对整个表设置背景色。 该方法使用免费版的Spire.XLS
private void btn_Export_Click(object sender, EventArgs e) { //创建Excel Workbook wb = new Workbook(); Worksheet sheet = wb.Worksheets[0]; //将datagridview的数据导入工作表 DataTable datatable = this.dataGridView1.DataSource as DataTable; sheet.InsertDataTable(datatable, true, 1, 1); //自适应列宽 sheet.AllocatedRange.AutoFitColumns(); //填充背景色 for (int rowIndex = 0; rowIndex < sheet.Rows.Count(); rowIndex++) { if(rowIndex % 2 == 0) { sheet.Rows[rowIndex].Style.Color = Color.LightYellow; } else sheet.Rows[rowIndex].Style.Color = Color.LightBlue; } //保存文档 wb.SaveToFile("output.xlsx", ExcelVersion.Version2013); }
string str = @"<table> <tr><td bgcolor=red>1行第一列</td><td bgcolor=yellow>第二列</td></tr> < tr><td>2行第一列</td><td>第二列</td></tr> </table>"; File.WriteAllText(@"f:\111.xls", str, Encoding.UTF8);
110,536
社区成员
642,578
社区内容
加载中
让您成为最强悍的C#开发者
试试用AI创作助手写篇文章吧