Export to Excel with worksheet tab as filname

Hello,

I need to export my report to Excel and the same way alter the worksheet tabname to give it the same name as the report.

So in my example, the report is exported as ‘vertomuit.xls’.
And I want to change the worksheet tab to ‘vertomuit’.

Is this possible?
CRS_excel_worksheet_tab.JPG


benalla (BOB member since 2016-01-14)

With the out of the box Crystal Reports, no. I have heard of third party add ons that will allow this.


kevlray :us: (BOB member since 2010-06-23)

which version of crystal reports you are using… i did this in visual studio crystal reports through coding in changing the file name and tab name while exporting. if you are using direct crystal reports i am not sure about the tab name. at present what is the tab name it is displaying…


surya.g :india: (BOB member since 2009-11-24)