Working with worksheet headers and footers

View as MarkdownMarkdown

Set up your AI agent

Give your coding agent live access to the GroupDocs documentation and API reference through the GroupDocs Docs MCP server — no install, no API key. Learn more

claude mcp add --transport http groupdocs-docs https://docs.groupdocs.com/mcp

Also process documents locally

The GroupDocs.Watermark MCP server lets your agent work with files on your machine; they are never uploaded. It needs the .NET 10 SDK or Docker.

claude mcp add groupdocs-watermark -- dnx GroupDocs.Watermark.Mcp --yes
Folders, licensing and more →

Extracting information about all headers and footers in an excel document

You can extract information about all the headers and footers in an Excel document as shown in the below code sample.

AdvancedUsage.AddingWatermarks.AddWatermarksToSpreadsheets.SpreadsheetGetHeaderFooterInformation

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions))
{
    SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
    foreach (SpreadsheetWorksheet worksheet in content.Worksheets)
    {
        foreach (SpreadsheetHeaderFooter headerFooter in worksheet.HeadersFooters)
        {
            Console.WriteLine(headerFooter.HeaderFooterType);
            foreach (SpreadsheetHeaderFooterSection section in headerFooter.Sections)
            {
                Console.WriteLine(section.SectionType);
                if (section.Image != null)
                {
                    Console.WriteLine(section.Image.Width);
                    Console.WriteLine(section.Image.Height);
                    Console.WriteLine(section.Image.GetBytes().Length);
                }

                Console.WriteLine(section.Script);
            }
        }
    }
}

You can also clear a particular header or footer using GroupDocs.Watermark as shown in the below code sample.

AdvancedUsage.AddingWatermarks.AddWatermarksToSpreadsheets.SpreadsheetClearHeaderFooter

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions))
{
    SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
    foreach (SpreadsheetHeaderFooterSection section in content
        .Worksheets[0].HeadersFooters[OfficeHeaderFooterType.HeaderPrimary]
        .Sections)
    {
        section.Script = null;
        section.Image = null;
    }

    watermarker.Save("spreadsheet.xlsx");
}

Using GroupDocs.Watermark, you can also clear a particular section of header or footer as shown in the sample code below.

AdvancedUsage.AddingWatermarks.AddWatermarksToSpreadsheets.SpreadsheetClearSectionOfHeaderFooter

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions))
{
    SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
    SpreadsheetHeaderFooterSection section = content.Worksheets[0]
        .HeadersFooters[OfficeHeaderFooterType.HeaderEven]
        .Sections[SpreadsheetHeaderFooterSectionType.Left];
        
    section.Image = null;
    section.Script = null;

    watermarker.Save("spreadsheet.xlsx");
}

GroupDocs.Watermark enables you to add watermark to images inside any header or footer. You can use below code sample to achieve this.

AdvancedUsage.AddingWatermarks.AddWatermarksToSpreadsheets.SpreadsheetAddWatermarkToImagesInHeaderFooter

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
// Specify an absolute or relative path to your document. Ex: @"C:\Docs\spreadsheet.xlsx"
using (Watermarker watermarker = new Watermarker("spreadsheet.xlsx", loadOptions))
{
    // Initialize image or text watermark
    TextWatermark watermark = new TextWatermark("Protected image", new Font("Arial", 8));
    watermark.HorizontalAlignment = HorizontalAlignment.Center;
    watermark.VerticalAlignment = VerticalAlignment.Center;
    watermark.RotateAngle = 45;
    watermark.SizingType = SizingType.ScaleToParentDimensions;
    watermark.ScaleFactor = 1;

    SpreadsheetContent content = watermarker.GetContent<SpreadsheetContent>();
    foreach (SpreadsheetWorksheet worksheet in content.Worksheets)
    {
        foreach (SpreadsheetHeaderFooter headerFooter in worksheet.HeadersFooters)
        {
            foreach (SpreadsheetHeaderFooterSection section in headerFooter.Sections)
            {
                if (section.Image != null)
                {
                    // Add watermark to the image
                    section.Image.Add(watermark);
                }
            }
        }
    }

    watermarker.Save("spreadsheet.xlsx");
}