Does XlsIO support the multiline header footer?

24 Mar 20254 minutes to read

You can enable multiline header and footer support by using XlsIO. The following code snippet illustrates this.

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;

  //Open an Excel file
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];
  worksheet.Range["A1"].Text = "Multiline header and footer";
  // Access PageSetup
  IPageSetup pageSetup = worksheet.PageSetup;

  // Set multiline header
  pageSetup.LeftHeader = "Left Header Line 1\nLeft Header Line 2";
  pageSetup.CenterHeader = "Center Header Line 1\nCenter Header Line 2";
  pageSetup.RightHeader = "Right Header Line 1\nRight Header Line 2";

  // Set multiline footer
  pageSetup.LeftFooter = "Left Footer Line 1\nLeft Footer Line 2";
  pageSetup.CenterFooter = "Center Footer Line 1\nCenter Footer Line 2";
  pageSetup.RightFooter = "Right Footer Line 1\nRight Footer Line 2";

  //Save the excel file
  FileStream outputStream = new FileStream("Output.xlsx", FileMode.OpenOrCreate, FileAccess.ReadWrite);
  workbook.SaveAs(outputStream);
  workbook.Close();
  excelEngine.Dispose();
}
using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;

  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet worksheet = workbook.Worksheets[0];
  worksheet.Range["A1"].Text = "Multiline header and footer";
  // Access PageSetup
  IPageSetup pageSetup = worksheet.PageSetup;

  // Set multiline header
  pageSetup.LeftHeader = "Left Header Line 1\nLeft Header Line 2";
  pageSetup.CenterHeader = "Center Header Line 1\nCenter Header Line 2";
  pageSetup.RightHeader = "Right Header Line 1\nRight Header Line 2";

  // Set multiline footer
  pageSetup.LeftFooter = "Left Footer Line 1\nLeft Footer Line 2";
  pageSetup.CenterFooter = "Center Footer Line 1\nCenter Footer Line 2";
  pageSetup.RightFooter = "Right Footer Line 1\nRight Footer Line 2";

  //Save the excel file
  workbook.SaveAs("Output.xlsx");
}
Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim worksheet As IWorksheet = workbook.Worksheets(0)
  worksheet.Range("A1").Text = "Multiline header and footer"

  ' Access PageSetup
  Dim pageSetup As IPageSetup = worksheet.PageSetup

  ' Set multiline header
  pageSetup.LeftHeader = "Left Header Line 1" & vbLf & "Left Header Line 2"
  pageSetup.CenterHeader = "Center Header Line 1" & vbLf & "Center Header Line 2"
  pageSetup.RightHeader = "Right Header Line 1" & vbLf & "Right Header Line 2"

  ' Set multiline footer
  pageSetup.LeftFooter = "Left Footer Line 1" & vbLf & "Left Footer Line 2"
  pageSetup.CenterFooter = "Center Footer Line 1" & vbLf & "Center Footer Line 2"
  pageSetup.RightFooter = "Right Footer Line 1" & vbLf & "Right Footer Line 2"

  ' Save the excel file
  workbook.SaveAs("Output.xlsx")
End Using