I am wondering if the Excel framework allows use to save the excel document as PDF. If it does can you supply me with a code snippet that shows how that can be accomplished?
Hello,
I am just checking about the progress of this issue. Let me know If you need my further assistance on this issue?
Thank you for using Infragistics Components.
I have this same question. Do you have any sample code on converting a Excel to PDF? In my case, the Excel files are varied and somewhat complicated. And I don't necessarily know their format or contents up front. They might include images, charts, etc. I'm hoping there's a general purpose way to generate the PDF
There's no way to convert Excel to PDF. At least, no automatic or built-in way. I suppose one simply thing you could do would be to get a PDF print driver installed (you probably already have one) and then print the Excel sheet to PDF. But there's no DotNet or Infragistics method to convert one to the other. The formats are not really similar in any way.
You mention printing to a PDF printer. Is it possible to print using the Infragistics API, or do we need to launch Excel to do that?
Thanks for your reply. I understand that the formats are not similar in any way. I was hoping that you might offer some facility for doing it, even if limited. I did find that using Excel interop, I could save the file as PDF. Of course, that requires having Excel installed on the target system. I also found some other libraries that claim to convert Excel to PDF. Eg. https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Conversion/NET-Excel-New-method-of-Convert-Excel-to-PDF.html