Software development company
Challenges
A company providing software development services needed to upgrade the timesheet management module in the ERP system for a client in the semiconductor industry. During the upgrade process, they encountered the following issues:
- Massive offline data templates
Over years of operation, the client has accumulated a large number of Excel spreadsheets containing complex formulas. The development team finds it difficult to fully understand the business logic behind these formulas, making it challenging to convert these spreadsheets into functional modules within the system.
- Lack of system flexibility
The client’s business is complex and changes frequently, requiring frequent adjustments to the data templates in the timesheet management module. Due to the complexity of the calculation logic in these templates, business experts and developers need extensive communication to finalize modification plans. This results in slow deployment of new templates, making it difficult to respond promptly to business changes and failing to meet the expectations of management.
- Insufficient data analysis capabilities
The timesheet management module in the ERP system lacks sufficient data analysis capabilities. The current module does not support essential features such as charts, formulas, pivot tables, conditional formatting, and sparklines, making it difficult for employees to effectively analyze timesheet data. As a result, the system has gradually become just an “Excel download tool.”
Solution
To tackle the challenges of complex data processing and frequent template changes, the project manager found Univer during the search for solutions and embedded it into their product to meet the following needs:
- Compatibility with Excel templates
Univer is an isomorphic full-stack framework that allows developers to easily generate spreadsheet snapshots on the server using the Univer API. A snapshot is a JSON data structure defined by Univer, and with Univer, Excel files can be directly converted into spreadsheet snapshots while retaining complex formulas and styles from Excel. This solution enables all offline data templates to be imported into the database, allowing employees to view and operate them within the ERP system.
- Accelerate the deployment of worksheet templates
After embedding the Univer SDK, business experts can edit templates directly within the ERP system using Univer Spreadsheets. The user experience of Univer Spreadsheets is consistent with Excel, supporting common functions such as copy-paste, undo-redo, drag-fill, freezing rows and columns, and inserting/deleting rows and columns. Business experts can start using it without any training and define worksheet calculation rules using familiar formulas. Once editing is complete, developers can input data from the database into the template to generate the final worksheet management template. This solution significantly improves collaboration efficiency and accelerates the development and deployment of templates.
- Data Analysis
Univer is designed with a modular plugin architecture, where each plugin corresponds to a specific feature. Currently, Univer has over 100 plugins that support a wide range of data analysis functions, such as charts, pivot tables, conditional formatting, sparklines, and more than 500 formulas, fully meeting the complex data analysis needs of the worksheet management module. Developers can also extend these plugins to meet the personalized data analysis requirements such as custom formulas, specialized chart types, enhanced pivot table aggregation, custom menus, and shortcuts, further improving the management and analysis of worksheet data.
Client Feedback
Listen to what our customers say about us:
"Univer has made our clients extremely satisfied! It perfectly integrates with Excel templates, greatly enhancing development and collaboration efficiency, while solving the challenges of complex formulas and data analysis. Univer’s powerful scalability has prepared us for the future—it’s truly a technological breakthrough!"
Project Manager/Software Development Company
