findatex-schemas

Note: findatex-schemas is not in any way affiliated with findatex.eu

Excel files are neither human nor machine friendly. This project tries convert the excel description of the EPT format to a JSON schema. The data can then be written in YAML (with editor validation) and converted to .xlsx file afterwards.

JSON schemas for https://findatex.eu formats

ept.schema.json corresponds to EPT_V2.1_Final.xlsx
TPT not done yet
EMT not done yet
EET not done yet

installation

npm install -g findatex-schemas

validation

command line

eptValidate findatex-ept-captor-2023-12-29.yaml

vscode

In vscode you can add something like this to .vscode/settings.json and install redhat.vscode-yaml

{
  "json.schemas": [
    {
      "fileMatch": ["findatex-ept*.json"],
      "url": "./schemas/ept.schema.json"
    }
  ],
  "yaml.schemas": {
    "schemas/ept.schema.json": ["findatex-ept*.yaml"]
  }
}

executables

In addition to ept.schema.json findatex-schemas exposes executables to convert .xslx files to .yaml and back again.

for example:

eptExcel2yaml examples/findatex-ept-captor-2023-12-29.xlsx
eptYaml2excel findatex-ept-captor-2023-12-29.yaml
eptValidate findatex-ept-captor-2023-12-29.yaml

Contributions

Feel free to report bugs and submit pull requests

Package detail