Spire.Xls使用

Workbook workbook = new Workbook();

string str="D:\\文件名";

workbook.LoadFromFile(str);

Worksheet sheet = workbook.Worksheets[0];

sheet.Range["B2"].Text = "22323";

 //设置打印纸张大小
 sheet.PageSetup.PaperSize = PaperSizeType.PaperA4;

//导出

workbook.SaveToFile("D:\\result.xlsx", FileFormat.Version2007);

//打印
workbook.PrintDocument.Print();