POI用户模型的重构与优化

Reconstruction and Optimization of POI UserModel

Apache POI中的用户模型是目前用于处理Excel数据的最为广泛的应用技术,但用户模型存在许多明显的弊端。本文将以一个学生档案管理系统为例,对用户模型中存在的问题以及产生问题的原因进行分析,并针对这些问题,借用面向过程的设计思想对用户模型进行优化和改进。使用不同规模的数据量对改进前后的用户模型进行测试,并对测试结果进行比较和分析,最终在一定程度上解决了用户模型的弊端,提升了用户模型的性能。

The UserModel in Apache POI is the most widely used technology for processing Excel data at present, but the user model has many obvious disadvantages.This paper will take a student file management system as an example to analyze the problems existing in the UserModel and the causes of the problems.In view of these problems, the UserModel will be optimized and improved by using the process-oriented design idea.The data volumes of different scales were used to test the UserModel before and after the improvement,and the test results were compared and analyzed.Finally,the disadvantages of the UserModel were solved to some extent,and the performance of the UserModel was improved.