Search code examples
.netexcelvisual-studio-2010com

Can I use Microsoft.Office.Interop.Excel to create Excel file on the system where Microsoft Office pack is not installed?

I am adding Microsoft.Office.Interop.Excel from the .net tab of the Add Reference option of Visual Studio to create Excel file. Everything is working fine and I am getting quite good and fast Excel reports.

Now my only concern is that can I use this Microsoft.Office.Interop.Excel in the System where Microsoft office Pack is not installed. Will I be able to create an Excel file in this condition?

Please help me.

Solution

  • can i use this Microsoft.Office.Interop.Excel in the System where Microsoft office Pack is not installed.Will i be able to create Excel in this condition ?

    No. Office would have to be installed.

    Instead, use EPPlus (it's free):

    Create advanced Excel 2007/2010 spreadsheets on the server. EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).

    I've used EPPlus in several projects and it works well.