Shulou(Shulou.com)06/01 Report--

Editor to share with you how to move the Excel PivotTable to WEB, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

It must be no stranger to mention Excel, especially the PivotTable. For situations that require aggregation analysis, you can check and select them according to the original data, which is a lot of fun to use.

So, wouldn't it be perfect if the features that are so easy to operate can be moved to WEB and embedded in my application? So easy! Comrade Lei Feng will teach you to do this right away.

The protagonist enters the stage-- moisturize the multi-dimensional analysis of the report!

Let's first use Excel files as data sources to share with you the application cases of multidimensional analysis. You are welcome to watch enthusiastically and gracefully complain:

The Excel file is as follows:

This format is very common, the first line is the title, followed by rows of data.

Whether the Excel data file is on the server or locally, drying the multidimensional analysis interface can help you get it done easily! Don't say much, just look at the steps:

Open the multi-dimensional analysis interface of the dry report:

Click the data File button in the menu, pop up the Open data File window, and select the data file.

For local files, you can click the [Open Local] button to find and use the data files saved anywhere locally.

For server files, you can click the "Open Server File" button to open all data files located in the directory specified by the server. This directory path needs to be specified by adding JS API to "[demo Application Root] / raqsoft/guide/jsp/olap.jsp", as shown in the following figure.

Once the data file is selected, the dataset is created, and the most important step in multidimensional analysis is ok.

Next is the time for business people to gallop freely, drag headers and indicators in complex conditions at will, and check whatever they want and calculate what they want. What can be done in PivotTable, our WEB application can also do it. Haha, is it better to jump from a standalone application to the Web environment?

In addition to the above-mentioned method of importing data files through the page menu, there is a simpler use, as long as the data files to be analyzed are passed in URL. For example, put data.xls in the "[Web application root directory]\ WEB-INF\ files\ fileData\" directory, and add the file name directly after visiting the analysis page. Such as: \ raqsoft\ guide\ jsp\ olap.jsp?dataFile= [Web application root]\ WEB-INF\ files\ fileData\ data.xls.

Greed, greed! After learning how to do multi-dimensional analysis of files in a dry WEB application, do you want to know how to integrate it into your own application system?

Very simple, the standard java development three-piece suite, jar package, xml configuration file, and jsp tag description file tld.

The homework to be done in advance includes setting up the basic environment according to the "Integrated release" section of the dry report V2018 tutorial before further integrating multi-dimensional analysis.

Multidimensional analysis is a drag-and-drop interface displayed using the tag tag. The olap.jsp,tag tags provided in the product for demonstration are roughly as follows:

The embedded page is even more simple and easy to operate, and it will directly list all the indicators in xls, and the record will be displayed in front of you without concealment.

For ease of use, after adding Tag tags, our analysis page will provide a menu bar by default, but if you feel that the menu bar is a little out of place with your page style, it doesn't matter, the solution has already helped you figure it out!

You can hide our default menu bar and add our menu bar buttons to your own style page.

The method of hiding is so simple that it can be done with one script:

GuideConf.showToolBar = 'no'; / / whether to display the upper toolbar. Default is yes

Haha, did you find that the menu bar has disappeared?

In order to customize the buttons for these functions, we specially provide the JS method directly to the user. Your buttons can directly call the following methods:

Save: analyseApi.saveOlap ()

Open: analyseApi.openOlap ()

Horizontal tiling: analyseApi.resetReportWindow (1)

Vertical tiling: analyseApi.resetReportWindow (2)

Overlapping display: analyseApi.resetReportWindow (3)

Dataset: analyseApi.manageDataSet ()

How to use it:

open

Of course, if you want to control the multi-dimensional analysis page miraculously, you still need to learn more about our multi-dimensional analysis JS API (all open source).

A little bit deeper, one of the parameters in the above tag is dfxFile, and dfx is the program script file for the aggregator. This shows that the calculation of file multidimensional analysis depends on the dry aggregator. After passing the data file as a parameter to the system's own readFiles.dfx,dfx calculation through url, the result set will be displayed on the analysis page as a dataset of multidimensional analysis, and then users can drag and query the dataset fields at will. Of course, worry, this part of the aggregator function is free!

The above is all the contents of the article "how to move the Excel PivotTable to WEB". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.