473,288 Members | 1,743 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,288 software developers and data experts.

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

Sep 1 '05 #1
9 4253
>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
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
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Harshal | last post by:
Hi all, we are trying to load Korean data from a Excel Sheet in to Oracle Database (8.1.7.3 with NLS_LANG=American_America.UTF8) We successfully transferred the Unicode file to our Unix...
1
by: S. van Beek | last post by:
Dear reader, Is there somebody who can tell me the VBA code for the following action? To import data from an Excel sheet by referring to a cell name in the Excel sheet.
3
by: natrajsr | last post by:
Hi, I want to load the data of a excel sheet or in the exact excel sheet format into a Rich TextBox control. I have already worked with loading WORD into a Rich TextBox. It is working fine.;...
0
by: derik | last post by:
can anyone help how to create a table in sql wit the data given in excel sheet
7
by: eklavyavats | last post by:
I am able to import data from the database to excel sheet. But i was unable to load the data from the excel sheet to my sql.I have connected the excel sheet to my sql but the data that is imported to...
3
by: smith jones | last post by:
Hi all, Can you plz guide me as to how to write data to an excel sheet using C+ + code? Thnks very much for your help!!!
0
by: safh | last post by:
hi, i need urgently a help to retrieve data from an excel sheet(all values of a single column one by one) and need to match with all the values of a column in a table of a database(oracle). it is...
1
by: ielamrani | last post by:
Hi, I have the following code which works fine. It export current access form record to an excel sheet: DoCmd.OutputTo acOutputForm, "frmsubformtest", acFormatXLS, "C:\Details.xls", True Is it...
4
ammoos
by: ammoos | last post by:
Hi Friends, I need to read data from an excel sheet. I am keeping this excel sheet in a remote machine. I am using OLEDB connection to read the data from this excel sheet. But when I am trying to...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.