|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2004-08-27 16:32 UTC] derick@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Oct 30 02:00:01 2025 UTC |
Description: ------------ Installed on Windows2003, Excel 2000, with IIS, the application generate and update Spreadsheet. It creates and opens a Spreadsheet on the client computer, this allow him to save the Spreadsheet on his computer. It works on a wide variety of systes, Windows 95, Windows 98, WIndows XP and Excel 97, Excel 2000, but it doesn't work on client system where there is something named 2003 like Windows 2003 or Excel 2003. Reproduce code: --------------- $exapp = new COM("Excel.application") or Die ("Did not connect"); $file = $path_to_template."\Template_results.xls"; $wkb = $exapp->Workbooks->open($file); $sheets = $wkb->Worksheets(2); #Select the sheet $cell = $sheets->Cells(1,1) ; $cell->activate; #Activate the cell $cell->value = "Hi"; $wkb->SaveAs($file_name); # saves sheet as $file_name $exapp->Quit(); unset($exapp); Actual result: -------------- The spreadsheet is generated and save on the server but is not open on the client system, which is very important because it's the only way for the application to transfer the spreadsheet from the server to the client system.