Delete Page Break in Excel using Node.js

Delete page break in Excel using Node.js by following the steps given in this tutorial. It contains the IDE settings and a sample code to change page breaks in Excel using Node.js. You will learn to delete all the page breaks from a sheet in a spreadsheet or delete selected horizontal or vertical page breaks as per your requirements.

Steps to Remove Page Break in Excel using Node.js

  1. Set the IDE to use Aspose.Cells for Node.js via Java to remove manual page breaks
  2. Load the spreadsheet with manual page breaks into the Workbook object
  3. Access the target sheet to eliminate the page breaks
  4. Access the collection of horizontal page breaks from the selected sheet and call the ‘clear()’ method
  5. Get the collection of the vertical page breaks and call the ‘clear()’ method for removing all items in it
  6. Save the resultant Workbook after deleting the page breaks

These steps summarize how to remove the page break in Excel using Node.js. Load the spreadsheet into the Workbook object and access manual collections of vertical and horizontal page breaks within the selected sheet. Each collection class has a ‘clear()’ method that deletes all the items in the collection.

Code to Reset Page Breaks in Excel using Node.js

This code demonstrates how to change page breaks in Excel using Node.js. When you add only a horizontal or vertical page break in a particular row or column, each horizontal page break contains the first column 0 and the last column 255, and in case of a vertical page break, the starting row is 0, and the ending row is 65535. You may search these numbers to delete horizontal or vertical page breaks from the collection on each sheet.

This topic has explained how to delete page break in Excel using Node.js. To insert a page break in Excel, refer to the article insert a page break in Excel with Node.js.

 English