excel export in browse

[ntnewbies]

hi friends,

is there a way to rename the worksheet before export the browse?

i notice there is only ExcelExport.SetWorkSheet and ExcelExport.WithWorkSheet

it would be great if we have excelexport.renameworksheet


also, i would like to put a name at the first row and column and when i put it as
ExcelExport.SetCell(1,1,'Booking Sheet')

i only see the first column and row as 0



jason

[Bruce]

Hi Jason,

In the generated source look for where the name is set;

p_web.HeaderDetails.ContentDisposition = 'attachment; filename="Customer.xml"'

then in the next available embed point simply set this same line to whatever you like. eg
p_web.HeaderDetails.ContentDisposition = 'attachment; filename="Jason.xml"'


>> also, i would like to put a name at the first row and column and when i put it as
>> ExcelExport.SetCell(1,1,'Booking Sheet')

Seems to be working here, so maybe make sure you are calling this _after_ the place where the template generates the headers.

cheers
Bruce

[ntnewbies]

hi bruce
i can rename the file from xml to xls. that is not a problem.

what i mean is renaming the WORKSHEET name inside the excel file.

jason

[Bruce]

>> it would be great if we have excelexport.renameworksheet

Added to xFiles 3.19 (now up)

For NetTalk 12 I've also made the Worksheet name a template setting.

cheers
Bruce

[ntnewbies]

thanks bruce
it works well as expected.

jason