Loading data from Excel

From Impure Wiki

Open a Excel file. It should be a simple spreadsheet: a table with rows and columns. It may have a headers row at the top. Export this table to a CSV file through Excel's "Save as" function.

Now, create a new Impure space and place the control csvLoader in it.

Click on the input box of the first inlet and type the system path to the file you just created. You can also enter the url of a file that has been uploaded to Internet, as we are doing in this example. If your data does NOT have column titles in the first row, you can set the second inlet in the control to 'false'. By default, csvLoader will consider the first row as headers.

As soon as you have entered a valid path or url, csvLoader will start loading it and giving you feedback on the progress, in case it is a large file and takes a while to load. It will turn green when it is finished.

Voila! Your Excel data is already available within the Impure space to do whatever you want with it. Pay attention the List and Table operators: you will find many ways of filtering, sorting, analyzing and combining tabular data.

Before processing the data in any way, though, you will probably want to see it and check everything is all right. Just plug in the TableVisualizator, and you will have a convenient representation with scrollbars for panning around large tables. This module does also let you click on a cell to select it, making its contents available in the outlet.