Solved

Read Excel in php

Posted on 2013-11-08
3
464 Views
Last Modified: 2013-11-08
Does the facility exist to directly read Excel spreadsheet files uploaded to a web server using php?

I know how to read a csv saved excel sheet, but not how to read excel directly.

Thanks
0
Comment
Question by:Richard Korts
  • 2
3 Comments
 
LVL 36

Accepted Solution

by:
Loganathan Natarajan earned 500 total points
ID: 39634186
May be  this helps, http://phpexcel.codeplex.com/

You can read excel directly using this library
0
 
LVL 22

Expert Comment

by:Kim Walker
ID: 39634204
First of all, csv (comma-separated-values) is a comma-delimited ASCII TEXT file. You can save an Excel spreadsheet as a csv file, but it is no longer an Excel file. Because Microsoft Excel maps all .csv files to open in Excel, many people come to believe the .csv is a native Excel file format. But it is not.

PHP has built-in functions for reading .cvs files. For example, fgetcsv() will read a line from a csv file and parse it into an indexed array. The php.net document is good for explaining how to use it.

On the other hand, if you want to read a native Excel file, I have used PHPExcel as an extension to PHP in the past. That was a few years ago. I do remember it worked quite well but I did struggle to understand how to use it.
0
 
LVL 22

Expert Comment

by:Kim Walker
ID: 39634222
Sorry rkorts. Ignore my previous comment. I misinterpreted your question and provided information that you obviously already knew. The rest of my comment duplicates what logudotcom provided.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now