Manual/Source code za klasu COM("Excel.sheet")
20.04.2010. u 21:10 · pre 201 meseci
#1
treba mi link za manual il souce code
da bi mogo da vidim kako da prochitam celiju po imenu, ne po koordinatama.
npr:
$workbook = "fajl.xls";
$ex = new COM("Excel.sheet") or Die ("Did not connect");
$wkb = $ex->application->Workbooks->Open($workbook) or Die ("Did not open");
$sheets = $wkb->Worksheets($sheet); #Select the sheet
$sheets->activate; #Activate it
$cell = $sheets->Cells(3,3) ; #Select the cell (Row Column number)
umesto tog Cells(3,3)
treba mi polje kome je dodeljeno simbolicko ime "polje1"
da bi mogo da vidim kako da prochitam celiju po imenu, ne po koordinatama.
npr:
$workbook = "fajl.xls";
$ex = new COM("Excel.sheet") or Die ("Did not connect");
$wkb = $ex->application->Workbooks->Open($workbook) or Die ("Did not open");
$sheets = $wkb->Worksheets($sheet); #Select the sheet
$sheets->activate; #Activate it
$cell = $sheets->Cells(3,3) ; #Select the cell (Row Column number)
umesto tog Cells(3,3)
treba mi polje kome je dodeljeno simbolicko ime "polje1"
Potpis
jedan smeshni nekomercijalni video: http://www.develop-one.net/blog/2008/08/27/HugADeveloper.aspx