Best Excel import practices (1)

Related Links
Best Excel import practices (1)
Best Excel import practices (2)
Best Excel import practices (III)
Best Excel import practices (4)
Best Excel import practices (5)

In the application system, to facilitate batch data entry or data transfer, you may need to import the data in Excel to the existing system.

. To import an Excel file, you must first read the Excel file. The following methods are commonly used:

1. Use excel as a data source to directly connect to and read Excel
Advantages:
1. Easy to implement
Disadvantages:
1. The import template can only be manually completed. If you want to process multiple languages or the number of columns is not fixed, the number of templates will become very large and difficult to maintain.
2. It is difficult to process non-standard external tables (such as row and column merging) in Excel.

2. Use office PIA to read Excel
Advantages:
1. Easy to implement
2. Flexible Generation of introduced template files
Disadvantages:
1. Excel must be installed on the server
2. An Excel process is enabled on the server every time you use it. The process is killed.

3. Use openxml to read Excel
Advantages:
1. overcome the disadvantages of the above two methods
Disadvantages:
1. High development complexity
2. excel2003 and earlier versions are not supported

4. Read excel through a third-party Excel read/write component(For example, npoi is called poi in Java. These two are the best Excel read/write components on the two platforms I currently see)
Advantages:
1. There are no restrictions on the server (of course, it must be a. NET environment)
2. Simple implementation
3. Flexible Generation of introduced template files
Disadvantages:
1. The current version 1.2 only supports Excel 2003 and earlier versions, but does not support Excel 2007.

This import scheme reads excel in the last method.