"String exceeds Excel's limit" error when writing dataset_summarize() output to Excel

[zchenmr]

R Maelstrom: madshapR v1.0.3

This is a recurrence of a previously encountered issue - after generating a summary report using dataset_summarize(), I get the following error:

This time, the error seems to be coming from the "Categories in data dictionary" column in the "summary" sheets ("Variables summary (all)", "Text variable summary", etc.), as well as the "Values present in dataset" column in the "Categorical variable summary" sheet. Since my data dictionary contains some variables with over 700-800 categories, I think the problem is that all of the categories are being listed in the report.

[GuiFabre]

That is one of the limits of Excel, I'll come up with something ;-)

[GuiFabre]

the function trucates each cell to 10000 which will be sufficient to read in View, and compatible with excel limits

[zchenmr]

R Maelstrom: madshapR v1.0.4.1005

The cell values are now truncated and it's possible to write the report to Excel again.