using Spire.XLS;
using System.Drawing;
//创建Workbook对象
Workbook workbook = new Workbook();
//打开指定路径的excel,如果注释掉本行,相当于新建excel
workbook.LoadFromFile(filePath, true);
//也可以根据Excel模板生成Workbook,一般用于根据模板导出的时候
workbook.LoadTemplateFromFile(@"D:\template.xlsx");
//获取第一张工作表
Worksheet sheet = workbook.Worksheets[0];
//也可以将指定工作表读取到DataTable
DataTable dt = workbook.Worksheets[0].ExportDataTable();
//读写excel
sheet.Range["C5"].Text = "你好,Jim" ;
//也可以根据行列来读写excel
sheet.Range[1, 1].Text = "部门名称";
//DataTable的遍历
for (int i = 0; i < dt.Rows.Count; i++)
{
//do something
}
//指定列宽
sheet.Columns[1].ColumnWidth = 20;
//指定行高
sheet.Rows[1].RowHeight = 20;
//添加图片到指定单元格
ExcelPicture picture = sheet.Pictures.Add(行号, 列号, 图片绝对路径);
//指定图片宽度和高度
picture.Width = 80;
picture.Height = 80;
//设置单元格字体样式
sheet.Range["C5:E6"].Value = "aaabbbccc";
sheet.Range["C5:E6"].Style.Font.Color = Color.FromArgb(255, 125, 125);//文本颜色
sheet.Range["C5:E6"].Style.Font.IsBold = true;//字体是否加粗
sheet.Range["C5:E6"].Style.Font.IsItalic = true;//是否斜体
sheet.Range["C5:E6"].Style.Font.Underline = FontUnderlineType.Single;//下划线
sheet.Range["C5:E6"].Style.Font.IsSuperscript = true;//是否呈现为下标
sheet.Range["C5:E6"].Style.Font.FontName = "华文彩云";//字体名称
sheet.Range["C5:E6"].Style.Font.Size = 30;//字体大小
//设置单元格样式
sheet.Range["C5:E6"].Style.HorizontalAlignment = HorizontalAlignType.Center;//水平对齐
sheet.Range["C5:E6"].Style.VerticalAlignment = VerticalAlignType.Center;//垂直对齐
sheet.Range["C5:E6"].ColumnWidth = 100;//单元格的宽度
sheet.Range["C5:E6"].RowHeight = 30;//行高
sheet.Range["C5:E6"].Style.Borders[BordersLineType.EdgeLeft].LineStyle = LineStyleType.Thin;//边框
sheet.Range["C5:E6"].Style.Borders[BordersLineType.EdgeRight].LineStyle = LineStyleType.Thin;
sheet.Range["C5:E6"].Style.Borders[BordersLineType.EdgeTop].LineStyle = LineStyleType.Thin;
sheet.Range["C5:E6"].Style.Borders[BordersLineType.EdgeBottom].LineStyle = LineStyleType.Thin;
//保存
workbook.SaveToFile(@"D:\test.xls", FileFormat.Version2007);
//保存完之后直接打开文件
//System.Diagnostics.Process.Start(@"D:\test.xls");
//保存的excel版本参数
// 摘要:
// Represents excel version 2007 xlsb
//Xlsb2007 = 0,
//
// 摘要:
// Represents excel version 2010 xlsb
//Xlsb2010 = 1,
//
// 摘要:
// OpenOffice Spreadsheet documents
//ODS = 2,
//
// 摘要:
// Represents excel version 97-2003.
//Version97to2003 = 3,
//
// 摘要:
// Represents excel version 2007
//Version2007 = 4,
//Version2010 = 5,
//
// 摘要:
// Represents excel version 2013.
//Version2013 = 6,