引用spire.xls.dll, 写入数据到excel的代码如下,读取就不举例了,也很简单
//创建一个workbook实例
Workbook wb = new Workbook();
//获取第一个工作表
Worksheet sheet = wb.Worksheets[0];
//写入数据到A1单元格,设置文字格式及对齐方式
sheet.Range["A1"].Value = "你好";
sheet.Range["A1"].HorizontalAlignment = HorizontalAlignType.Center;
sheet.Range["A1"].VerticalAlignment = VerticalAlignType.Center;
sheet.Range["A1"].Style.Font.IsBold = true;
sheet.Range["A1"].Style.Font.Size = 13F;
//保存为.xlsx文件
wb.SaveToFile("创建Excel.xlsx", FileFormat.Version2013);