How can I generate Excel spreadsheets on the server?
I have a request to output some reports as Excel 2002 tables.
Usually work for reporting services - however that's "not a big IMO" and I hate it, so for this project I used ExtJs - which doesn't do any excel output - not really - but does the UI really do well.
The reports should state that resume grouping and all kinds of formatting are not available if I am using simple XML formatting. This is the one thing that Reporting Services really does well. Gutted.
So ... Does anyone have any suggestions for alternatives to reporting services and definitely not install Office on a server? Crystalline Records is like "not a big IMO" like RS, so not so :)
I looked at aspose et al, but they are a little more expensive and I would like to find something open source if possible, for example using open office - if I can find a way to use the OOo server without actually installing.
Any ideas?
a source to share
If your reports are not very big, perhaps you can get away using the free version of Gembox Spreadsheed ?
a source to share
SpreadsheetGear for .NET can do this and only requires ASP.NET 2.0 on the server (not relying on Excel or any other libraries).
You can see live ASP.NET (VB and C #) Excel report examples here .
If performance is important at all, I would suggest running your own performance tests with your actual data and formatting as you compare your options.
Disclaimer: I own SpreadsheetGear LLC
a source to share
The answer to this depends on budget, time and if you are not allowed to install coms on the server -
for us everything said was negative,
we needed the following:
exporting generic data grouping specific columns summing some columns template-based output
SQL Server Reporting Services offers all of this if - and only if you followed your rules.
what we have now is about the same as heck it's special reporting - using extjs for ui, nhib for windsor for domain lock for binding, and ooxml sdk 2.0 for export.
if you need code to display Ulti level you will get a shout :)
w: //
a source to share
I am working on (right now) a Windows service that generates and merges Excel and PDF on a server, unattended, using SyncFusion XlsIO .
This has been effective so far. The only limitation I ran into was the ability to read some "legacy" html / xml based Excel formats.
Not Open Source, or unfortunately free, but it's a doable option.
a source to share