EPPlus导出和Spire.Xls导入、导出Pdf/Image、调节工作簿比例和视图模式

EPPLus导出的教程 ，总结的很详细：
http://www.cnblogs.com/rumeng/p/3785775.html
https://www.cnblogs.com/chenwolong/p/Spire.html

//Spire.Xls导入

 string extension = Path.GetExtension(fileLoad.FileName);
 if (extension != ".xls" && extension != ".xlsx")
 {
     OperateMessage.OperateMsg(this, "请上传excel文件！");
     return;
 }
 DataTable datatable = new DataTable();  
 //载入Excel文档
 Workbook workbook = new Workbook();
 string strPathFull = Path.GetFullPath(fileLoad.PostedFile.FileName);  //获取文件绝对路径
 workbook.LoadFromFile(strPathFull);
  //获取第一个工作表 
 Worksheet sheet = workbook.Worksheets[0];
 //填充数据
 datatable = sheet.ExportDataTable(); 
 foreach (DataRow row  in datatable.Rows)
 {
   //插入数据库代码
 }
 OperateMessage.OperateMsg(this, "上传成功！");
 
 注：
 string fileNameNo = Path.GetFileName(FileUploadImg.PostedFile.FileName); //获取文件名和扩展名
 string DirectoryName = Path.GetDirectoryName(FileUploadImg.PostedFile.FileName); //获取文件所在目录
 string Extension = Path.GetExtension(FileUploadImg.PostedFile.FileName); //获取扩展名
 string fileName = Path.GetFileNameWithoutExtension(FileUploadImg.PostedFile.FileName); //获取文件名（不包括扩展名）
 string fullPath = Path.GetFullPath(FileUploadImg.PostedFile.FileName); //获取文件的绝对路径
 string PathRoot = Path.GetPathRoot(FileUploadImg.PostedFile.FileName); //获取文件所在地分区

//Spire.Xls导出Pdf/Image等

//string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";
//string newpath = Server.MapPath("/excel/PrintExcel/") + filename;
//FileInfo newfile = new FileInfo(newpath);

 package.SaveAs(newfile);//保存导出的excel路径
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
 workbook.LoadFromFile(newfile.FullName);
 workbook.ConverterSetting.SheetFitToPage = true;
 string pdfFullPath = newfile.DirectoryName + "/" + fileName.Substring(0,fileName.LastIndexOf('.')) + ".jpg";//".pdf"
 Spire.Xls.Worksheet workSheet = workbook.Worksheets[0];
 workSheet.SaveToImage(pdfFullPath);//workSheet.SaveToPdf(pdfFullPath);
 Response.WriteFile(pdfFullPath);
 HttpContext.Current.ApplicationInstance.CompleteRequest();

//Spire.xls调节工作簿比例及视图模式

   //保存文件
   package.SaveAs(newfile);
   //实例化Workbook类，加载Excel测试文档
   Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
   workbook.LoadFromFile(newfile.FullName);
   workbook.ConverterSetting.SheetFitToPage = true;
   //获取第一个工作表
   Spire.Xls.Worksheet sheetSpire = workbook.Worksheets[0];
  //设置视图缩放比例及视图模式
   sheet.ViewMode = ViewMode.Normal;
   sheetSpire.Zoom = 60;
  //保存并打开文档
  string strExcel = newfile.DirectoryName + "/" + fileName.Substring(0, fileName.LastIndexOf('.')) + "_Result.xlsx";
  workbook.SaveToFile(strExcel, ExcelVersion.Version2010);
  System.Diagnostics.Process.Start(strExcel);