A Modeling language and its editor for mapping two excel files and transforming between each other

Поділитися
Вставка
  • Опубліковано 4 жов 2024
  • We developed a modeling language and its toolset using Metaedit+ for mapping one Excel file into another. The toolset includes a GUI tool for receiving two Excel files from the user - one input file and one output file (where the input file contents are to be copied into the output file). The GUI tool generates a new, updated meta-model file for the Metaedit+ environment. The resulting meta-model file can be imported in the Metaedit+ editor and the editor can then be used for modeling the mapping between the input and output excel files, basically associating each column name of input file with a distinct column name of the output file using a visual notation set (boxes-and-lines). Then, the user can use the transformation tool integrated into the Metaedit+ editor to copy the input Excel file content into the output Excel file content in accordance with the mapping rules specified.

КОМЕНТАРІ •