By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,070 Members | 1,718 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,070 IT Pros & Developers. It's quick & easy.

passing form data to an email address/Excel sheet on a local computer

P: n/a
Hi,

I am right now learning PHP & want to know if there is a way to send
web form data to an Excel sheet located on a network. My windows xp PC
doesnot have a copy of Excel. Also i am not connected to the internet,
its a local computer.

What i am trying to do is to make a PHP script which will send a simple
form data to an excel sheet (or create a new Excel sheet) on another PC
on a network.

Since i am not connected to the internet, i will not be able to send an
email (anyway, sendmail is not available on Windows OS), nor do i have
any server on windows.

Is it possible to send form data to Excel sheet on local computer? Even
my PC is a local PC. Some one was saying its possible thru Windows
Scheduler.

Please advice.

Warm Regards,

Eijaz

Sep 1 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
>I am right now learning PHP & want to know if there is a way to send
web form data to an Excel sheet located on a network. My windows xp PC
doesnot have a copy of Excel. Also i am not connected to the internet,
its a local computer.
If you don't have a (legal) copy of Excel, you don't have a license
to create Excel spreadsheets.
What i am trying to do is to make a PHP script which will send a simple
form data to an excel sheet (or create a new Excel sheet) on another PC
on a network.
You could create a file which can be imported into Excel (for
example, in .csv format, which, if you've got the data, shouldn't
be too hard to create).
Since i am not connected to the internet, i will not be able to send an
email (anyway, sendmail is not available on Windows OS), nor do i have
any server on windows.
What *DO* you have in the way of communication between the two systems?
A shared file system? A browser on one computer and a web server with
PHP on another?
Is it possible to send form data to Excel sheet on local computer? Even
my PC is a local PC. Some one was saying its possible thru Windows
Scheduler.


Gordon L. Burditt
Sep 1 '05 #2

P: n/a
let me explain in a better way.

I have 2 Local Windows PC's connected thru LAN card. One has PHP
installed, no Servers, no MS Excel. Have a simple webform which i fill
with Data.

The other PC has MS Excel installed, no Servers, no PHP installed.

I want to fill the webform & send the data using Outlook Express or Ms
Outlook or any other means or Transfer it to Excel sheet on other PC or
create a new Excel sheet on other PC using PHP coding.

Please HELP!

Warm Regards,

Eijaz

Sep 1 '05 #3

P: n/a
Hello!
What i am trying to do is to make a PHP script which will send a simple
form data to an excel sheet (or create a new Excel sheet) on another PC
on a network.


You should have a look at PEAR::Spreadsheet_Excel_Writer

You can find it here:
http://pear.php.net/package/Spreadsheet_Excel_Writer
HTH
Hero Wanders
Sep 1 '05 #4

P: n/a
On 31 Aug 2005 17:37:17 -0700, sifar wrote:
I have 2 Local Windows PC's connected thru LAN card. One has PHP
installed, no Servers, no MS Excel. Have a simple webform which i fill
with Data.

The other PC has MS Excel installed, no Servers, no PHP installed.


According to the PHP manual you need a server to run PHP!
Sep 1 '05 #5

P: n/a
On 31 Aug 2005 17:17:08 -0700, sifar wrote:
Hi,

I am right now learning PHP & want to know if there is a way to send
web form data to an Excel sheet located on a network. My windows xp PC
doesnot have a copy of Excel. Also i am not connected to the internet,
its a local computer.

What i am trying to do is to make a PHP script which will send a simple
form data to an excel sheet (or create a new Excel sheet) on another PC
on a network.

Since i am not connected to the internet, i will not be able to send an
email (anyway, sendmail is not available on Windows OS), nor do i have
any server on windows.

Is it possible to send form data to Excel sheet on local computer? Even
my PC is a local PC. Some one was saying its possible thru Windows
Scheduler.


Try doing a Google search for Excel, ODBC, PHP. I'm not sure, but I
think you may be able to create an ODBC DSN then link to that.

I'm not sure also whether you'd get the ODBC drivers - without
installing Office or Excel <??>.

Adam.
Sep 1 '05 #6

P: n/a
sifar wrote:
let me explain in a better way.

I have 2 Local Windows PC's connected thru LAN card. One has PHP
installed, no Servers, no MS Excel. Have a simple webform which i fill
with Data.

The other PC has MS Excel installed, no Servers, no PHP installed.

I want to fill the webform & send the data using Outlook Express or Ms
Outlook or any other means or Transfer it to Excel sheet on other PC or
create a new Excel sheet on other PC using PHP coding.

Please HELP!

Warm Regards,

Eijaz


Hmmm, how do you fill out the web form without IIS or Apache for a web server?
You need something to display the forms.

Once you have the form filled out, there are a couple of ways you could do this.
For instance, you could install ArGoSoft Mail Server, an inexpensive sendmail
replacement. Although I've never done it, you may be able to run Exim, a free,
full MTA (Mail Transport Agent) like sendmail. But the latter is probably
overkill - it does a lot and is hard for the newbie to configure.

Alternatively, you could request the information through your browser. For
instance, you could create a temporary file and dynamically link to that file.
That would allow the user to download the file.

And as others have said, it will probably be easier to generate a CSV file with
the data and import it into Excel than to create a native Excel file.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Sep 1 '05 #7

P: n/a
The form is a simple html form on a local computer.......
I just wanted to transfer text (initally when i was connected to
internet) entered in textboxes or inputs selected, thru mail clients
like MS Outlook or Outlook Express (using the mailto option), which was
happening.
The data does not go or appear. So, i want to use something else. I do
understand i require PHP or Perl with a webserver.
I want to find a way to send the data locally using local network to
another PC (connected to this PC) which has an Excel application &
enter data into Excel.

How do i do that?

Rgds,

Eijaz

Sep 2 '05 #8

P: n/a
Hi Jerry, You said......
Alternatively, you could request the information through your browser.
For
instance, you could create a temporary file and dynamically link to
that file.
That would allow the user to download the file.

I did not understand that....could you please explain????

Sep 2 '05 #9

P: n/a
sifar wrote:
The form is a simple html form on a local computer.......
I just wanted to transfer text (initally when i was connected to
internet) entered in textboxes or inputs selected, thru mail clients
like MS Outlook or Outlook Express (using the mailto option), which was
happening.
The data does not go or appear. So, i want to use something else. I do
understand i require PHP or Perl with a webserver.
I want to find a way to send the data locally using local network to
another PC (connected to this PC) which has an Excel application &
enter data into Excel.

How do i do that?

Rgds,

Eijaz


Hi, Eijaz,

OK, well, you get your web server and PHP set up on your local computer.
That will allow you to fill out the form and get the data into PHP.

Next question - if you weren't using PHP how would you get the data to
the other computer? Email? ftp? Networked Drive? Other?

You can do it the same way with PHP. But first you need to identify how
you would get it to the other system without PHP.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Sep 3 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.