Member Avatar for 2eXtreme

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!

  • 2 Contributors
  • 3 Replies
  • 79 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by buddylee17
Member Avatar for buddylee17

I believe PHP Excel Explorer can read the cell styles. I looked into it a while back and wound up not needing it.

Member Avatar for 2eXtreme

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!

Member Avatar for buddylee17

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.