The Excel syncing service is a project to synchronize the data between Excel and HTML forms. The project is either used to generate a downloadable formatted Excel file or extract the data from the Excel to be used in HTML forms.
Specifically, after cell binding, it can:
- Sync the data from a defined cell to specific form input.
- Sync the data from the form input to the Excel spreadsheet.
- Use
json-server
to mock REST API.
- Angular Material - UI components
- LuckySheet - online spreadsheet
- LuckyExcel - upload Excel
- Exceljs - convert luckysheet to Excel file
- file-saver - allow the client side to download the edited Excel file
- uuid - generate unique id even for different types of forms
- debug
- downloaded Excel styling problem (in progress)
- testing
- Cypress end-to-end testing to ensure consistent behaviors (in progress)
This project was generated with Angular CLI version 13.1.2.
Run ng serve
for a dev server. Navigate to http://localhost:4200/
. The app will automatically reload if you change any of the source files.
The mock server uses the uuid id
as unique ids, use json-server db.json --id id
to set id
as id field.
Please see software artifacts to understand how it is designed. The design used the SOA (service-oriented architecture) to reduce the potential duplicate code.