![]() ![]() The following screenshot shows the output Excel file generated by the sample code. The following screenshot shows the source Excel file used in the sample code below which contains some data in columns A and B. You can open this setting in Microsoft Excel using Data > Outline > Settings SummaryBelowData - Indicates whether add summary below data.Īlso, you can control the direction of Outline Summary rows below detail as shown in the following screenshot using property.PageBreaks - Indicates whether add page break between groups.Replace - Indicates whether replace the current subtotals.TotalList - An array of zero-based field offsets, indicating the fields to which the subtotals are added.GroupBy - The field to group by, as a zero-based integer offset.CellArea - The range to apply subtotal on.You can apply Subtotal to data using () method. This article will explain how to apply Subtotal to data and changing the direction of Outline Summary Rows below Detail.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |