[ic] Excel/PDF files on-the-fly
Michael Stearne
interchange-users@icdevgroup.org
Mon Aug 26 17:27:01 2002
What do you mean by Excel format? Excel is a closed binary format,
there is no way to make a file that is truly in Excel's native format.
What you might do is just create a CSV file and name it .csv. Excel or
any other spreadsheet that owns the .csv extension in Windows, OS X or
Gnome/KDE will open the file and automatically translate it into it's
native format. As for PDF, you might export the data into an HTML table
and then use HTMLDOC (http://easysw.com/htmldoc/) to convert that HTML
file on-the-fly to a PDF.
Michael
If you name the file .csv Excel will be able to import the file and
convert it automatically.
Rene Hertell wrote:
>Hi,
>
>Has anyone created an excel or PDF file that is always downloadable with the
>source pulled out from the db in real-time? I tried to check the excel
>export-function from the UI, but that contains too many steps (and I don't
>want to write a file to the server when someone downloads these files).
>
>What I would need is a result from a sql query that should be in Excel
>format. A formatted version as a PDF-file would then be my next step after I
>have solved the excel problem...
>
>I'm able to create files that have text-content like vcards, csv-files etc,
>but everything else is seems to be to complicated for the moment...
>
>I would appreciate it very much if someone could give me some hints in how
>to solve these two problems.
>
>
>Regards, Rene
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>
>
>