Altair® Panopticon

 

Creating Data Extract from MS Excel (xlsx)

The MS Excel (xlsx) connector allows for retrieval and processing of MS Excel workbook data stored using the XLSX file format. The MS Excel (xlsx) connector processes data on a row-by-row basis, allowing for better performance and less memory consumption compared to the MS Excel (legacy) connector.

Steps:

1.     On the New Data Extract page, select MS Excel (xlsx) in the Connector drop-down list.

 

2.     Follow steps 3 to 6 in MS Excel (xlsx)  to define the connector settings.

3.     Click  to save and display the details of the data extract.

4.     Click  then  to display the data preview.