Hi,
I'm using the Infragistics.Documents.Excel.Workbook class to load in an Excel workbook (Excel 2007). I'm wondering if there is any way to save this workbook as a PDF file. Basically, I'm looking for a way where "Save As type: PDF" in Excel can be done programmatically. Is there any way to do this with the Workbook or PdfDocument classes?
Thanks, Paul
Hello Paul,
I do not see a way to achieve the desired. The core classes that hold the pdf document object and the excel workbook object are Report and Workbook. They are part of different namespaces and I truly believe that casting one to another will not work out.
I suggest you stick to the conventional way and create either the excel/pdf file from scratch as demonstrated in our online samples:
http://ko.infragistics.com/samples/aspnet/infragistics-documents/export-to-pdf-or-xps
http://ko.infragistics.com/samples/aspnet/infragistics-excel/save-load-excel-files
Please let me know if you have further questions, I will be glad top help.
Thanks for the response. We have an extensive templating feature in our application that uses Excel to template data (and we use Infragistics to load in the Excel template and fill in the data). There's really no way for us to conventionally use the pdf feature because we need to start with an Excel template. So it sounds like we'll need to figure something else out for going from Excel to PDF.
Thanks,
Paul