How to export the st table to excel based on the selections

[Ramya]

Hi All,

i am having the following requirement.

when i click on the export button the following st table should be exported to excel with the each region data into one sheet.

per suppose emea region into one sheet, apj into another and ams into one another sheets.

here i am attaching the sample qvw.

below is the data

region	company name	supervisor	sales
ams	x	sony	245
apj	y	fim	255
emea	z	jen	265
apj	tcs	bin	450
apj	cts	fun	350
ams	bosch	sun	679
emea	lg	ram	789
ams	samsung	rama	532

I am new to macros kindly help me out wit this.

[Frank_Hartmann]

see attached qvw

hope this helps

[Ramya]

Hi Frank,

Thank you for the quick response .

but i need to get the export to excel. this thing i am unable to find in the qvw you shared.

can you help me out

[Frank_Hartmann]

if you press the "createExcelReport" Button within my uploaded qvw, then Excel is opening with the exported Tables, right?

[Ramya]

Hi Frank,

when i clicked on export to excel button it is opening the macro script instead of  opening in the excel.

[Frank_Hartmann]

make sure that you have these settings activated inside Module and retry:

[Ramya]

Hi Frank,

Thank you so much for the help.

i need  a small change instead of region 1 and region 2  and region 3 can we get the region names as emea ,ams ,apj as sheet names in the excel

[Frank_Hartmann]

see attached

hope this helps

[Ramya]

Hi Frank,

Thanks for all the help you provided.

i need one more help with all the inputs from you i had modified the  code below attached .

right now we have hardocded for 2 subjects can you help me to make it dynamic for all the subjid without hardcoding

Your code is simple but here they are using the below code.

Kindly help me out to achieve this.

Thanks and Regards,

Ramya

[Frank_Hartmann]

see attached