关于 spire插件Excel转换pdf的问题

常用  Spire 相关网址 https://www.evget.com/article/2019/8/15/31718.html

 

1.Excel 赋值与取值

     //创建工作簿2，并加载Excel文件
                        Workbook workbook2 = new Workbook();

                        workbook2.LoadFromFile(LinMuLu);//加载
                        workbook2.Worksheets[0].Visibility = WorksheetVisibility.Hidden;//隐藏工作簿
                        workbook2.Worksheets[1].Visibility = WorksheetVisibility.Hidden;

                        Worksheet sheet2 = workbook2.Worksheets.AddCopy(sheet1);//用来将某个工作簿copy到当前工作簿

                       sheet2.Range["B3"].Value = SaleOrderCode;//赋值

                         //取值

                       CellRange range = sheet2.Range["" + cels[i] + "6"];
                            var cellValue = range.Value;

 

2 Excel转换PDF内容超出解决方案

                        Workbook workbook = new Workbook();
                        workbook.LoadFromFile(LinNme);
                        workbook.ConverterSetting.SheetFitToPage = true;//关键   自适应pdf
                        workbook.SaveToFile(PdfPath,Spire.Xls.FileFormat.PDF);