In my application, I need to generate excel files on the fly. I have an option of using Excel library. But it is mandatory to have excel installed on the machine.
Is there any other .NET API to generate excel files at runtime which doesn't require excel.
If you just need a file that will open in Excel and is just data, you can output to a .csv file. These usually open in the default spreadsheet program (aka Excel on windows). They are much simpler to generate.
SpreadsheetGear for .NET will let you create Excel files in .NET without having Excel installed.
You can see live samples here and download the free trial here if you want to try it yourself.
Disclaimer: I own SpreadsheetGear LLC
