Table, Layout, and Render tool can't handle large data sets? Excel error

[calvinwong]

Hi,

Has anyone have an issue with using Table, Layout, and Render tool with large dataset (10,000+ rows and maybe 20 columns)? I was able to run the workflow, however, when I open up the excel, it will say that "we found a problem with some content in "file name.xlsx". Do you want to recover as much as we can? ...." After I select yes, some of the words will get cut off. Like column header "Account #", will show up as "Acco #".

[tcroberts]

Are you relying on Excel functionality for anything in your output data?

I'm not sure what's causing that, but to debug you could try and write it to a .csv file instead, and then open that .csv up in Excel.

Let me know if this helps,

Cheers!

[AmeliaG · Accepted solution]

@calvinwong,

Sometimes you have to play around with the column width in the table tool to make sure its not getting cut off. Another thing to try in the render tool - increase the paper size to something much larger say 20x30. 

Let me know how it goes!

Amelia

[calvinwong]

@AmeliaG,

Thanks, Amelia. I have to fix the render paper size and everything worked. 

[AmeliaG]

@calvinwong I'm happy to hear it!

[Kishori]

@calvinwong check the data size of each column as well and try to minimize the it by sample tool. That will help to solve this issue.