Get and Set Style for cells with C++
Cell.GetStyle and Cell.SetStyle. This article examines the Cell.GetStyle/SetStyle approach to help you judge which technique best suits you.
Formatting Cells
There are two ways to format a cell, illustrated below.
Using GetStyle()
With the following piece of code, a Style object is initiated for each cell when formatting it. If a lot of cells are being formatted, a large amount of memory is consumed because the Style object is a large object. These Style objects won’t be freed until the Workbook.Save method is called.
C++
cell.GetStyle()->GetFont()->SetIsBold(true);
Using SetStyle()
The first approach is easy and straightforward, so why did we add the second approach?
We added the second approach to optimize memory usage. After using the Cell.GetStyle method to retrieve a Style object, modify it and use the Cell.SetStyle method to set it back to this cell. This Style object won’t be preserved, and the C++ runtime will collect it when it’s not referenced.
When calling the Cell.SetStyle method, the Style object isn’t saved for each cell. Instead, we compare this Style object to an internal Style object pool to see if it can be reused. Only Style objects that differ from the existing ones are kept for each Workbook object. This means that there are only several hundred Style objects for each Excel file instead of thousands. For each cell, only an index to the Style object pool is preserved.
C++
auto style = cell.GetStyle();
style->GetFont()->SetIsBold(true);
cell.SetStyle(style);