2.7.
Excel and other spreadsheet formats

Maximum efficiency with XLSX and co. as input format in Octopus

Octopus takes the processing of table formats such as XLSX to a new level. The Microsoft Excel format is not only a standard for organising and analysing data, but also an ideal starting point for transformation and further processing in the Octopus platform.

Why XLSX as an input format?
XLSX files offer a structured and flexible way to store and organise data. With Octopus, this data can be seamlessly transformed into other formats such as XML, HTML, JATS or DocBook. All important elements of the file are taken into account:

  • Automatic calculation of formulas: Formulas in the tables are calculated directly and the calculated content is transferred to ensure error-free further processing.
  • Tabs as tables: Each tab sheet in the XLSX file is automatically converted into a separate table, which enables clear and structured data organisation.
  • Table structures: Columns, rows and cells are precisely recognised and processed.
  • Formatting and metadata: Colours, fonts, cell formatting and additional information such as comments are taken into account.

The advantages of XLSX in Octopus
The use of XLSX as an input format in Octopus offers numerous advantages:

  • Automation: Recurring tasks such as converting tables into XML or other formats are efficiently automated.
  • Error-free data processing: The automatic calculation of formulas and the clear structure of the tab sheets maximise data quality.
  • Flexibility: Whether financial data, scientific analyses or project plans - XLSX is versatile.
  • Media-neutral processing: Your data can be provided in various output formats, perfect for cross-media publishing or archiving.

Octopus - your solution for the data processing of the future
Octopus makes working with XLSX files easier, faster and more efficient. The platform enables you to transform your spreadsheet content into valuable, structured data that can be used in any workflow. Save time, reduce errors and maximise the value of your data - with Octopus and XLSX as the perfect duo.

Octopus - The future of data processing starts here.