Menu Close

Too many records to export for Excel – Use CSV instead

Syncrosim Forums ST-Sim & State-and-Transition Simulation Models Too many records to export for Excel – Use CSV instead

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #4894
    leonardo-fridleonardo-frid
    Keymaster

    I recently had a message from an ST-Sim user trying to export output to excel and encountering the following error:
    State Class Summary has too many rows for the currently installed version of Excel“.

    This will happen if the number of records you are trying to export exceeds 1,048,576. To get around this problem when selecting the name of the file to export in the File | Save As dialog you can under Save As Type choose the CSV option. Once exported however, you will not be able to fully open the file in excel and will need some other program such as R or Python to view and process the output.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.