Excel Write Error

Have a pretty a pretty standard write to excel attempt giving me a weird error. Some context, I am writing 11 lists of 96 numerical strings one after another until I have an very long 11 column excel sheet. But as soon as I get a to a certain point, I start getting an error. It goes for literally thousands of lines and then all of a sudden BOOM nothing.

Find attached the questionable piece of script as well as the script from which it comes.

Here is the text of the error

Error - Write Options String is not valid. Please adjust inputs or use the default options.Internal error message: System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at CORE.Grasshopper.Toolbox.WriteOptionsWrapper.decomposeStr() at CORE.Grasshopper.Toolbox.WriteOptionsWrapper..ctor(String WriteOptionsString) at CORE.Grasshopper.Toolbox.writeToExcel.SolveInstance(IGH_DataAccess DA)

Is this because my RS input is ~33000? Does the writer break after a certain number of cells?

Attachments:

StephensBigProblem.gh, 12 KB
RestOfTheProblem.gh, 384 KB

Replies to This Discussion

Permalink Reply by Markku on November 7, 2017 at 10:36pm

Int16 can handle integer numbers up to 32767. In older excels that was max number of rows on sheet.

Permalink Reply by Stephen Yoshida on November 8, 2017 at 8:59am

Markku,

Thanks for the swift reply! Good to know about the maximums on integers. Any ideas of a work around? I was thinking to just taking what didn't fit and making it into its own document. Its not elegant but it seems like it would work.

Permalink Reply by Markku on November 8, 2017 at 10:28am

You can try other grasshopper plugins. Lunchbox and Ghowl has also Excel write ability. Maybe those are written to bigger integers (UInt16 max integer 65535, Int32 max = 2147483647) Excel 2003 can already handle 65536 rows and later versions 1048576 rows so that is not problem.

RSS