Den -
Thanks for the info. I'd never heard of JExcelAPI but I've used Jasper on some
previous Java-based contracts and, yes, it's great.
Problem is that this client is on shared hosting (CrystalTech) so my ability to
install 3rd-party libraries is essentially zero. Unless someone knows of a
The Excel approach seemed like a winner but in the end, I had to ditch it. In
the end, I hit what appears to be a well-known problem and a known limitation
for cfspreadsheet. The current design of the spreadsheet functionality makes
it hard (impossible?) to optimally share cell formats across
There's also JExcelAPI for generating Excel files. Way nicer API than
POI, and I've got a custom tag somewhere around here for using it, if
you're interested.
Really though, I'd recommend using JasperReports. It's an *awesome*
reporting engine, and has a *kick ass* GUI report editor (that is
their requirements preclude me from going the old way of
generating HTML and setting the MIME type to Excel).
Are there additional requirements? Because the A4 page size and rotated text
could probably be achieved with xml or the old html/mso schemas.
Leigh - Curious what you mean by 'acheived with xml'. What would I feed the XML
into?
I have made progress experimenting with the spreadsheet functions and for the
most part, things work well including text rotation. I wish there were a way to
set the default page size in Page Setup but I can
I meant you could use Excel's ability to interpret html/xml to do both of
things (and more) if you preferred to stick with old approach.
http://cfsilence.com/blog/client/index.cfm/2006/7/19/Creating-Multiple-Tabs-in-Excel-with-Coldfusion
A customer is asking me to generate an Excel spreadsheet and I've never used
the new functions in CF9 (their requirements preclude me from going the old
way of generating HTML and setting the MIME type to Excel). Two q's after I've
done some research both with Google and Adobe's docs:
- how
Alternatively, if someone knows how to do rotated text when generating a PDF,
I'd love to learn how.
~|
Order the Adobe Coldfusion Anthology now!
8 matches
Mail list logo