I have an Xlsx file that I want to open, populate it with data from back-end and then save it as PDF on the client. The process would create about a 100 files at a time.
I searched around the web and realize that it is not possible to use Excel Interop any more. Do I have to use XML SDK?
I cannot use any third-party products or APIs. It is either using Interop or XML but just looking for coding suggestions. I do have Adobe pro license and have used in Office Automation to save Excel files as PDF.
What are my options? Any recommendation would be greatly appreciated.