How to change cell value in existing XLS document using Bytescout.XLS component for .NET

Bytescout.XLS library for .NET

How to change data in an existing Excel (XLS) document using Bytescout.XLS library

This source code sample demonstrates how to use Bytescout.XLS library to change data in an existing Excel (.XLS) document and save changed file as a new one.

Download example source code: bytescoutxls_changing_data_in_existing_xls.zip (8 KB)

Source document screenshot:

source Excel document with data table

Modified document screenshot (see Homer's Full Name changed)

using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.XLS;

namespace Changing_data_in_existing_XLS
{
class Program
{
static void Main(string[] args)
{
// Open XLSDocument
XLSDocument document = new XLSDocument("AdvancedReport.xls");
// Get Worksheet
Worksheet worksheet = document.WorkBook.Worksheets[0];
// Set cell value
worksheet.Cell(1, 1).Value = "Homer Jay Simpson 2";
// Save document
document.SaveAs("AdvancedReport1.xls");
// Close XLSDocument
document.Close();
}
}
}

Download example source code: bytescoutxls_changing_data_in_existing_xls.zip (8 KB)

Documentation online: view (separate window)

First steps tutorials:

Advanced Examples: