473,326 Members | 2,010 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,326 software developers and data experts.

HTML form to Excel

I have created several online forms that when the "submit" button is
clicked results are emailed to us, then manually entered into excel.

we need to automate the process so that this info can be received or
imported into excel with specific columns for each field. Any advice
on how to approach this?

I would think that this is something that would be more readily
available as there has to be a demand for this kind of task.

Jul 31 '08 #1
4 13996
On Jul 31, 12:22 pm, Michael Vilain <vil...@NOspamcop.netwrote:
In article
<d416f518-72d3-4996-9666-4bb2c7018...@b1g2000hsg.googlegroups.com>,

rp...@tjpdc.org wrote:
I have created several online forms that when the "submit" button is
clicked results are emailed to us, then manually entered into excel.
we need to automate the process so that this info can be received or
imported into excel with specific columns for each field. Any advice
on how to approach this?
I would think that this is something that would be more readily
available as there has to be a demand for this kind of task.

As you've discovered, the manual process of email to Excel is a PITA.

There are several options you can go with here. It all comes down to
what your level of programming skill is. HTML web pages can't be
automatically imported into Excel without formatting them correctly.
The most common import format is "CSV" or comma separated value. The
form can be coded to send the email in this form or stored in a database
for extraction by a report that creates a CSV file by scanning the
database.

This is way outside the scope of a HTML slinger and you'll probably have
to hire someone to code it for you.

Good luck.

--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically by ignored]
Yes, I am closer to an HTML slinger than a programmer. I need to make
this happen so I am trying to get some direction. I have seen examples
of how it has been done with .asp and php. Was just curious how others
were approaching the problem.
Jul 31 '08 #2
rp***@tjpdc.org wrote:
Yes, I am closer to an HTML slinger than a programmer. I need to make
this happen so I am trying to get some direction. I have seen
examples of how it has been done with .asp and php. Was just curious
how others were approaching the problem.
I'm a Perl guy, so I would look for a Perl solution. Perl has modules
available that can be used to convert raw data into Excel files.
Jul 31 '08 #3
Michael Vilain <vi****@NOspamcop.netwrites:
In article <df******************************@comcast.com>,
Scott Bryce <sb****@scottbryce.comwrote:
>rp***@tjpdc.org wrote:
Yes, I am closer to an HTML slinger than a programmer. I need to make
this happen so I am trying to get some direction. I have seen
examples of how it has been done with .asp and php. Was just curious
how others were approaching the problem.

I'm a Perl guy, so I would look for a Perl solution. Perl has modules
available that can be used to convert raw data into Excel files.

And you'd need perl modules to mail attachements. If the form this guy
envisions were on my To Do list, I'd have the perl CGI script take the
data from the form, convert it to an excel file, email that file as an
attachment, then delete the file (lots of programmers for get this step
and they don't clean their rooms or desks either).
I've done this for a couple of sites and my preferred method if for
the script on the page (I've used Perl and PHP or different occasions)
to write a CSV line to a plain text file.

I then provide a simple admin page that includes a button or link that
sends the file as type text/csv (IIRC) so that the non-technical user
is prompted to open it with Excel. The down side is you import the
whole thing every time. The upside is all the data is always
available on the server.

As you say, not for a non-programmer but it is a matter of an hour or
so's work (less if you have done it before) so it would not be costly.

--
Ben.
Aug 1 '08 #4
Gazing into my crystal ball I observed rp***@tjpdc.org writing in
news:d4**********************************@b1g2000h sg.googlegroups.com:
I have created several online forms that when the "submit" button is
clicked results are emailed to us, then manually entered into excel.

we need to automate the process so that this info can be received or
imported into excel with specific columns for each field. Any advice
on how to approach this?

I would think that this is something that would be more readily
available as there has to be a demand for this kind of task.
I have to ask, why the need to put it into Excel? What happens to the
Excel data later?

Here's what I might do:
1. Validate the form input and put it into a db
2. Run a query against the db for those fields and data
3. Serve up an excel file with that data

--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

Aug 1 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: mike | last post by:
ok here's the problem: I have a page that displays a form for user to select individual fields and to specify their own criteria which is used to query a database and then create an excel...
3
by: Prakash | last post by:
Hi, We face problems uploading excel (with macros) documents using HTML File Upload. The file contents are corrupted while viewing the same. However, we are able to upload excel (w/o. macros)...
2
by: Matthew | last post by:
I've been trying to find a way to gather up data contained in a table or tables on a previously generated html page in order to send it to a cgi for further processing. Ideally this would scrape...
1
by: patricia-gail | last post by:
can anyone please help me? i have made a form (actually a survey) in html and when the users submit their results i need them to go into an excel form. or a .txt file that can be later put into...
0
by: Sonnich | last post by:
Hi all! I haven't being doing that much in ASP, but I have to create this: It has to read out data from some DB to excel. The following (corrected) code works if just it outputs as html, once...
0
by: kailashrathi | last post by:
Please tell me the Coding for the form ACTION "" and other realted coding for : I have made a form (actually a survey) in html. I NEED: when the users submit their results (RADIO BUTTON) the...
1
by: nufanvandal | last post by:
Hello, I created a web form in html, I need to create a server-side script using ASP and embed it into the html, so that when the user clicks submit, it sends(saves) the data from text boxes,...
0
by: arindams | last post by:
I've a form where an webrowser contains a html file. I want to copy a selective portion of the html content and paste that content in an excel 2007 file where it will be pasted as a normal text (not...
1
by: swarnarami | last post by:
i have made a form (actually a survey) in html and when the users submit their results i need them to go into an excel form. or a .txt file that can be later put into an excel form.
0
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...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.