Export data to Excel Template

[hamerw]

Hello

I have successfully exported a recordset to an Excel template and saved the template as an xls file. However, when I open the Excel file all the worksheets are hidden.

Does anyone know why and how to stop this from happening.

thx
Wayne

[gourav_ajmani]

Hello I have successfully exported a recordset to an Excel template and saved the template as an xls file. However, when I open the Excel file all the worksheets are hidden. Does anyone know why and how to stop this from happening. thx Wayne

HI can u plz provide me with the code for exporting the data to excel from jsp.

I have a jsp page I am setting the data from bean in jsp ,n i have a button there on which if i click it shoud display the o/p in excel..


regards
Gourav

[Rupeshba]

Hello I have successfully exported a recordset to an Excel template and saved the template as an xls file. However, when I open the Excel file all the worksheets are hidden. Does anyone know why and how to stop this from happening. thx Wayne

Hi...

have u use macro for that

goto macro
Action:OutputTo
Object Type:Table/Query/Report/.......
Object Name: Table Name/Query Name/Report Name......
OutPut Format: *.xls/*.doc/*.rtf/..
OutPut File: c:\.... ' Path were u want to store that file
Auto Start: Yes


Save that Macro

GoTo Forms
Make Button and call that Macro

IT will automatically transfer the file to there

*********************

if ur excel file is hide than
Windows 'Menu Bar
Unhide File


if ur facing problem again then
mail me

bye...
Rupesh