This is a Laravel API that can generate Excel File Templates as defined by a user. The template can be downloaded, filled with data and then verified through the same API. A file will pass as valid if it passes the user defined rules. Otherwise, a list of all errors will be shown.
The following features are supported for this kit:
- Column name definition
- Column constraints definition. The following constraints are supported: (REQUIRED,UNIQUE,REGEX)
To interact with the API, a simple React Typescript CRA project has been created and bundled together with this package. You can use the UI to create new file template and validate the file.