|How to create a very simple excel output? [message #987803]
||Wed, 28 November 2012 04:00
| Paul Ramsden
Registered: February 2011
Location: BW, Germany
I want to create a simple tabular report and export it as an Excel xls file. First attempts have shown the following problems:|
- extra columns and rows are inserted around EVERY table cell (this seems to be caused by the cell padding. When set to zero the extra rows/columns disappeared)
- extra rows inserted when row width exceeds nominal page width (presumably to allow cell texts to wrap)
- extra sheets inserted when row count exceeds nominal page height
These are all clever solutions when a 'pretty' report is needed but is there a way to create an xls output when one table cell in the report corresponds to one table cell in the spreadsheet - no more and no less?
I know that there is a CSV emitter but I'm a bit wary of using CVS because of localization issues (decimal points/commas, cell separation characters etc)
Has anyone else had this problem?
Powered by FUDForum
. Page generated in 0.02629 seconds