admin 管理员组

文章数量: 1086864

c# Create Excel file and save as PDF

方法一： 引用库： FreeSpire.XLS（VS NuGet 里面能直接找到）

    //void ConvertToPDF(string Path,string filename)//{//    Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();//    workbook.LoadFromFile(Path);////    Spire.Xls.Worksheet sheet= workbook.Worksheets[0];//    sheet.PageSetup.PrintArea = "A1:I41";//设置打印区域//    sheet.SaveToPdf(Environment.CurrentDirectory.ToString() + @"\OUTPUT_PDF\"+ filename + ".pdf");            //}

方法二：
调用Office库：Microsoft.Office.Interop.Excel

    //public bool PrintPDF(string ipt)//{//        var res = false;//        try//        {//            var lab_path = @"C:\printPDF\pdf.xls";//调用xls模板//            mExcel = new Microsoft.Office.Interop.Excel.Application();//            mExcel.Visible = false;//true//            mWorkbook = mExcel.Application.Workbooks.Open(lab_path, Missing.Value, Missing.Value, 	    Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, //            Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);//            mWorkSheet = new Microsoft.Office.Interop.Excel.Worksheet();//            mWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)mWorkbook.Worksheets[1];//            //            mWorkSheet.Activate();////            ..........此部分未数据填充以及文件格式设置////            mWorkSheet.PageSetup.PaperSize = XlPaperSize.xlPaperA4;//设置打印纸张大小//            mWorkSheet.PageSetup.PrintArea = "A1:I41";//设置打印区域//            //end filling value//            //start to print out            //            //mWorkbook.PrintOut(Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);//mWorkbook.PrintOutEx();//            //end print,then save file////            var savetoXls = Environment.CurrentDirectory.ToString() + @"\PDF_XLS\PDF_" + ipt + ".xls";//            var savetoPDF = Environment.CurrentDirectory.ToString() + @"\PDF_PDF\PDF_" + ipt + ".pdf";////            mWorkbook.ExportAsFixedFormat(XlFixedFormatType.xlTypePDF, savetoPDF);//            mWorkbook.SaveAs(savetoXls, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value);//            mWorkbook.Close(false, Missing.Value, Missing.Value);//            mExcel.Quit();//            res =true;//        }//        catch//        {//            res=false;//            throw;//        }//        return res;//}

可根据需求选择合适的。

本文标签： cCreate Excel file and save as PDF

版权声明：本文标题：c#Create Excel file and save as PDF 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.roclinux.cn/b/1688362969a210887.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。