cdms
Posts: 2
|
| Posted: 04/27/2008, 1:58 AM |
|
Dear all,
having searched through all posts with regards to EXcel Export, I got the Export working, which is great 
However I have one problem in CCS with PHP: I want to store the result file to the webserver in a dedicated folder. I don't want the user to store it through "save as" or something similar.
Target is to store in dedicated folder with dedicated filename ( including timestamp to have it unique ). Then, at a later stage a cronjob will pick up the stored files and process them further.
Any help/hint will be highly appreciated, as I'm quite new to PHP and CCS and trying to solve this issue now since several days with no effort.
thanks and rgds
Michael
|
 |
 |
smokingguns
Posts: 51
|
| Posted: 04/27/2008, 11:46 AM |
|
Hey,
refer PHPExcel (http://www.codeplex.com/PHPExcel). This has to be the best 'export to excel' option till now. It saves the excel file to the server by default, for security. Here are some of the features:
1. create worksheets etc.
|
|
|
|
cdms
Posts: 2
|
| Posted: 04/27/2008, 9:00 PM |
|
smokingguns, thanks for the tip.
Any idea how that could work with a pure textfile ( flatfile )? The examples from CCS creates a html syntax, which would be sufficent for me. I only need to store it on the server rather than asking the user, where to download the file to.
thanks and rgds
Michael
|
|
|
|
smokingguns
Posts: 51
|
| Posted: 04/28/2008, 4:32 PM |
|
Hey michael,
PHPexcel allows you 2 read different file formats into your spreadsheet object
1.Excel 2007 (spreadsheetML)
2.CSV (Comma Separated Values)
and allows you to output to different file formats:
Excel 2007 (spreadsheetML)
BIFF5 (Excel 97 and higher)
CSV (Comma Separated Values)
HTML
The library has plenty of examples. Hope u njoy using this library as much as I have
|
|
|
|
|
