0

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

3
Contributors
2
Replies
3
Views
10 Years
Discussion Span
Last Post by Rupeshba
0

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

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.