We have the following problem, by generating a file, in creating Ranges and the format to try to give some cells (range) of this file to generate what is happening in the picture attached,
Deputy few lines of code used:
Workbook Excel, Worksheet WS, clsSlide_Block Block, int Row, int Col,
Please try this fix. In the old version, if the member of the array is null, we will treat it as "".
In this fix,we use Cell.GetStyle and SetStyle method replace the property of Cell.Style. The two methods will save more memory usage than cell.Style property.
If you want to set style of the cell, please change your codes as :
//Getting the style of the cell.
Style style = cell.GetStyle();
//Setting the property of the style.
.......
//Setting the style of the cell
cell.SetStyle(style);
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.