Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

ASP.NET Forum


You are currently viewing our ASP.NET Forum as a guest. Please register to participate.
Login



Reply
Old 12-21-2004, 07:04 PM Excel Export
marzocchi's Avatar
Junior Talker

Posts: 1
Location: Courtenay, BC
Trades: 0
Hi, this is my first post. I'm normally a PHP kid but the server I'm working with is ASP 3.0 only, which i know a bit about but not much, so what I'm looking to do is I would like to be able to have a page where people could enter text in text box, have each textbox be able to export text contained in the text box into a certain cell (ie. B6) in an Excel Spreadsheet, then send the modified spreadsheet as an attachment to my e-mail address and save a copy of it to a folder on the server while keeping the template unchanged. I'm not sure how or if it can be done. But if anyone could help me it would be greatly appreciated.

Thanks,
Mike

Note: I'm trying to avoid the use of a database but if it requires one the server I'm using only allowed one Access database and I'm not very proficient in ASP or ASP-Access Programming
__________________
I don't know, a proof is a proof. What kind of a proof is a proof? A proof is a proof and when you have a good proof it's because it's proven. - Jean Chretien (former Cdn. Prime Minister)

Last edited by marzocchi; 12-21-2004 at 07:16 PM..
marzocchi is offline
Reply With Quote
View Public Profile Visit marzocchi's homepage!
 
 
Register now for full access!
Old 12-22-2004, 12:05 AM
joltdigital's Avatar
Junior Talker

Posts: 3
Trades: 0
Be much easier to place the result in a tab delimited file and then email that to you where you could do a simple import in to excel. To do what you are looking for on the server would require Excel to be installed on the server which most shared hosts are not going to allow. To work with a text file in asp just do a google for the filesystemobject.
joltdigital is offline
Reply With Quote
View Public Profile
 
Old 01-17-2005, 11:05 PM
Bullschmidt's Avatar
Average Talker

Posts: 24
Location: USA
Trades: 0
Creating the Excel File Server Side
http://www.greggriffiths.org/webdev/...erverside.html
Uses FSO to create a .csv file.

www.asp101.com has some e-mail examples in the Samples section. The e-mail attachment example uses the more recent CDO instead of the tried-and-true but outdated-on-some-newer-servers CDONTS.
__________________
J. Paul Schmidt

Please login or register to view this content. Registration is FREE
- Freelance Web and Database Developer

Please login or register to view this content. Registration is FREE
- Classic ASP Design Tips
Bullschmidt is offline
Reply With Quote
View Public Profile Visit Bullschmidt's homepage!
 
Reply     « Reply to Excel Export
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.11645 seconds with 12 queries