RE: [flexcoders] Excel Export

Wed, 14 Jun 2006 07:00:27 -0700

That’s great – thanks!

 

From: [email protected] [mailto:[email protected]] On Behalf Of Steve Gustafson
Sent: Wednesday, June 14, 2006 8:59 AM
To: [email protected]
Subject: Re: [flexcoders] Excel Export

 

Jim,

What I mean by "true" Excel files is a binary file that is native to Excel.  Not a delimited text file, or HTML file that Excel can open.

The difference is that by generating a "true" Excel file with POI-HSSF, you have the ability to:

  • create multiple worksheets
  • split and freeze panes
  • draw shapes
  • outlining
  • set the data format of cells
  • merge cells
  • set print area
  • color cells and text
  • use formulas
  • reference other cells and worksheets
  • etc. etc. etc. 

Some of this can be done with HTML, but not all.

Using CFCONTENT does not generate a binary Excel file, it simply sets the MIME type to "application/msexcel" but the file is still a text file that is either delimited or HTML.

This may be more than the original poster was looking to do, and in many cases a CSV or HTML file is adequate, however POI-HSSF brings a whole 'nother level of power to using server data with Excel.

Here is a link to Busy Develepors Guide to HSSF Features

Gus

On 6/13/06, Jim Robson < [EMAIL PROTECTED]> wrote:

Steve,

 

Not sure what you mean by "true" Excel files, but CF does natively provide the ability to generate .xls files using the cfcontent tag:

 

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=part_cfm.htm

 

-Jim

 

 

__._,_.___

--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com




SPONSORED LINKS
Web site design development Computer software development Software design and development
Macromedia flex Software development best practice

YAHOO! GROUPS LINKS



__,_._,___

Reply via email to