How to map an XML schema to an OpenCalc spreadsheet cell and export cell data as an XML data file

I created an XML schema for storing data. I want to provide a simple user interface with an OpenCalc spreadsheet for data entry.

Things I wanted to do.

  • Map the elements of my XML schema to the cells in the spreadsheet.
  • Provide this table as a user interface for data entry.
  • Export the entered data as an XML data file. (The exported XML data file must have tag elements defined in the XML schema associated with the corresponding data entered by the user).

About XML Schema:

  • None of the circuit elements has attributes.
  • There are duplicate elements in an XML schema. ie, an element may be present more than once in an XML data file.

Is it possible to do this in OpenCalc?

+3
source share

Source: https://habr.com/ru/post/1719013/


All Articles