analysing & converting EXCEL doc to mysql database, POSSIBLE ???

[marconi8]

....HOWTO make this,

maybe anyone now some links or mans

[jeroom]

if you save your document as csv you easily can use fgetcsv(); for that

[bulanov]

Look here:

// starting Excel
$excel = new COM("Excel.application") or die("Unable to instanciate Excel!");
print "Loaded Excel, version {$excel->Version}\n";

//bring it to front
$excel->Visible = 1;

//open document
$wb=$excel->Workbooks->open('mytable.xls');

//do something
$cellA1=$wb->cells(1,1)->value;

print "Cell \"A1\" has a value $cellA1\nThank you. \n Closing..";

//closing Excel
$excel->Quit();

//free the object
$excel->Release();
$excel = null; 

---

With best regards,
Serge Bulanov
AlarIT Web developer,
www.AlarIT.com

[tomhath]

Beautiful post Serge.

Consider adding that to the Code Snippets library on this site...🆒

[srikanth1184]

Does this work on LINUX /UNIX plotforms ??

[jsim]

This use COM which is not available on *nix.
To read almost any possible data (not just cell data but cell formats, etc) take a look at
excelexplorer