Use the java open source component JExcel to create non-differential Excel files and import them to the. net project.

Using the Excel component of MS Office to generate Excel has many drawbacks.
The first step is that the process is difficult to deploy. The second step is that all of excel.exe will be loaded into the memory every time it is generated, occupying at least 10 MB of memory. If a large file is generated, it will take at least 100-500 mb, not every server may suffer such memory loss, and each request will produce such a memory loss. therefore, it is not advisable to use this method without sufficient hardware conditions.

Therefore, in the process of system development, I thought of the java open source component POI. however, there is a problem: this is the Excel format of OpenOffice, which is a little different from the Excel format of MS Office. If it is read by your system, you can still understand it, however, when it comes to external integration systems, he will strictly require that the Excel format must be the same as the Excel format of MS Office. therefore, it is a little troublesome to use POI for generation.

So google ....

After finding JExcelAPI, JExcel is also an open-source API for generating Excel files in java and can generate non-differential Excel files. This is my choice and relative, it is much easier to develop than POI.
After 2 hours of test .. finally, we made a Console Application. hey, the effect is good, and the 3rd Part system can also be read. therefore, how to make the jar file in. net.

At the beginning, we used the method of calling Process. We found that it was not easy to use and it was very difficult to use...

Continue to develop the excellent tradition of programmers. go to google ....

Finally, I came across a good method. I used. net Java Virtual Machine to introduce jar to. net. It's good. But a JDK VM for. net has a total of 25 MB ....

So big ....

However, the implementation results are quite satisfactory. The next thing is to put these dll and exe in the project. OK, get it done.

The java code is pasted below:

Package Export:

Code

ExportApplication:

Code

The Tool I generated and the DLL to be referenced:

Http://files.cnblogs.com/cnherman/ExportToExcelTool.rar

The VM used is IKVM.

Http://www.IKVM.net