This figure is running before and after half a minute,
Intention is to write an automatic interpretation of data within a datatable excel document. XLS format

Who can explain why efficiency so low?

Review a number of seconds 2-3,

CodePudding user response:

A total of 21000 * 4 data

CodePudding user response:

Across processes call excel is inherently slow, using npoi may be faster

CodePudding user response:

Use a third-party library... Mr Or into a TXT, then import excel, specific methods can record a macro, and then write according to the macro, you call what it calls the line,

CodePudding user response:

Operation excel form more than 1 w lines is quite slow, why don't you generate CSV format, for example,

CodePudding user response:

I use an array to add xlsheet. Reaching (). The value of the method

CodePudding user response:

Thank you oh (' - omega - `)