Wolfram Language

XLS/XLSX Updates

Updates to "XLS" and "XLSX" include higher efficiency, new import elements, better support for accessing parts of the file and improved Dataset workflows.

Visualizing XLS and XLSX data is much simpler with the new "Dataset" import element. By combining it with the "HeaderLines" option, you can construct a Dataset with headers instantly.

The import element "Dimensions" can be used to efficiently determine the dimensions of an XLS or XLSX file.

Accessing parts of an XLS or XLSX file is more efficient and now supports any type of Span as a part specification. Sheets can even be accessed by name.

It is simple to access just the data needed for analysis. For example, compare the shirts worn for the first few episodes of the odd seasons, excluding the episode number column.

Related Examples

de es fr ja ko pt-br zh