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

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

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

>I am right now learning PHP & want to know if there is a way to send[color=blue]
>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.[/color]

If you don't have a (legal) copy of Excel, you don't have a license
to create Excel spreadsheets.
[color=blue]
>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.[/color]

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).
[color=blue]
>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.[/color]

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?
[color=blue]
>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.[/color]

Gordon L. Burditt

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

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

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

Hello!
[color=blue]
> 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.[/color]

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

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

On 31 Aug 2005 17:37:17 -0700, sifar wrote:
[color=blue]
> 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.[/color]

According to the PHP manual you need a server to run PHP!

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

On 31 Aug 2005 17:17:08 -0700, sifar wrote:
[color=blue]
>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.[/color]

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.

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

sifar wrote:[color=blue]
> 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
>[/color]

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.
jstucklex@attglobal.net
==================

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

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

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

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????

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

sifar wrote:[color=blue]
> 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
>[/color]

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.
jstucklex@attglobal.net
==================