Re: [PHP] Generate a file
On Wed, 10 Jul 2002, Phillip S. Baker wrote: > Okay here is what I want to do. > > Select the field of a database that I want. > Hit submit. > Execute a query of a database based on the said form. > Gather all the data and rows and plug them into an excel generated file. > Display a dialogue box asking the user the save the file. > The saved file being an excel file with data generated from a database. > > Make sense? > > Would the header calls be something like this? > header("Content-type: application/xls"); > header("Content-Disposition: attachment; filename=downloaded.xls"); > > Now if that is cool, how would I get the data into the downloaded.xls file > to have this work? echo "Cell A1\tCellB1\tCellC1\n"; echo "Cell A2\tCellB2\tCellC2\n"; miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Generate a file
Use BiffWriter, I don't know where it lives, you must find it yourself. Phillip S. Baker wrote: > Okay here is what I want to do. > > Select the field of a database that I want. > Hit submit. > Execute a query of a database based on the said form. > Gather all the data and rows and plug them into an excel generated file. > Display a dialogue box asking the user the save the file. > The saved file being an excel file with data generated from a database. > > Make sense? > > Would the header calls be something like this? > header("Content-type: application/xls"); > header("Content-Disposition: attachment; filename=downloaded.xls"); > > Now if that is cool, how would I get the data into the downloaded.xls > file to have this work? > > Thanks > > Phillip > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Generate a file
[snip] Select the field of a database that I want. Hit submit. Execute a query of a database based on the said form. Gather all the data and rows and plug them into an excel generated file. Display a dialogue box asking the user the save the file. The saved file being an excel file with data generated from a database. Make sense? [/snip] Read this article on PHP and Excel, it may help... http://www.evolt.org/article/Using_MySQL_and_PHP_to_Present_Excel_Spreadshee ts/20/26896/index.html Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Generate a file
ðÒÉ×ÅÔ! Phillip S. Baker wrote: > Now if that is cool, how would I get the data into the downloaded.xls > file to have this work? 1) Save the data as a comma-separated list (pap.data.csv). 2) make an excel macro that will load it into a preexisting sheet and treat it 3) put the macro as the auto starter of the sheet. ÐÏËÁ áÌØÂÅÒÔÏ ëÉÅ× @-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@ LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu? lOrD i'M sHiNiNg... YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE tHe TeSt, YeS iT iS ThE tEsT, yEs It Is tHe TeSt, YeS iT iS ThE tEsT, yEs It Is... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Generate a file
Okay here is what I want to do. Select the field of a database that I want. Hit submit. Execute a query of a database based on the said form. Gather all the data and rows and plug them into an excel generated file. Display a dialogue box asking the user the save the file. The saved file being an excel file with data generated from a database. Make sense? Would the header calls be something like this? header("Content-type: application/xls"); header("Content-Disposition: attachment; filename=downloaded.xls"); Now if that is cool, how would I get the data into the downloaded.xls file to have this work? Thanks Phillip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php