May
|
| Posted: 04/10/2002, 10:19 AM |
|
Can somebody please help on how to export the data on a grid (search result) to Excel??? Thank you in advance.
|
|
|
 |
tom
|
| Posted: 04/10/2002, 4:32 PM |
|
May, I have 2 pages. First page is Search with fields to search. Second has fields to display in Grid with input parameters from search page. Then in Events/Open paste this code::
'No Header or Footer needed
sHeaderFileName=""
sFooterFileName=""
'Change HTML header to specify Excel's MIME content type
Response.Contenttype="application/vnd.ms-excel"
Hope this helps
|
|
|
|
May
|
| Posted: 04/10/2002, 6:40 PM |
|
I'm sorry I didn't explain it further....
This is what I have.....First page is the search page with fields where I make the search. Then the second page is where I display the info. What I would like to do is to have a link at the bottom of the second page where I can re-direct the user to export the input params from search page to Excel.
Is this possible????
Thanks again.
|
|
|
|
Nicole
|
| Posted: 04/11/2002, 1:51 AM |
|
May,
create additional page with Grid form the same as result grid form and pass input search parameters to it. At the result grid form header or footer put link to this page. This page will be used to write excel file. Create it as described in Tom's response.
|
|
|
|
Tom
|
| Posted: 04/11/2002, 5:53 AM |
|
Just to add to Nicole's reply the header or footer will look something like this
<a href="ExportExcel.asp?{FormParams}">Export To Excel</a>
Tom
|
|
|
|
