Are there any free alternatives to using "Microsoft Excel 12.0 Object Library" component in the application? It does the job, but it's very slow. I know there are commercial third-party tools, and wondering if there's anything fast, but freeware to accomplish the task.
A:
Microsoft provides an Open XML SDK which is used to generate the XLSX format (it can't generate the older office formats). It is for .NET and doesn't have the overhead of COM. It's very fast, but the API is, well, complicated. The documentation that comes with it isn't too shabby.
You can download it here: http://msdn.microsoft.com/en-us/library/bb448854.aspx
vcsjones
2010-10-31 21:35:01