Create Excel file and save as PDF

Question

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.

Answer 1

Office 2013 still has the Interop library and it works perfectly fine under .NET 4.5.1 Just add Microsoft.Office.Interop.Excel assembly to your references and you are ready to go.

using System;
using Microsoft.Office.Interop.Excel;

namespace officeInterop
{
    class Program
    {
        static void Main(string[] args)
        {
            Application app = new Application();
            Workbook wkb = app.Workbooks.Open("d:\\x.xlsx");
            wkb.ExportAsFixedFormat(XlFixedFormatType.xlTypePDF, "d:\\x.pdf");
        }
    }
}