472,133 Members | 1,443 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,133 software developers and data experts.

change the sheet name while exporting datagrid data to excel


I am having trouble renaming the excel sheet while exporting to excel.
we have a datagrid that contains some analytical data. I have the name to the
excel file as "temp.xls" inside the code. When the user clicks on the Export
to Excel button next to datagrid, it opens a popup with options Open, Save
and Cancel. When I click open, it opens the excel sheet with the sheet name
as .xls[temp[1] and the excel filename as temp[1].xls. As a result when the
user selects the data and try to use pivot table with that data it is giving
an error. I am thinking if I change the sheetname, then the pivot table would
work. Please let me know.

Nov 9 '06 #1
0 3313

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by http://www.visual-basic-data-mining.net/forum | last post: by
14 posts views Thread by pmud | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.