Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
Insert Page Break | C#
Program.cs:
C#
using System.IO; using System.Diagnostics; using Bytescout.Spreadsheet; using Bytescout.Spreadsheet.Structures; namespace InsertPageBreak { class Program { static void Main(string[] args) { // Create new Spreadsheet Spreadsheet document = new Spreadsheet(); // Add new worksheet Worksheet worksheet = document.Workbook.Worksheets.Add("HelloWorld"); // Set cell value worksheet.Cell(0, 0).Value = "Hello, World!"; // Add horizontal page break worksheet.HPageBreaks.Add(new CellsRange("A10")); // Add vertical page break worksheet.VPageBreaks.Add(new CellsRange("F1")); // Save document document.SaveAs("Output.xls"); // Close Spreadsheet document.Close(); // Open generated XLS document in default associated application Process.Start("Output.xls"); } } }