Skip to content
Apiary

Round-trip losses

Apiary reads most of what is in an XLSX file. A few features are recognised but not yet carried over to the workbook. Workbook.unsupportedFeatures names them, so an application can tell its user before saving. Apiary itself does nothing with the list; what to show, and when, is for the application to decide.

Each entry is one feature of the source file that is missing from the workbook: a tag naming it, a category saying what kind of thing is lost, and a description in plain English, ready to show to users. For the full list, go to Unsupported features.

Category Covers
behaviour How the workbook calculates, filters data and restricts what can be entered or changed
content Items the workbook holds that no calculation depends on
appearance Formatting: how an item in the workbook looks, not what it holds
view Settings for how a sheet is shown on screen or laid out for printing

The list is most useful right before the workbook is written back to a file, when the user can still choose to keep the original. Filter it to the categories that matter for what you are building and show the descriptions.

const lost = workbook.unsupportedFeatures
.filter(feature => feature.category !== 'view')
.map(feature => feature.description);
if (lost.length > 0) {
warn(`Saving as XLSX will drop:\n${lost.join('\n')}`);
}