Spread can open XML files or Stream objects that were created by Spread, as well as text and Excel files. Text files must use delimiters that Spread can process to place data into the appropriate cells. You can open a specific sheet in an Excel file and load it to a specific sheet in Spread.
If you open or load a file or Stream object that contains more columns or rows than the sheet or sheets into which you are opening the file or stream, the component adds columns or rows as needed to the sheet or sheets. If you open or load a file or Stream object with fewer columns or rows than the sheet or sheets into which you are opening the file or stream, the component opens the file and loads the data, and does not delete the additional columns or rows in the sheet or sheets.
Opening existing files using Spread Designer places the data from the file into the design string used to create the component. Longer design strings negatively impact responsiveness, including making page loads slower and increasing response time to editing. Keep this in mind when using Spread Designer to open and load files.
Read the following sections for more information and instructions: