MS Excel Spreadsheet as online form - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

Lightninghawk · 06-08-2011, 03:43 PM

Hey guys, I apologize I know it's not technically a database but I didn't feel this should go in the HTML section either. Please notify me if I should move to a separate area.

I have an excel 2007 spreadsheet that I use to keep up with inventory and closing numbers. I would like to post this on my website and let my employees fill out the numbers and it auto email itself to me as a spreadsheet.

Is this possible? If yes any information on how will be greatly appreciated.

I can provide the spreadsheet if need be just ask

kash · 06-12-2011, 06:00 PM

I think you will need to create a php page for and a database, then set it up so the info pulls out from the databse to a spreadsheet. I dont think there is a way of putting a live ms excel spreadsheet up.

You can try using microsoft skydrive, its free, i think it allows you to share and edit ms documents.

itsmylife · 06-17-2011, 12:32 AM

Hai you can use Online Form and MS Access as Back End ... Even Ms Access having such facility to create a from and embed it with MS excel

rahaul · 06-28-2011, 07:02 AM

Hey hi...as i implement i am giving you the steps for it.

1 Go into Microsoft Excel and open the worksheet you want to make into a Web form.
2 Open the Tools menu and select Wizard, then select Web Form.
3 Follow the instructions in the Web Form wizard.
4 In the second set of instructions, select which cell or range of cells you need data for.
5 Click Next.
6 Select your server type.
7 Click Next.
8 Enter the location and file name of the Web page you're adding the form to.
9 Click Next.
10 Enter your closing message. This message will appear after the Web user enters the required data.
11 Follow the instructions in the Web Form wizard.
12 Click Next.
13 Click Finish.
Thank you.

MBA | MBA Colleges in Mumbai

henault · 06-28-2011, 07:56 AM

You will trying to microsoft excel macro tool. it very helpful if your have an ISP email. otherwise PHP is best for you.

__________________
Email Templates | Resume Templates

balivillas · 08-18-2011, 10:25 PM

I think you could use Google Documents collaboration feature where you can post your excel file and choose people who can save and edit data on it.

senrem8@gmail.com · 08-27-2011, 01:37 AM

Use MS ACCESS

Rukbat · 09-16-2011, 03:59 PM

It's possible - and about as easy as scratching your left elbow with your left hand without breaking your left arm. You just have to write a web-based spreadsheet program. (That's like saying that to pick up all the diamonds on the moon, you "just" have to go to the moon.)

The easiest way to do what you want is as kash said, use a PHP page to allow them to enter data to a database. Then you can use PEAR's Excel library to create a spreadsheet from the database and have it emailed to you, or just go up on the site and ask the page with the PEAR code to send the spreadsheet. It'll send it as a file, which you can view or save, however you have your browser set up for .xls files. (Or you get a popup asking you which you want to do. It all depends on how you have your browser set up. the default is the popup.)