spire可以在jpg,pdf,excel之间自由转换,建议从官网下载,使用方法考虑
C#组件系列——又一款Excel处理神器Spire.XLS,你值得拥有(二) - 懒得安分 - 博客园
当前已经引入到了系统中,使用代码
//A: Dynamically create Excel file and save it to stream
Workbook wbToStream = new Workbook();
//Worksheet sheet = wbToStream.Worksheets[0];
wbToStream.Worksheets.Clear();
Worksheet sheet1 = wbToStream.Worksheets.Add("Sheet1");
Worksheet sheet2 = wbToStream.Worksheets.Add("统计");
Worksheet sheet3 = wbToStream.Worksheets.Add("大洲分布");
Worksheet sheet4 = wbToStream.Worksheets.Add("亚洲");
Worksheet sheet5 = wbToStream.Worksheets.Add("非洲");
Worksheet sheet6 = wbToStream.Worksheets.Add("南美洲");
Worksheet sheet7 = wbToStream.Worksheets.Add("北美洲");
Worksheet sheet8 = wbToStream.Worksheets.Add("欧洲");
Worksheet sheet9 = wbToStream.Worksheets.Add("大洋洲");
Worksheet sheet10 = wbToStream.Worksheets.Add("南极洲");
biao1 temp1 = new biao1();
List<biao1> t1=new List<biao1>();
t1.Add(temp1);
temp1.orgname = "aaa";
DataTable abc = new DataTable();
DataView aaaccc=abc.DefaultView;
WEBCORE.ModelHandler<biao1> aaerw = new ModelHandler<biao1>();
DataSet abcsdfsd= aaerw.FillDataSet(t1);
sheet1.InsertDataView(abcsdfsd.Tables[0].DefaultView, true, 1, 1);
sheet1.Range["A2:G7"].RowHeight = 15F;
sheet1.Range["A2:G7"]. = 15F;
//sheet.InsertDataView(,true,1,1)// 从表中读数据