Aug 31, 2015 01:29 AM|Caillen Zhong|LINK
Please firstly take a look at this KB article:
Considerations for server-side Automation of Office
Microsoft recommends that we use Open XML SDK on the server side to auto mate the Office files, including generating Excel workbooks. You have to install Open XML SDK before calling the API:
And this is the documentation about how to generating an Excel workbook:
See another document for the overview of Open XML SDK if you want to know the details:
Based on my own experience, it's a little bit hard to understand and use Open XML SDK, there's an opensource library ClosedXML which make it easier to automate the Office files:
Some other libraries, e.g. NPOI, are also good choices, we don't need to have Office application installed on the server either.