Question about Excel Export

Source: Internet
Author: User
Since Excel beat Lotus N years ago, it has dominated the spreadsheet software market. All table software cannot help but take full account of Excel and look for functional points that excel cannot take care. All table software must be considered to be compatible with Excel and be able to import and export Excel files. The actual result is that, as long as the software can be stained with the form, it is difficult to survive in the shadows of Excel. This is especially true for the Web report tool market in China. It is the best way to import and export Excel files.
In short, whether or not an Excel file can be imported and exported without losing sight is a major event that determines the success or failure of the Web report tool software. It is careless.
To import and export Excel files, you can use the following methods:
1. Only export data, not export styles
2. Call the COM component in the Excel software to export
3. Use a pure C # program to read and write Excel files on the binary level

The first method is the simplest, but the function is the weakest, which basically cannot meet the requirements of users. You cannot export styles.

The second approach is the most widely used. NET platform in China. The principle is to use a group of COM components in MS Excel software to directly control Excel files. Therefore, this approach relies heavily on Excel software. Using this method also seems like Microsoft's trap. In. net programs (such as C #), using this method to import and export Excel files has the following weaknesses:
A. Install MS Excel software.
B. Some versions of MS Excel software must be installed, or the uniformity of Excel software versions is required.
C MS Excel COM components a large number, memory and other resources consumption too large.
D. MS Excel is designed as a spreadsheet software with an interface. Therefore, it is much slower to run in the background.
E. net program calls excel through COM components, while. the. NET program is a managed code that calls an unmanaged COM component (for calls.. Net) will increase some additional overhead.
F if the Excel software on the server is used, the Excel process on the server cannot be completely closed. I once saw a lot of articles on killing the Excel process on the server with tricks in the blog garden, but I felt that this problem could not be completely solved, in this way, I decided not to use this method to solve the problem of importing and exporting Excel files in Table E.

Third, this method does not rely on Excel software, that is, the client and server do not need to install Excel software, directly use. net program (such as C # program) to read and write Excel files, that is, first read the Excel files into the memory as a binary file stream, then, analyze the data by byte according to the Excel file format standard. The advantage of this method is to avoid the weakness of the second method, and the dependency on Excel software is very small. However, because the structure of an Excel file is complex, you need to use the code to analyze the Excel file from the beginning. The workload is very large. Unlike the Java platform, a general and open-source poi package can be used directly to solve this problem. On the. NET platform, in addition to some commercial DLL files outside of China to solve this problem, it seems that this kind of thing cannot be seen in China. I have also tried some foreign countries and found that most of them have Chinese Character problems.

Later, I thought about the Excel import/export function. Most of them are used in report tools (such as Crystal Reports) or the second method (that is, to call the COM component in Excel ). The third approach is too heavy, so everyone will avoid it. This is the current national condition. But Table E cannot avoid it. What should I do?
If a tool itself is used to create a report in an Excel file, can it be completely exported to an Excel file? Next, I will introduce you to a Java report tool I have used-lankui Java report.
This tool is suitable for creating EXCEL reports. That is to say, users who want to edit report data in Excel can edit reports in this tool as they like. Because the lankui Java report itself is an Excel file, it mainly uses bluequeryv system platform to obtain the number conveniently and quickly, and the Excel table to draw conveniently, the combination of the two enables customers to prepare report data as they wish.
The perfect combination of lankui Java report and Excel: it not only retains all the functions of Excel, but also adds the unique count function of bluequery v. the interface style and operation process are seamlessly integrated with Excel. You can drag and drop formulas, queries, parameters, texts, and other objects to excel; you can also save the lankui Java report as an Excel file. the blue Kwai Java report itself is an Excel file, so exporting the report to excel is completely non-distorted.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.