Write ExcelFile

I have a scenario where I need to store all data of current workbook including template to a new excel workbook/ worksheet and store that new file to dat开发者_如何学编程abase in BLOB. I am using C#. Any demo available ?

Consider using the Open XML SDK to read and write Excel documents. It can read and write Office 2007 and 2010 compatible documents without the need for Excel to be installed on the machine/server. Another approach would be to automate Excel (instantiate an Excel.Application object, and then programmatically drive Excel to do the work).

I usually recommend option 1.

Have a look at that question.

The accepted answer recommends using an open source library called NPOI for manipulating spreadsheets.