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
hamerw 0 Newbie Poster
gourav_ajmani 0 Newbie Poster
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 0 Newbie Poster
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.