Do not specify both RowsPerRead and ReadSize. RowsPerRead has been removed. Use ReadSize instead
Do not specify both RowsPerRead and ReadSize. RowsPerRead has been removed. Use ReadSize instead
Do not specify both RowsPerRead and ReadSize. RowsPerRead has been removed. Use ReadSize instead
Re: Do not specify both RowsPerRead and ReadSize. RowsPerRead has been removed. Use ReadSize instead
spreadsheetDatastore
Datastore for spreadsheet filesexpand
Description
Use a SpreadsheetDatastore object to manage large collections of spreadsheet files where the collection does not necessarily fit in memory. You can create a SpreadsheetDatastore object using the spreadsheetDatastore function, specify its properties, and then import the data using object functions.
ReadSize — Amount of data to read
'file' (default) | 'sheet' | positive integer scalar
Amount of data to read in a call to the read function, specified as 'file' or 'sheet', or as a positive integer scalar.
If ReadSize is 'file', then each call to read reads all the data one file at a time.
If ReadSize is 'sheet', then each call to read reads all the data one sheet at a time.
If ReadSize is a positive integer, then each call to read reads the rows specified by ReadSize, or fewer if it reaches the end of the data.
When you change ReadSize from an integer scalar to 'file' or 'sheet', or conversely, the datastore resets using the reset function.
Data Types: char | string | double
Datastore for spreadsheet filesexpand
Description
Use a SpreadsheetDatastore object to manage large collections of spreadsheet files where the collection does not necessarily fit in memory. You can create a SpreadsheetDatastore object using the spreadsheetDatastore function, specify its properties, and then import the data using object functions.
ReadSize — Amount of data to read
'file' (default) | 'sheet' | positive integer scalar
Amount of data to read in a call to the read function, specified as 'file' or 'sheet', or as a positive integer scalar.
If ReadSize is 'file', then each call to read reads all the data one file at a time.
If ReadSize is 'sheet', then each call to read reads all the data one sheet at a time.
If ReadSize is a positive integer, then each call to read reads the rows specified by ReadSize, or fewer if it reaches the end of the data.
When you change ReadSize from an integer scalar to 'file' or 'sheet', or conversely, the datastore resets using the reset function.
Data Types: char | string | double
Who is online
Users browsing this forum: No registered users and 16 guests