Can I read an Excel spreadsheet?

Rob Coventry

Is it possible to read cells from an Excel spreadsheet, and what is the
code for this?

Many thanks.

Rob.

Oct 27 '06 #1

Subscribe Post Reply

1630

Rik

Rob Coventry wrote:

Is it possible to read cells from an Excel spreadsheet, and what is
the code for this?

Simple versions: if you output them as csv offcourse.

Mor complicated: only on Windows, with OLE compatible COM class:
http://www.php.net/manual/en/class.com.php

If you're not on a Windows server, there have been several tries with
reverse-engineering, none of which really satisfy.
--
Rik Wasmus

Oct 27 '06 #2

Petr Vileta

"Rob Coventry" <ro*****@yahoo.com.aupíse v diskusním príspevku
news:11*********************@k70g2000cwa.googlegro ups.com...

Is it possible to read cells from an Excel spreadsheet, and what is the
code for this?

Many thanks.

It is possible in Perl, not in Php. Learn and use Perl instead of PHP ;-)

P.S. Please no flamewar...

--

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)

Oct 27 '06 #3

Andy Hassall

On Fri, 27 Oct 2006 16:25:49 +0200, "Petr Vileta" <st****@practisoft.czwrote:

>"Rob Coventry" <ro*****@yahoo.com.aupíse v diskusním príspevku
news:11*********************@k70g2000cwa.googlegr oups.com...
>Is it possible to read cells from an Excel spreadsheet, and what is the
code for this?

Many thanks.

It is possible in Perl, not in Php. Learn and use Perl instead of PHP ;-)

P.S. Please no flamewar...

No flames, just a link:
http://www.google.co.uk/search?q=php+excel

The Perl solutions may well be more comprehensive, but I've not tried either.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Oct 27 '06 #4

Geoff Muldoon

lu************@hotmail.com says...

Rob Coventry wrote:
Is it possible to read cells from an Excel spreadsheet, and what is
the code for this?

Mor complicated: only on Windows, with OLE compatible COM class:
http://www.php.net/manual/en/class.com.php

If you're not on a Windows server, there have been several tries with
reverse-engineering, none of which really satisfy.

For read (only) as opposed to read/write, I have for some time been using
a class that seems to work perfectly well on Apache/PHP/Linux.

http://sourceforge.net/docman/displa...group_id=99160

Geoff M

Oct 29 '06 #5

by: Roger Twomey | last post by:

I have a form that allows a user to upload a microsoft Excel Spreadsheet. (I am testing with one created in Excel 2000) The spreadsheet is uploaded correctly. It is then supposed to be read...

ASP.NET

Generating XML from Excel / Trapping saved Excel file using FileSystemWatcher

by: Rich Wallace | last post by:

Hello all, Looking for suggestions and tips if possible. I have an application running on a file server that utilizes the FileSystemWatcher to trap when any Excel files are saved by a user. I...

Visual Basic .NET

Using ODBC to read from Excel - mixed format columns

by: Scott M. Lyon | last post by:

I currently am working on a VB.NET application that imports data from an Excel spreadsheet that the customer filled in. I used the following code to use ODBC to read the data from the...

Visual Basic .NET

Using ADO to import Excel into Access Read Only - while file is open

by: Syvman | last post by:

Here's what I've got: I'm trying to grab some data out of an Excel spreadsheet and bring it into Access. I'm able to do it, but only if the Excel spreadsheet is not opened by any other users. I...

Microsoft Access / VBA

Switching between Access and Excel using code

by: garry.oxnard | last post by:

Can anyone help me to solve a problem which involves switching from Access to Excel (then back to Access) programatically please? I have an Excel template which, on open, also opens an Access...

Microsoft Access / VBA

How to read data from Excel spreadsheet?

by: barbara_dave | last post by:

Hi All, I need to read data from a Excel spreadsheet, but I got the problem when I tried the code below: StringBuilder sbConn = new StringBuilder();...

C# / C Sharp

read images/graphics in spreadsheet

by: wstsoi | last post by:

hi I have to read images from spreadsheet, is it possible to do with php?

PHP

To read an excel file with Excel Class in vb.net

by: nudrat | last post by:

I have added a reference Microsoft Excel 5.0 Object Library in my project. the code is as follows: Dim myExcel As Excel.Application ' Interface to Excel Dim myWorkBookCollection As...

.NET Framework

How to read multiple worksheet from a single excel file

by: sejal17 | last post by:

hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...

PHP

how to read multiple worksheet from an excel file using php

by: sejal17 | last post by:

hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...

XML

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

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

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

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

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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

Can I read an Excel spreadsheet?

Similar topics