Re: [PHP-DB] *.xls
HI, We are trying to do some functions to export data from database to Excel format. We have specyfication of the excel file format, and we are trying to generate binary file bite by bite, but we have problems with borders and frames. Maybe someone hes experienced similar problems? best regards Jarry Steve Brett wrote: i'd also be interested in this ... i have some code that will create .csv files for download, whihc is the way i normally do it. Steve -Original Message- From: Aivar Annamaa [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 13:02 To: [EMAIL PROTECTED] Subject: [PHP-DB] *.xls Hi Does anyone know some lib for generating excel files. I ask it here because database people could use such thing. Aivar Annamaa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] *.xls
it's VB ? -Original Message- From: Hans-Werner Guth [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 14:32 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] *.xls Hi, ...write to an XLS file without DLL's or Excel automation... visit: http://www.planet-source-code.com/xq/ASP/txtCodeId.11898/lngWI d.1/qx/vb/scripts/ShowCode.htm Adaran (Marc E. Brinkmann) wrote: Hi Steve Brett, Wednesday, May 09, 2001, 12:24:02 PM, you wrote: Steve could you send me the specs for the excel format ? Steve Steve Best thing would be to post it here, or a link at least. I think many people could use this! --- EnjoY, Adaran ([EMAIL PROTECTED]) check http://www.adaran.net ...snipp... -- Hans-Werner Guth S http://www.qits.de QITS GmbH T mailto:[EMAIL PROTECTED] Formerstr 53 I fon +49-2102-852-145 40878 Ratingen Q fax +49-2102-852-202 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] *.xls
Inside the downloadable ZIP file there Excel Clas17881432001.zip http://www.planet-source-code.com/xq/ASP/txtCodeId.11898/lngWId.1/qx/vb/scripts/ShowCode.htm you find a file called excel.txt containing a description of the MS-Excel File format: the first few lines: MICROSOFT EXCEL BINARY FILE FORMAT -- Mark O'Brien Microsoft Corporation 18-Feb-1988 Table of Contents - Introduction General BIFF Record Format Rows and Columns Within BIFF Cell Table - Concepts Cell Records Record Types Cell Attributes Order of Records Finding Values From BIFF Files Excel Formulas Expression Evaluation Unary Operators Binary Operators Operand Tokens - Constant Operand Tokens - Classes Operand Tokens - Base Control Tokens Function Operators Reserved Ptg's Scanning a Parsed Expression Excel Function Table Command Equivalent Function Table List of Ptg's Steve Brett wrote: it's VB ? -Original Message- From: Hans-Werner Guth [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 14:32 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] *.xls Hi, ...write to an XLS file without DLL's or Excel automation... visit: http://www.planet-source-code.com/xq/ASP/txtCodeId.11898/lngWI d.1/qx/vb/scripts/ShowCode.htm ...snipp... -- Hans-Werner Guth S http://www.qits.de QITS GmbH T mailto:[EMAIL PROTECTED] Formerstr 53 I fon +49-2102-852-145 40878 Ratingen Q fax +49-2102-852-202 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] *.xls
a. many thanks :-) Steve -Original Message- From: Hans-Werner Guth [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 15:09 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] *.xls Inside the downloadable ZIP file there Excel Clas17881432001.zip http://www.planet-source-code.com/xq/ASP/txtCodeId.11898/lngWI d.1/qx/vb/scripts/ShowCode.htm you find a file called excel.txt containing a description of the MS-Excel File format: the first few lines: MICROSOFT EXCEL BINARY FILE FORMAT -- Mark O'Brien Microsoft Corporation 18-Feb-1988 Table of Contents - Introduction General BIFF Record Format Rows and Columns Within BIFF Cell Table - Concepts Cell Records Record Types Cell Attributes Order of Records Finding Values From BIFF Files Excel Formulas Expression Evaluation Unary Operators Binary Operators Operand Tokens - Constant Operand Tokens - Classes Operand Tokens - Base Control Tokens Function Operators Reserved Ptg's Scanning a Parsed Expression Excel Function Table Command Equivalent Function Table List of Ptg's Steve Brett wrote: it's VB ? -Original Message- From: Hans-Werner Guth [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 14:32 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] *.xls Hi, ...write to an XLS file without DLL's or Excel automation... visit: http://www.planet-source-code.com/xq/ASP/txtCodeId.11898/lngWI d.1/qx/vb/scripts/ShowCode.htm ...snipp... -- Hans-Werner Guth S http://www.qits.de QITS GmbH T mailto:[EMAIL PROTECTED] Formerstr 53 I fon +49-2102-852-145 40878 Ratingen Q fax +49-2102-852-202 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] *.xls
i'd also be interested in this ... i have some code that will create .csv files for download, whihc is the way i normally do it. Steve -Original Message- From: Aivar Annamaa [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 13:02 To: [EMAIL PROTECTED] Subject: [PHP-DB] *.xls Hi Does anyone know some lib for generating excel files. I ask it here because database people could use such thing. Aivar Annamaa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]