using Spire.Xls;

namespace ExcelPageBreak_XLS
{
 class Program
 {
 static void Main(string[] args)
 {
 //實例化一個Wordbook類對象，并加載需要設(shè)置分頁的Excel文檔
 Workbook workbook = new Workbook();
 workbook.LoadFromFile("Sample.xlsx");

 //獲取第一個工作表
 Worksheet sheet = workbook.Worksheets[0];

 //插入兩個橫向分頁符(指定單元格上方插入分頁)
 sheet.HPageBreaks.Add(sheet.Range["A11"]);
 sheet.HPageBreaks.Add(sheet.Range["A20"]);

 //插入一個縱向分頁符（指定單元格左側(cè)插入分頁）
 //sheet.VPageBreaks.Add(sheet.Range["E1"]);

 //將視圖設(shè)置為分頁預(yù)覽模式查看效果
 sheet.ViewMode = ViewMode.Preview;

 //保存并打開文檔
 workbook.SaveToFile("AddPageBreak.xlsx", FileFormat.Version2010);
 System.Diagnostics.Process.Start("AddPageBreak.xlsx");
 }
 }
}

using Spire.Xls;
namespace DeletePageBreak_XLS
{
 class Program
 {
 static void Main(string[] args)
 {
 //創(chuàng)建一個Workbook類對象，并加載Excel文檔
 Workbook workbook = new Workbook();
 workbook.LoadFromFile("sample.xlsx");

 //獲取第一個worksheet
 Worksheet sheet = workbook.Worksheets[0];
 
 //刪除所有橫向分頁
 sheet.HPageBreaks.Clear();

 //刪除第一個橫向分頁
 //sheet.HPageBreaks.RemoveAt(0);

 //設(shè)置分頁預(yù)覽模式查看分頁效果
 sheet.ViewMode = ViewMode.Preview;

 //保存并打開文檔
 workbook.SaveToFile("刪除分頁1.xlsx",FileFormat.Version2010);
 System.Diagnostics.Process.Start("刪除分頁1.xlsx");
 }
 }
}