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.
Download Excel File Generator and Verifier