how?

can u give ecxample


how to open xlsx

change cell


write back to xlsx

Hello.

You can find an example here:
code.google.com/p/eisexlsx/

is not working


gives a criple xlsx file unreadable in excel
and errors in display
Deprecated: Function split() is deprecated in C:\wamp\www\welcome\xlsx\eiseXLSX.php on line 508
Call Stack
# Time Memory Function Location
1 0.0015 671432 {main}( ) ..\examplewrite.php:0
2 0.0086 1285768 eiseXLSX->__construct( ) ..\examplewrite.php:26
3 0.0222 1312936 eiseXLSX->getPathByRelTarget( ) ..\eiseXLSX.php:89


idem for the reader

According to that, this isn't working on PHP 5.3, because split() function is deprecated from this version on. Try it on PHP 5.2 and tell us if it works.

got only 5.3.4


cant we replace split() ?

by explode()

// get directory path of rel file
$relFileDirectory = preg_replace("/(_rels)$/", "", dirname($relFilePath));
$arrPath = preg_split("//", rtrim($relFileDirectory, "/"));

// calculate path to target file
$arrTargetPath = preg_split("//", ltrim($targetPath, "/"));



gives errors


( ! ) Warning: Invalid argument supplied for foreach() in C:\wamp\www\welcome\xlsx\eiseXLSX.php on line 107
Call Stack
# Time Memory Function Location
1 0.0023 671416 {main}( ) ..\examplewrite.php:0
2 0.0262 1285768 eiseXLSX->__construct( ) ..\examplewrite.php:26
#0 eiseXLSX_Exception->__construct(can't select sheet #1) called at [C:\wamp\www\welcome\xlsx\eiseXLSX.php:374]
#1 eiseXLSX->selectSheet(1) called at [C:\wamp\www\welcome\xlsx\eiseXLSX.php:123]
#2 eiseXLSX->__construct(templates) called at [C:\wamp\www\welcome\xlsx\examplewrite.php:26]

( ! ) Fatal error: Uncaught eiseXLSX error: can't select sheet #1 thrown in C:\wamp\www\welcome\xlsx\eiseXLSX.php on line 374

with explode no errors

but still criple unreadable file

reader works on normal xlsx files and on file generated xlsx

by


include_once "eiseXLSX.php";

$xlsx = new eiseXLSX("templates");

$xlsx->data('R15C10', 'Hello, world!'); // either A1 or R1C1 are accepted

$xlsx->Output("myfile.xlsx", "F"); // save the file

but this file cannot be read by excel