QUESTIONS OR COMMENTS ABOUT PRODUCTS? WRITE US AT SUPPORT@BYTESCOUT.COM OR USE THIS FORM

How to add rows to an existing Excel (XLS) document using Bytescout Spreadsheet SDK

How to add rows to an existing Excel (XLS) document using Bytescout Spreadsheet SDK

This source code sample teaching how to add rows with data to an existing XLS document using Bytescout Spreadsheet lib

Download example source code: bytescoutxls_adding_rows_into_existing_xls.zip (5 KB)

Source Excel document:

Source Excel document (XLS)

New row was inserted and document saved as new document file:

Modified Excel document with new row inserted

using System;

using System.Collections.Generic;

using System.Text;

using Bytescout.Spreadsheet;



namespace Adding_rows_to_existing_XLS

{

class Program

{

static void Main(string[] args)

{

// Open Spreadsheet

Spreadsheet document = new Spreadsheet("AdvancedReport.xls");

// Get Worksheet

Worksheet worksheet = document.Workbook.Worksheets[0];

// Add new row

worksheet.Rows.Insert(6, 1);

// Set values

worksheet.Rows[6][0].Value = "New Name";

worksheet.Rows[6][1].Value = "New Full Name";

// Save document

document.SaveAs("AdvancedReport1.xls");

// Close Spreadsheet

document.Close();

}

}

}

Download example source code: bytescoutxls_adding_rows_into_existing_xls.zip (5 KB)

Tutorials: