Excel Exporting
-
No not a programming question. Does anyone has a recommendation of a third party library that can be used to create and manipulate excel files (BIFF) format? Preferably unmanaged but I will not mind a managed one either. I don't want to use the Excel COM automation because Excel may not be installed on the machine where files are generated. The ODBC/OLEDB Jet provider will not work either as I need to create formats.
-
No not a programming question. Does anyone has a recommendation of a third party library that can be used to create and manipulate excel files (BIFF) format? Preferably unmanaged but I will not mind a managed one either. I don't want to use the Excel COM automation because Excel may not be installed on the machine where files are generated. The ODBC/OLEDB Jet provider will not work either as I need to create formats.
The only one I can remember off the top of my head is the one from http://www.aspose.com. It's managed and I don't think you need office. Don't know if it'll do biff (whatever the hell that is, must be a 2007 feature :rolleyes:) though, but as I said it's the only one I can remember off the top of my head.
I have no idea what I just said. But my intentions were sincere.
-
No not a programming question. Does anyone has a recommendation of a third party library that can be used to create and manipulate excel files (BIFF) format? Preferably unmanaged but I will not mind a managed one either. I don't want to use the Excel COM automation because Excel may not be installed on the machine where files are generated. The ODBC/OLEDB Jet provider will not work either as I need to create formats.
Revealing my ignorance, but why not just export to an XML file and go from there?
The worst thing about the miracle of modern communications is the Pavlovian pressure it places upon everyone to communicate whenever a bell rings. - Russell Baker
-
No not a programming question. Does anyone has a recommendation of a third party library that can be used to create and manipulate excel files (BIFF) format? Preferably unmanaged but I will not mind a managed one either. I don't want to use the Excel COM automation because Excel may not be installed on the machine where files are generated. The ODBC/OLEDB Jet provider will not work either as I need to create formats.
xlsgen Cheapest, most comprehensive, most flexible third-party Excel generation component on the market. Supports native Excel 2007 file formats. /Shameless plug
-
Revealing my ignorance, but why not just export to an XML file and go from there?
The worst thing about the miracle of modern communications is the Pavlovian pressure it places upon everyone to communicate whenever a bell rings. - Russell Baker
Jerry Hammond wrote:
why not just export to an XML file and go from there?
Because the XML support was only added in XL 2003 and above. I need the aap run with XL 97 too.
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -Brian Kernighan