The Import(file,sheet,cells) function imports the data from the Microsoft Excel workbook file, as addressed by the sheet and cells parameter, into a Matrix.

Both the XLSX (Office Open XML) and XLS (Excel 97-2003) file formats are supported.

In the Standard interface, if the file parameter is not provided, a dialog will be presented with a field for the target file name.  In all other interfaces, the file parameter is required.

The sheet parameter can be either the name of a sheet within the file or a 1-based index.

The cells parameter can be a standard cell range, for example, "A1:B9" or "c$10..$w15", or a named range.  If it is given as a named range, that name must already exist in the Excel file.

If cells is given as a single cell address, for example "D13", this is taken as the top-left corner of the required range, with the bottom-right corner taken to be the bottom-right corner of the sheet. (To import just a single cell, specify it as a range, for example "AQ3:AQ3".)

Spreadsheets can contain empty cells in the midst of other data.  By default these cells are given the value 0.0 upon import.  Use the emptycell option to specify a different value.  For example, emptycell=undefined, or emptycell="".

$\mathrm{with}\left(\mathrm{ExcelTools}\right)\:$

$Q≔\mathrm{Import}\left(''Employees.xlsx''\,''Payroll''\,''B2:C9''\right)\:$

$R≔\mathrm{Import}\left(''Employees.xlsx''\,''Payroll''\,''B2''\right)\:$

$\mathrm{ArrayDims}\left(R\right)$

$1..12,1..10$

$P≔\mathrm{Import}\left(''Employees.xlsx''\,''FirstQuarter''\right)\:$

$S≔\mathrm{Import}\left(''Employees.xlsx''\,2\,''A1:w25''\right)\:$

$T≔\mathrm{Import}\left(''Employees.xlsx''\right)\:$

$T≔\mathrm{Import}\left(\right)$