Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago

Add-in submit lines limit

Originally posted by Armando Ortiz

Hi community,

Does anyone knows if there is a limit on the number of lines that can be submitted to OS from an Excel sheet and what is that limit?

Thanks in advance for your valuable help.

Excel Add In

1 Reply

Sort By
  • TonyToniTone's avatar
    TonyToniTone
    Contributor II
    4 years ago

    OneStream can handle the maximum number of rows that Excel has to offer, which is 1,048,576 rows.  During the Import step through a Workflow, OneStream can interpret an Excel template file that is configured with the proper OneStream Excel headers to import the data into Stage.  

    If the data is coming from Excel using the XFSetCell functionality, the data cell records are set within the Cube and not into Stage.  This process requires data to pass through a Web Server and depends on the throughput from the users machine all the way through the OneStream Application Servers.  In this case, there isn't necessarily a limit but there are many factors that impact the time to load the data to the Cube.  So the answer is, it depends.