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

In this issue, the editor will bring you about how to quickly and easily extract Excel data by column. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

General method: use a third-party class library (POI or HSSFWorkbook, etc.) to read the Sheet and cell information of the EXCEL file, and then read the required value of each cell in a loop according to the rules, and structure the table data. However, due to the lack of rich function class libraries in the program language, it is still hard-coded, and the workload will be relatively large.

If you use the aggregator SPL, it is much easier to solve this kind of problem, which can easily read Excel files and structure tabular data. For example, the content of the file item.xlsx is shown in the following figure:

The structured effect is shown in the following figure:

To deal with the above problem, the aggregator SPL only needs 2 lines and the code is as follows:

A

one

= file ("item.xlsx") .xlsimport (; 1jin5)

two

= A1.rename (# 1rig Norecrome, 2R ItemCode, 3R ItemNameDie, 4R Unit, 5V Quantity, 6R Price, 7Sum)

The aggregator is also a professional tool for file data source processing, which can easily carry out mixed calculation, storage and export of all kinds of file data, such as TXT, Excel, Xml, Json, CSV, ini and so on. Desktop-level computing tools, ready-to-use, simple configuration, perfect debugging functions, can set breakpoints, single-step execution, and the results of each step can be viewed. The syntax is simple, in line with people's natural thinking, and is simpler than other high-level development languages.

This is how the editor shares how to quickly and easily extract Excel data by column. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are 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.