Help in COM Object

jeff_cmw

I am having a problem in working on COM Object. What I would like to achieve is to upload en Excel file which contains many columns and about 30 rows, then read everything into the MySQL database in the same format as excel.

Actually I found the code in PHP.net

$col = C;
$row = 4;

$excel_app = new COM("Excel.application") or Die ("Did not connect");

print "Application name: {$excel_app->Application->value}\n" ;
print "Loaded version: {$excel_app->Application->version}\n";
$Workbook = $excel_app->Workbooks->Open("$file") or Die("Did not open $file $Workbook");
$Worksheet = $Workbook->Worksheets($sheet1);
$Worksheet->activate;
$excel_cell = $Worksheet->Range("$col$row");
$excel_cell->activate;
$excel_result = $excel_cell->value;
print "$excel_result\n";

But I just couldn't find anything else on the use on COM Object. Anyone please could help me to solve this problem or provide any site which has source/information on the COM Object?

Thanks a lot

AstroTeg

That looks about right.

Trivia question: Is your web server Microsoft based? And does it have Office installed?

If its neither, then you're stuck. If its just Windows, then part of the problem is solved. You just have to install office on the server. If Office is already installed, then what error are you getting?

jeff_cmw

The connection is fine, just could not find any resources to work on the COM object.. like the coding stuff (API) or example.. like what we found in PHP.net.

Or do you have any suggestions on achieving the task i mentioned?

'upload en Excel file which contains many columns and about 30 rows, then read everything into the MySQL database in the same format as excel. '

Cheers

AstroTeg

I'm pretty sure if you look harder out on the 'net you'll find something on using Excel's COM interface (remember, it may not be PHP code, but what you do find can be translated to PHP rather easily - hint: V😎.

But if you don't want to go that route, you have the option of using Perl. Perl requires a 3rd part Excel module (forgot the exact name). If its a *nix based host, they probably already have it installed. The Perl module does a really great job at reading an Excel file. You have to have it generate the CSV output, but that isn't too bad.