Creating Multiple Headers

You can display multiple column and row headers and specify whether to show letters, numbers, or nothing in the default header. You can also put custom text in the headers.

Clicking on a header will select that row or column by default. You can also resize a column or row by moving the mouse pointer over the line at the edge of a header. The mouse pointer changes to a double arrow and you can then drag the column or row to the new width or height.

You can use the AutoTextIndex and AutoText properties in code to change the default header text.

Using Code

This example creates multiple headers and cell spans.

CS
Copy Code
gcSpreadSheet1.Sheets[0].RowCount = 10;
gcSpreadSheet1.Sheets[0].ColumnCount = 8;
gcSpreadSheet1.Sheets[0].ColumnHeader.RowCount = 3;
gcSpreadSheet1.Sheets[0].RowHeader.ColumnCount = 2;
gcSpreadSheet1.Sheets[0].RowHeader.AutoTextIndex = 1;
gcSpreadSheet1.Sheets[0].RowHeader.AutoText = GrapeCity.Xaml.SpreadSheet.Data.HeaderAutoText.Letters;
gcSpreadSheet1.Sheets[0].ColumnHeader.AutoTextIndex = 2;
gcSpreadSheet1.Sheets[0].ColumnHeader.AutoText = GrapeCity.Xaml.SpreadSheet.Data.HeaderAutoText.Numbers;
gcSpreadSheet1.Sheets[0].AddSpanCell(0, 0, 2, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader);
gcSpreadSheet1.Sheets[0].SetValue(0, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "State");
gcSpreadSheet1.Sheets[0].AddSpanCell(0, 1, 1, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader);
gcSpreadSheet1.Sheets[0].SetValue(0, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Company");
gcSpreadSheet1.Sheets[0].AddSpanCell(0, 3, 1, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader);
gcSpreadSheet1.Sheets[0].SetValue(0, 3, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Category");
gcSpreadSheet1.Sheets[0].AddSpanCell(0, 5, 1, 3, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader);
gcSpreadSheet1.Sheets[0].SetValue(0, 5, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Products");
gcSpreadSheet1.Sheets[0].SetValue(1, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "GC");
gcSpreadSheet1.Sheets[0].SetValue(1, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "MS");
gcSpreadSheet1.Sheets[0].SetValue(1, 3, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "License");
gcSpreadSheet1.Sheets[0].SetValue(1, 4, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Activate");
gcSpreadSheet1.Sheets[0].SetValue(1, 5, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Win");
gcSpreadSheet1.Sheets[0].SetValue(1, 6, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Web");
gcSpreadSheet1.Sheets[0].SetValue(1, 7, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "XAML");
gcSpreadSheet1.Sheets[0].AddSpanCell(0, 0, 3, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader);
gcSpreadSheet1.Sheets[0].AddSpanCell(3, 0, 3, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader);
gcSpreadSheet1.Sheets[0].AddSpanCell(6, 0, 3, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader);
gcSpreadSheet1.Sheets[0].AddSpanCell(9, 0, 1, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader);
gcSpreadSheet1.Sheets[0].SetValue(0, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, ".NET");
gcSpreadSheet1.Sheets[0].SetValue(3, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, "Java");
gcSpreadSheet1.Sheets[0].SetValue(6, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, "HTML");
gcSpreadSheet1.Sheets[0].SetValue(9, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, "Total:");
VB
Copy Code
GcSpreadSheet1.Sheets(0).RowCount = 10
GcSpreadSheet1.Sheets(0).ColumnCount = 8
GcSpreadSheet1.Sheets(0).ColumnHeader.RowCount = 3
GcSpreadSheet1.Sheets(0).RowHeader.ColumnCount = 2
GcSpreadSheet1.Sheets(0).RowHeader.AutoTextIndex = 1
GcSpreadSheet1.Sheets(0).RowHeader.AutoText = GrapeCity.Xaml.SpreadSheet.Data.HeaderAutoText.Letters
GcSpreadSheet1.Sheets(0).ColumnHeader.AutoTextIndex = 2
GcSpreadSheet1.Sheets(0).ColumnHeader.AutoText = GrapeCity.Xaml.SpreadSheet.Data.HeaderAutoText.Numbers
GcSpreadSheet1.Sheets(0).AddSpanCell(0, 0, 2, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader)
GcSpreadSheet1.Sheets(0).SetValue(0, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "State")
GcSpreadSheet1.Sheets(0).AddSpanCell(0, 1, 1, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader)
GcSpreadSheet1.Sheets(0).SetValue(0, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Company")
GcSpreadSheet1.Sheets(0).AddSpanCell(0, 3, 1, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader)
GcSpreadSheet1.Sheets(0).SetValue(0, 3, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Category")
GcSpreadSheet1.Sheets(0).AddSpanCell(0, 5, 1, 3, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader)
GcSpreadSheet1.Sheets(0).SetValue(0, 5, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Products")
GcSpreadSheet1.Sheets(0).SetValue(1, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "GC")
GcSpreadSheet1.Sheets(0).SetValue(1, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "MS")
GcSpreadSheet1.Sheets(0).SetValue(1, 3, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "License")
GcSpreadSheet1.Sheets(0).SetValue(1, 4, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Activate")
GcSpreadSheet1.Sheets(0).SetValue(1, 5, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Win")
GcSpreadSheet1.Sheets(0).SetValue(1, 6, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "Web")
GcSpreadSheet1.Sheets(0).SetValue(1, 7, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, "XAML")
GcSpreadSheet1.Sheets(0).AddSpanCell(0, 0, 3, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader)
GcSpreadSheet1.Sheets(0).AddSpanCell(3, 0, 3, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader)
GcSpreadSheet1.Sheets(0).AddSpanCell(6, 0, 3, 1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader)
GcSpreadSheet1.Sheets(0).AddSpanCell(9, 0, 1, 2, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader)
GcSpreadSheet1.Sheets(0).SetValue(0, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, ".NET")
GcSpreadSheet1.Sheets(0).SetValue(3, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, "Java")
GcSpreadSheet1.Sheets(0).SetValue(6, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, "HTML")
GcSpreadSheet1.Sheets(0).SetValue(9, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, "Total:")
See Also

 

 


Copyright © GrapeCity, inc. All rights reserved.