Skip to main content

Nooxl Transformer

The Nooxl Transformer turns an uploaded Excel file into a model automatically: it identifies the cells that should be stored in the database and creates the cell storage sections for you, instead of you doing it by hand.

When to use​

Use the Transformer when creating a new model (or uploading a new version) and you want a quick, sensible starting point — especially for spreadsheets with obvious input cells.

Step by step​

  1. In the app navigation, click the lightning icon to start the automatic transformation.
  2. In the upload dialog, choose where the new model is placed, its visible name, and optionally an order.
  3. Select the Excel file, give a reason for the change, optionally create a new major version, make sure Transform automatically is on, and click Upload.

Screenshot placeholder

  • 1 Choose the location and visible name.
  • 2 Select the Excel file.
  • 3 Ensure Transform automatically is on.
  • 4 Click Upload.

Depending on the file size, the transformation can take a while.

The result​

The Transformer identifies the input cells, creates a cell storage for them, and creates a tab page named after the sheet. It also creates a default dataset selection.

After transformation​

  • Check the result. Nooxl recognizes a cell as input when its content is referenced elsewhere in the workbook. Cells that nothing references (for example a free comment cell) are not stored — add a cell storage section manually if you need them.
  • Tighten the storage property. By default storages are DATA_TEXT_NUMBER; change to DATA_TEXT or DATA_NUMBER where you know the content type, for better performance.
  • Adjust the selections. Replace or extend the default selection to match your model.