In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >
Share
Shulou(Shulou.com)06/01 Report--
The content of this article mainly focuses on what kind of export effect the big data report tool can achieve. The content of the article is clear and clear. It is very suitable for beginners to learn and is worth reading. Interested friends can follow the editor to read together. I hope you can get something through this article!
Developed with report tools, the core function is to present the data from various data sources on the Internet in the form of tables or charts. However, many scenarios are a combination of online and offline. It is not only convenient to see the report online in the system, but also seamlessly fit with the traditional offline business, such as exporting the results to files for circulation, electronic archiving, and so on. At this time, the report tool needs to have a strong WYSIWYG export ability.
At present, for report tools, support for export is basically a standard function, in addition to open source report tools in the support of file types are limited, for business report tools, the commonly used file types, almost no difference, such as support for export word, excel, pdf, txt and so on.
As for the technical details of the use, we will not discuss in detail here, such as the most report tools developed with java on the market, basically with the help of third-party open source toolkits, such as poi export excel, itext export pdf and so on.
It needs to be emphasized that although business reporting tools can generally derive the desired conditions, the effect may be thousands of miles away, so you can't simply listen to the manufacturer's propaganda that you can or can't, but also look at whether it's good or not. There are two kinds of report tool models: the traditional strip model and the new screen format. The former has some difficult problems, such as inaccurate position, coincidence between borders, alignment and so on, which will lead to the distortion of the exported file. or make a lot of broken grids, anyway, is not the desired effect; and the latter can fully reflect the regularity of the table, export can be guaranteed without distortion.
In addition to the basic export functions, there will be some personalized requirements, such as reports do not need to be displayed, want to export multiple reports directly, multiple reports are exported to an excel file, and so on. Most of the old domestic manufacturers also provide a wealth of api, a pile of examples, can easily expand the export capacity. For example, in the following example, several lines of code solve the problem of bulk importing an excel file.
Although the new grid format designer is good at basic export results, and there is almost no difference between products, not everyone can do well for reports with really special formats or requirements.
For example, word reports
Figure 1
Such reports have to be hard-drawn (such as rich text) if they are done with reporting tools, and the advantage is that they can make the data dynamic, make the chart design more flexible, and do not have to modify the file repeatedly because of different data. But there are great shortcomings, such as page display although there is a title format and other performance, but the export of word will find that the actual page is only the title effect, word is the text, but also includes some line wrapping, typesetting, trouble to do, the effect after export can not fully achieve the desired results.
For this demand, in fact, there are better solutions, for example, we can use report tools combined with some api to do, such as some fixed content, such as the title, fixed descriptive text on the word file to do, in the need to put the table or chart location to insert a bookmark.
Insert the calculated report results into the corresponding bookmark location through the api provided by the report tool.
In doing so, it avoids hard typesetting (for better layout), facilitates adjusting the style, and improves the efficiency of report report development, while the exported word is also more in line with the needs of the report (figure 1). For more details, please refer to how to insert the report into the word document automatically.
For another example, third-party presentation controls may be used in the product, such as open source echarts charts, which are rich in graphics and cool in presentation, and are often integrated into reports, but the trouble is that they cannot be exported. The reason is that the report export is implemented by the background program, and echarts needs to intercept graphics from the browser (front end) before it can be exported. If the report is rendered on one page, this is easy to handle. Once the report is divided into multiple pages, the echarts graphics may be distributed to multiple pages, and we cannot intercept the echarts diagrams that are not shown on the current page from the browser, so it is necessary to examine the functional perfection of the report tool. The plan is actually relatively clear, take all the echarts graphics and give them to the background to put them in the corresponding position of the report. The key is to see whether the report tool has been solved.
Thank you for your reading, I believe you have a certain understanding of the "big data report tool can achieve what kind of export effect" this question, quickly go to practice, if you want to know more relevant knowledge points, you can pay attention to the website! The editor will continue to bring you better articles!
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.