I am looking to create multiple sheets in excel without useing the Export to excel smart service

siddhantv

A Score Level 2

over 5 years ago

Hi,

I am looking to create multiple sheets in single excel file. the requirement is that we need to create exportable datasubset for excel and we want to have multiple sheets in one excel useing getdatasubsetdownloadlinkfromurl().

I am not able to create multiple sheets using that.

Is there a way to achieve this.

Thanks!

Discussion posts and replies are publicly visible

0 ekanshj
A Score Level 2
over 5 years ago

Hi Siddhant,
Can I know the reason for not using Process modeling as its very easy now with the new Excel generation by Appian Smart Service.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 siddhantv
A Score Level 2
over 5 years ago in reply to ekanshj

Hi Ekansh,

We already have the structure implemented for the excel generation with single sheet using the above mentioned function. Thus wanted to make minimal changes in th e code. Although I have tried the Appian smart service mentioned by you but its just that we have to prepare a Process model additionally for this which is a bit extra memory consuming. But I guess we have to go for this approach only for managing multiple sheets.

Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ekanshj
A Score Level 2
over 5 years ago in reply to siddhantv

Yes Siddhant, I know it is some extra memory but currently for multiple sheets that is the only option we have.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel