cancel
Showing results for 
Search instead for 
Did you mean: 

Preserve Web Item sequence while export to excel in WAD

0 Kudos

Hi,

I am exporting three text items and three info_field items into the excel sheet in alternative order (one text item followed by info_field item like wise) i.e. I mentioned this order of web items while configuring export command for my export to excel button as shown below:

.

.

Text_Item 1

Info_Field Item 1

Text_Item 2

Info_Field item 2

Text_Item3

Info_Field Item3.

.

.

But in excel, I am getting all text items one after another followed by all info_field items:

.

.

Text_Item 1

Text_Item 2

Text_Item3

Info_Field Item 1

Info_Field item 2

Info_Field Item3.

.

.

How can I control the order of web items to be exported to excel.

Regards,

Aditya

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Aditya,

Ensuring the web items are specified in their expected order of export in no way judges the order on export. The option to specify webitems is to simply specify what webitems in particular are to be exported in case you wish to not display all webitems on export. The order I guess is always governed by the design of the web template. Thus if you design your web template such that one InfoField webitem succeeds the Text webitem, it will be exported in that fashion.

--Priya

Former Member
0 Kudos

Hi Aditya,

It seems that in properties of Export to excel, you have defined all the text elements first and then your analysis items. Change the order of Web Items as you want in excel in screen, where you enter all the web items to be exported. this should work.

Regards,

Harpal