COREstudio

187 members

Description

The CORE studio at Thornton Tomasetti uses Grasshopper everyday to enhance workflows amongst many engineering disciplines. We draw a lot of help and inspiration from this community and hope that you will find some of the tools that we have created helpful, too.

Comments Discussions Members

Excel Write Error

by Stephen Yoshida

Nov 7, 2017

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?

Load Previous Replies
  • up

    AliceBrown

    Useful topic.

    Nov 7, 2024

    • up

      ClarenceParkinson

      Greetings!

      Nov 7, 2024

      • up

        ClarenceParkinson

        I've been deep in the grind of writing literature reviews myself, and I know how tough it can get. Sometimes, even after days of researching, it feels like there’s still so much left to cover, and structuring everything coherently is another level of challenge. Especially when you have multiple assignments piling up, finding a way to keep things organized and thorough can feel almost impossible. If you’re in a similar bind, one approach that worked for me was to buy a literature review paper from a resource I came across. They provide well-researched, well-structured work that saved me tons of time while keeping the quality up.


        Nov 7, 2024