Hey guys

I was hoping someone could shed some light on some research I'm doing.

Basically, I want to know if I can use PHP to read n number of cells from an excel file. Based on each cells color, I want that cell value to be written to a different table in an SQL database.

So say I have a spreadsheet with 10 cells, the first cell is green, so it's contents are qrittent to the Green table in my SQL database, the second cell is Purple, so its contents are written to the Purple table in my SQL database etc...

If this is not possible in PHP, could someone please tell me what language I could do this in?

Thanks for any help!

Hmm I'd really prefer to write teh code myself as it is for a client.

Is there any other way, maybe a tutorial? Or maybe another language would let me write code to do this?

Thanks for your help!

Well, if you are on a windows machine, look into using COM extension.