Reading Excel files using PHP

Hemanth

Hello there,

Could someone pls give me pointers (or examples) on how to use PHP
(installed on a linux) to read & write MS Excel spreadsheets. So far
I've been converting a spreadsheet to text (as tab separated values)
and processing the text file. I'm wondering if I can avoid this step
and process the .xls file directly.

I found a thread in this group - related to this topic - but it says,
MS excel needs to be installed on target machine to use PHP's COM. I
assume he's talking about PHP running on windows target machine. How
can I use a similar approach on linux machine?

http://groups.google.com/group/comp....00071ba2b4434e

Any help is appreciated.

Regards,
Hemanth

Nov 1 '05 #1

Subscribe Post Reply

9745

Geoff Muldoon

he*****************@gmail.com says...

Could someone pls give me pointers (or examples) on how to use PHP
(installed on a linux) to read & write MS Excel spreadsheets. So far
I've been converting a spreadsheet to text (as tab separated values)
and processing the text file. I'm wondering if I can avoid this step
and process the .xls file directly.

I found a thread in this group - related to this topic - but it says,
MS excel needs to be installed on target machine to use PHP's COM. I
assume he's talking about PHP running on windows target machine. How
can I use a similar approach on linux machine?

I found a couple of class files which allow you to read Excel format files
on any platform:
http://sourceforge.net/projects/phpexcelreader/

I had also considered another one:
http://paggard.com/projects/xls.reader/

Geoff M

Nov 2 '05 #2

by: Roland Hall | last post by:

I have two(2) issues. I'm experiencing a little difficulty and having to resort to a work around. I already found one bug, although stated the bug was only in ODBC, which I'm not using. It...

ASP / Active Server Pages

Reading XML Excel into a dataset

by: Alex Shirley | last post by:

Hi I'm still banging my head on how to import an Excel XML spreadsheet into a dataset. The code will work for standard XML files, but not XML files made with Excel (I get 'Specified cast is not...

.NET Framework

reading from text file to excel file

by: mail2atulmehta | last post by:

Hi, I do not know if this is right place for this, but i need some help. I have a text file, whose values are seprated by a delimiter. I want to open this file in excel, ( not import it) . I have...

C / C++

R: reading an excel file in C?

by: Turner, GS \(Geoff\) | last post by:

> -----Original Message----- > From: siliconwafer > Posted At: 19 August 2005 15:20 > Posted To: c > Conversation: reading an excel file in C? > Subject: reading an excel file in C? > > >...

C / C++

Reading/Writing to Excel BIFF file

by: Jon Brookins | last post by:

I'm reposting this question as the other post seems to have been sucked into the net black hole. I'll keep this short. I am trying to read and edit an Excel workbook in its native BIFF format. ...

C# / C Sharp

Problem reading text/numeric data from Excel

by: Scott M. Lyon | last post by:

I've just discovered a bug in some code I wrote a little while ago, and I need you guys' help to fix it. My program imports data from a standard Excel Spreadsheet (just with specific column...

Visual Basic .NET

Reading Excel sheet into DB Table

by: dba123 | last post by:

I need some help and direction on what classes and an example or two (article) on how to read an Excel Worksheet and insert one column into a database table column. I am using .NET 2.0 only. What...

C# / C Sharp

Reading multiple excel files and consolidating into one!!!

by: stephen | last post by:

Hi, I have 5 excel files and they have multiple sheets. I have to read (say sheet 3) of each of the 5 excel files and consolidate them into one. what's the best way to achieve this. if someone...

ASP.NET

Please, help with word and excel opening/reading problem

by: navanova | last post by:

Greetings, I have a problem of opening ms word and excel files on my computer. The files are there for a long time. I use to open and modify them. Suddenly, when i try to open the word files, a...

Microsoft Windows

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Reading Excel files using PHP

Similar topics