Skip to main content
P
phaneey0001
March 2, 2025
Question

export datastore entity to excel

  • March 2, 2025
  • 2 replies
  • 0 views

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

2 replies

karumurua531442
karumurua531442
March 2, 2025

hi [mention:ac69d72e4de442aa9b02d1a2e9e0fced:e9ed411860ed4f2ba0265705b8793d05], 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

P
phaneey0001Author
March 2, 2025

Thanks Abhishek.

I will try to implement this approach and see if it works

Terms & ConditionsAccessibility statement