I am using dynamic sub-totaling- is there a way to format the subtotal rows - such as change border, font, background cell color, etc.
cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new int[] { 13, 14, 15 });
Hi,
Please provide us your complete code and source xls/xlsx file if you are using any. Please also provide us your desired xls/xlsx file which you can create manually using Ms-Excel.
Also, if you want to style any cell, then you can style it using the Style object. You will get access to all the properties of the style object.
e.g
Style st = cell.GetStyle();
st.Font.IsBold = true;
cell.SetStyle(st);
Please see the subsections for further reference:
Working with Data Formatting
Hi,