SpreadsheetRead()
Creates a new spreadsheet object from the file specified
Usage
SPREADSHEET = SpreadsheetRead(
p1,
p2
)
| Argument | Summary |
|---|---|
| p1 | full path location of the spreadsheet file to read |
| p2 | Sheet number, or index of the initial active sheet [optional] |
See Also
IsSpreadsheetobject
SpreadsheetAddcolumn
SpreadsheetAddfreezepane
SpreadsheetAddimage
SpreadsheetAddinfo
SpreadsheetAddrow
SpreadsheetAddrows
SpreadsheetAddsplitpane
SpreadsheetColumnfittosize
SpreadsheetCreatesheet
SpreadsheetDeletecolumn
SpreadsheetDeletecolumns
SpreadsheetDeleterow
SpreadsheetDeleterows
SpreadsheetDeletesheet
SpreadsheetFindcell
SpreadsheetFormatcell
SpreadsheetFormatcolumn
SpreadsheetFormatcolumns
SpreadsheetFormatrow
SpreadsheetFormatrows
SpreadsheetGetcellcomment
SpreadsheetGetcellformula
SpreadsheetGetcellvalue
SpreadsheetInfo
SpreadsheetMergecells
SpreadsheetNew
SpreadsheetQueryread
SpreadsheetQuerywrite
SpreadsheetRead
SpreadsheetReadbinary
SpreadsheetRemovecolumn
SpreadsheetSetactivesheet
SpreadsheetSetactivesheetnumber
SpreadsheetSetcellcomment
SpreadsheetSetcellformula
SpreadsheetSetcellvalue
SpreadsheetSetcolumnwidth
SpreadsheetSetfooter
SpreadsheetSetheader
SpreadsheetSetrowwidth
SpreadsheetShiftcolumns
SpreadsheetShiftrows
SpreadsheetWrite