Big data analysis tool and method based on EXCEL

The invention provides a big data analysis tool and method based on EXCEL. Through parameter configuration, the big data analysis method based on EXCEL uses the poi technique to export excel spreadsheet data, and solves the problem of iterative development of general software; through the role distribution mechanism, the operation can be divided into data analysts, auditors, operators, the underlying work is distributed to the data analyst, the operating interface is simple; by encapsulating codes and componentizing related functions, secondary development can be realized according to actual needs, the method has the advantages of simplicity, ease of use and low cost, compared with the way of web crawler + cloud computing, the method is more efficient and cost-effective and is very suitable for small and medium-sized enterprises to use. 本发明提供的基于EXCEL的大数据分析工具和方法，通过参数配置化，使用poi技术导出excle表格数据，解决了般软件需要迭代开发的问题；通过角色分配机制，将操作分为数据分析师、审核人员、操作人员，将底层工作交给数据分析师，操作界面简单医用；通过封装代码，将相关功能组件化，可以在此基础上根据实际需求快速进行二次开发，具有简单、易用、低成本的优点，相较