spreadsheet-file

Imports data from a spreadsheet file.

Arguments

Inputs:

file: The spreadsheet file in one of the following file formats: .xlsx, .xls, .xlsm, .xlsb, .ods, .fods, .sylk, .html, .dif, .dbf, .rtf, .prn, and .eth.

sheetname: The name of the sheet (tab) from which to import the data. If unspecified, the first sheet will be used.

range: A valid range of cells (e.g. A1:L512) that contain data. If unspecified, the whole sheet will be included.

Output:

data: A datatable containing the imported data.