Research and design of reporting system based on Excel Services
Zhu Fang-ce · Jisuanji gongcheng yu sheji · 2010
In order to effectively improve the office automation efficiency and enhance security of business data in enterprise routine,the Excel Services is adopted to implement a lightweight reporting system.Aiming at the use of Excel report characteristic,the server-side Excel reporting system is designed and implemented based on the SharePoint platform on the premise of combing the existing Excel applies business logic.Assigning permissions in Excel Services is studied to ensure the Excel file version consistency and data manipulation security.All the study provides a new solution for the enterprise Excel report applies.Finally,a case study of reporting system applied in a certain group is presented to verify the feasibility of the new system.