VFP 愛用者社區

[kib48660]

請問在INTERNET上大家報表都是用那套軟體產生

[ckp6250]

excel 類的，例如 phpexcel

[syntech]

[ckp6250]

我本來是想講【phpspreadsheet】
但字母實在太長，只好說是 phpexcel

[syntech]

[CPS0204]

php+phpspreadsheet 好用
但轉出excel 時, 另存新檔下載excel後,會有亂碼

需在給cell 任何values 前,一定要有下行:


ob_end_clean(); //這行一定要有
$sheet->setCellValue("c1",'this is a book' );

[color=blue] $excel_name = 'test21';
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $excel_name . '.xlsx"');
header('Cache-Control: max-age=0'); // 禁止緩存
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
$writer = new Xlsx($spreadsheet);
#$writer=IOFactory::createWriter($spreadsheet,'Xlsx'); //用這行會報錯
$writer->save('php://output');[/color]

[jelinek]

ActiveVFP只需要一小段程式碼轉excel就達成目的

<%
SET EXACT ON
SET CENTURY ON
Set date to ymd

*sql
oSQL.cSQLCursor = "curOrder"
lsqlwhere = "where orderdate>='"+DTOC(DATE())+"'
oSQL.Execute([SELECT o.* FROM orders o left outer join users u on o.uid=u.id ]+ lsqlwhere +[ order by orderdate])
lcf=ALLTRIM(STR(INT(SECONDS()*1000)))
lcM=[COPY TO ]+oProp.AppStartPath+[Temp\]+lcf+[ type xls]
&lcM
lcNewPath = [http://]+oRequest.ServerVariables("HTTP_HOST") +JustPath(oRequest.ServerVariables("URL"))+[/Temp/]+lcf+[.xls]
oResponse.Redirect(lcNewPath)



RELEASE PROCEDURE oProp.AppStartPath+'prg\dputil'
%>

[CPS0204]

PHP 呼叫 VFP 的 COM

由COM內, 拋轉EXCEL更方便操作,老習慣也不需要改!
但com缺點是,生成的xls只能放php server上,無法存在用戶端的pc上

phpspreadsheet 比不上個人的老程式(vfp->xls)
給推一個!

[chilin]

[syntech]

如果你沒用到特殊欄位,或是先把欄位處理一下的話
建議用

COPY TO TYPE FOX2X