Replies: 1 comment
-
|
3.5.1 15 sec |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I have a table with 200 columns and 25,000 rows. Most cells contain string data (including Dates/Numbers), which I set up like this:
Looping by rows, then by columns:
csharp
var cell = new DocumentFormat.OpenXml.Spreadsheet.Cell { CellReference = ... };
...
cell.DataType = CellValues.String;
cell.CellValue = new CellValue(s);
cell.InlineString = null;
...
I write the cells using openXmlWriter.WriteElement(cell).
Performance issue:
v3.1.1: File creates in 7 seconds
v3.5.1: File creates in 15 seconds (more than 2x slower)
Question: How can I speed up v3.5.1 to match or beat v3.1.1 performance?
Beta Was this translation helpful? Give feedback.
All reactions