Form to Excel

[jfred1979]

I have a client requesting a form data be placed in an Excel file. Since I'm not great with this sort of thing I'm wondering if anyone could give me some input on what the best solution is. If my memory serves me correctly, Excel can import a text file that has commas as delimeters. So I guess in a worst case scenario tracking down a script that turns form data into a text file like this would work. I'd like something a little more elegant that's more transparent to the client....

[Iguana]

If giving the user an excel page and letting the user save it is acceptable then you can just change the header to be

Response.ContentType = "application/vnd.ms-excel"

and excel will start up in the broswer and turn any tables into excel - and many versions will even use the stylesheet.

[DylanW]

Depending on how your client wants to use this data in Excel, you could use the Web Query feature (it's under the Data menu). All Web Query does is access a web page and import tables into Excel. You'd have to build a script to serve as the "interface" to this, which would just take all that form data and put it into HTML tables. The nice thing about this is once you set it up, you can have Excel refresh the data automatically.

[bilalak]

Hi
You can open the excell using an ASP control. Or you can post the form data to a csv file that can be easily open in Excel and used like a real worksheet.