The Import xls Files Dialog


To import xls (Excel) files in Matrex, select the Import xls file item of the machine menu.
Importing an xls file you extract the content of the cells in the file (texts, numbers, dates...) to matrices of the Matrex project.
Formulas, charts, colors are not imported in the Matrex project.

When you clicked on the menu you need to select the xls file to import.
Once you did it the following window appears:

Import xls file

The window has a tab for each sheet in the workbook.
Each tab contains a table showing the content of the sheet, without colors, charts or special formats.

Select with the mouse a rectangle of cells and click Add Selection to Project to import as a matrix in the project.
During the cell selection it is not possible to scroll the table, but it is possible to continue the selection from another cell pressing Shift together with the left mouse button.
Clicking Add Selection to Project you need to choose the matrix type and to give its name and package. Then the matrix is added to the project.

If you choose to import the rectangle of cells as numeric or date matrix, you need to set the formats to parse numbers and dates.

When the import is complete, click the Close button to close the window.