.
...
As noted previously, this cell will occupy up to 400 bytes of memory because several other objects have to be instantiated to hold the cell's attributes. Consequently, you should avoid looping through cells that might be empty, since doing so will create Cell objects that you may not need.
Use ExcelApplication before ExcelTemplate
...
To conserve memory, we recommend pre-processing a partial template with the ExcelApplication before passing the file to ExcelTemplate for importing data. See Preprocessing vs. PostProcessing.
...
If you have a large area that you want to autofit, and do not know beforehand how wide the cell contents might be, it will be much faster to find the longest string and then set the width of the columns in characters. For example, if you have several thousand rows, then you could say:
| Csharp | ||||
|---|---|---|---|---|
| ||||
//Used to store the maximum length, in characters int maxChars = 0; //Loop through each row of data for (int row = 0; row < lastRow; row++) { //If this cell contains more characters than //our previous maximum, then update maxChars maxChars = Math.Max( ws.Cells[row, columnNumber].Value.ToString().Length, maxChars); } //Get the column properties for the column we want to adjust the width of ColumnProperties columnProperties = ws.GetColumnProperties(columnNumber); //Set the width in characters to the maximum //number of characters a cell in the column has columnProperties.WidthInChars = maxChars; |
...