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

1616

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

How to calculate date of retirement from date of birth

by: Mushico | last post by:

How to calculate date of retirement from date of birth

Data Management

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA

Can I read an Excel spreadsheet?

Similar topics