Solved

Exporting to an Excel Database

Posted on 2003-11-19
9
406 Views
Last Modified: 2010-04-01
Hey,

I retrieve data from a database, put the information in a table(html) and allow the user of the application to view it in excel if he/she so chooses. I would like to put different tables into different workbooks inside excel.

Anyone have a suggestion?

Thanks,

Weber
0
Comment
Question by:webhsu
  • 4
  • 3
  • 2
9 Comments
 
LVL 3

Expert Comment

by:applekanna
ID: 9781901
set the contect type as "text/vnd.msexcel"
0
 
LVL 3

Expert Comment

by:applekanna
ID: 9781941
typo there

response.setContentType("application/vnd.ms-excel")
0
 
LVL 3

Expert Comment

by:applekanna
ID: 9781974
0
 
LVL 3

Expert Comment

by:applekanna
ID: 9781985
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:webhsu
ID: 9782210
I actually have exported data to excel already. just need to split it into different workbooks within the same excel session.
0
 
LVL 15

Accepted Solution

by:
jimmack earned 250 total points
ID: 9783616
Try this one:

http://www.tek-tips.com/gviewthread.cfm/pid/426/qid/536425

Scroll down to May 15 2003.  Tarwn explains how to do this using ASP, but apart from changing:

<%
Response.ContentType = "application/vnd.ms-excel"
%>

to

<%
response.setContentType("application/vnd.ms-excel");
%>

I think that should just about do it ;-)
0
 
LVL 15

Expert Comment

by:jimmack
ID: 9788548
Thanx.

I'm glad it's worked.  Could you confirm which versions of Excel this works with please?  (I'm a Linux user so it's a bit difficult to check ;-))
0
 

Author Comment

by:webhsu
ID: 9796675
office 2k.
0
 
LVL 15

Expert Comment

by:jimmack
ID: 9796826
Thank you ;-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
java beans and EJBs 5 185
iterator example remove 8 74
sortaSum challenge java 17 171
countXY challenge 28 145
With more and more people tethered to the internet, advertisers can reach you in new and creative ways. Push notifications on your smartphone, customized advertisements based on your previous searches, and email inboxes filled with promotional pitch…
Facing problems with you memory card? Cannot access your memory card? All stored data, images, videos are lost? If these are your questions...than this small article might help you out in retrieving your lost or inaccessible data.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now