Processing through in-site messages
Asynchronous import means that after the task of importing Excel is submitted, the imported task will be run in the background. At this time, the user can perform other operations, wait until the import task is completed, and then notify the.If the amount of Excel data is large, the business logic is complex, and the import is time-consuming, it is recommended to use asynchronous import; if the amount of data is small, the import logic is not complicated, and the speed is fast, then use synchronous import.In the same way, the same logic can be used for export.Import overwrite or update?This is a judgment made by the business layer. Import overwriting means that the imported data directly overwrites the existing data, which is simple and crude.Import update means that Iceland Phone Numbereach piece of imported data is compared with the existing historical data. If there are the same, it is updated, and if there is no similarity, it is inserted.You have to decide based on the business scenario. Generally speaking, there are more scenarios that are imported and updated.
https://lh7-us.googleusercontent.com/R9utN0C9ulTN34RoVQHOV5FElhfwlgdDOfloyaNTfqRQEnjWa4La1iA3sptiKiBmIACz0v61xxlQEMPEUOLWaKd8W1mnYG-IuhyOSDnivfg0s27CDtrPr_upB0IfJC7-ZcF6obMvt2TLQLsRW1SQraU
There are fewer scenarios that are directly covered.4. Match by header name or header coordinatesExcel is a two-dimensional table with X-axis and Y-axis, that is, rows and columns. Each column starts from A and goes to Z, then AA to AZ; each row starts from 1 and keeps increasing. A1 is a coordinate, representing the first row and first column; B3 represents the second column, third row...Matching by header name is a preset Excel template. It first parses out the header fields of the first row,
頁:
[1]