Export data to Excel Template

Expand Post »

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

Similar Threads

Get data out of excel file stored as an image in MS SQL
Transferring data to Excel in ASP.NET
Error message while importing data to Excel from the MySQL db in MySQL
Export Data From Excel to ASP and SQL Server in C++
Exporting data into Excel in C

hamerw

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2006

Permalink

Dec 1st, 2006

Re: Export data to Excel Template

Click to Expand / Collapse Quote originally posted by 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

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

gourav_ajmani

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Dec 2006

Permalink

Mar 31st, 2007

Re: Export data to Excel Template

Click to Expand / Collapse Quote originally posted by 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

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

Rupeshba

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: Access Date & Time Validation Question

Next Thread in MS Access and FileMaker Pro Forum Timeline: I am desparately in need of help with Filemaker Pro 8 Running Balance

DaniWeb Message

Cancel Changes

User Name
Password