I want to open an Xlsx file, add data from the back end, and then save it as a PDF on the client. At a time, the procedure would produce roughly 100 files. I discovered after doing some online research that Excel Interop is no longer usable. Does XML SDK have to be used?
I am unable to use any products or APIs from third parties. It is either using XML or Interop, but it is only asking for coding recommendations. I do have a professional license for Adobe, and I've used Office Automation to save Excel files as PDFs.
What are my options? Any recommendation would be greatly appreciated.