We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
|
//Instantiate ExcelEngine
using (ExcelEngine excelEngine = new ExcelEngine())
{
//Initialize IApplication
IApplication application = excelEngine.Excel;
//Set the default application version
application.DefaultVersion = ExcelVersion.Excel2013;
//Load the existing Excel docuemnt into IWorkbook
IWorkbook workbook = application.Workbooks.Open(Server.MapPath("App_Data/result.xlsx"), ExcelOpenType.Automatic);
//Initialize ExcelToPdfConverter
ExcelToPdfConverter converter = new ExcelToPdfConverter(workbook);
//Initialize ExcelToPdfConverterSettings and disable the gridlines
ExcelToPdfConverterSettings converterSettings = new ExcelToPdfConverterSettings();
converterSettings.DisplayGridLines = GridLinesDisplayStyle.Invisible;
//Initialize PDF document
PdfDocument pdfDocument = new PdfDocument();
//Convert Excel document into PDF document
pdfDocument = converter.Convert(converterSettings);
//Open the document in browser after saving it
pdfDocument.Save("Output.pdf", HttpContext.ApplicationInstance.Response, HttpReadType.Save);
} |
