Hi Team,
I am trying to generate the excel with 100 columns in the same sheet. Since there is a limit of 50 columns per sheet I am trying to use the same service two times so that I can generate the required columns. But the issue is it is either generating the remaining 50 columns in the separate sheet or replacing the first 50 columns with the second 50 columns. Is there a way where i can generate all the columns in a single sheet?
Thanks
Discussion posts and replies are publicly visible
hi phaneey0001, AFAIK, not sure about this approach, found this in one of the old community discussion threads. There is a way where you can create a web api to generate a CSV file, and you can use 100 columns. After making a web api, you can use the URL of the web api to download the link. Create an exp rule first, and then call this exp rule in the web api.You can refer to this thread for more info:https://community.appian.com/discussions/f/process/23662/limitations-of-export-data-store-entity-to-excel
Thanks Abhishek.
I will try to implement this approach and see if it works