Issue Exporting Data with More Than 50 Columns Using "Export Data Store Entity to Excel" Plugin

Question

Hi Everyone
I'm currently facing an issue while exporting data from a specific table that contains more than 50 columns. I'm using the Export Data Store Entity to Excel plugin, but it throws an error during the export process.
Has anyone encountered a similar issue or found a workaround to export data with more than 50 columns successfully? Any suggestions or guidance would be greatly appreciated.
Thanks in advance!

mikes0011 · Accepted Answer

I believe it has a stated limit of 50 columns.

I believe the general suggested & supported solution, is to update the generated document with a 2nd pass through the smart service (starting at the 51st column, using the Starting Cell parameter) with any additional data.
EDIT: i take this back, data is truncated below the starting row even if a completely different set of columns is written to. It's one of the reasons I find this node pretty much unusable.

My personal advice however would be to trim the columns you're exporting - do you truly need in excess of 50 columns?

I might suggest, instead, the JSON to Excel Plug-in. Though I still think you should try to reduce your used columns to something lower than 50 if possible - 100 columns in a single excel is going to be too cumbersome for most user-facing use cases.

harshk1671 · Answer

As Mike suggested, there is a smart service limit of 50 columns.

I often encounter requirements where I need to export more than 50 columns. To handle this, I create multiple sheets, each containing a set of 50 columns.

Here I initialize first column of each sheet with the same unique identifier, which makes it easy to put VLOOKUP later to work in downloaded excel.

For example:

Columns 1–50 go into Sheet 1
Columns 51–100 go into Sheet 2
...and so on.

I pass the same document for update across all sheets.
Hope this helps!

Sign up

Login with SSO

Login to the community

Login with SSO