CODEWITHSUNDEEP
phpexcelexcel-2007
dave
dave

Reputation: 1679

importing the data from XLS file to php with simple coding

I have the excel file with the following fields

First   Middle  Last    Email
michael j   jackson [email protected]
mary    j   watson  [email protected]
jeff    a   bridges [email protected]
nick    h   gill    [email protected]

If possible please tell me how can i get the data from Name Box (K8) from the same file

I want to know how can import this data into the php (I m able to upload the excel file on the server)

by using simple code (not any premade script)

Upvotes: 0

Views: 807

Answers (2)

Chandresh Pant
Chandresh Pant

Reputation: 1183

Typically for files like spreadsheets, CSV import is most used. You can export excel file to csv. and then import it using PHP.

See http://in.php.net/manual/en/function.fgetcsv.php

But it seems you are looking to read excel files, you may need help of third-party libraries for that. You also have a look at the following article:

http://www.ibm.com/developerworks/opensource/library/os-phpexcel/

Upvotes: 2

Mark Baker
Mark Baker

Reputation: 212412

You won't be able to write any simple code to read a BIFF file yourself in any reasonable timeframe. Your only quick solution, given an unwillingness to use a library capable of reading BIFF files, is to convert it to a different format (such as CSV) before uploading it.

Alternatively, if you're on a windows server, you could try using PHP's COM extension (as long as you install MS Excel on your server)

Upvotes: 1

Related Questions