Add worksheets in XLS documet, Get worksheet using its name, Access data within worksheet using Bytescout.XLS library

Bytescout.XLS library for .NET

Add new worksheets into Excel document, access existing worksheets and their data using Bytescout.XLS library

This sample provides source code example to show how to add worksheets in XLS Excel document, how to access existing worksheet using worksheet name, how to access cells in worksheet using Bytescout.XLS library for .NET

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

Excel document with new worksheets

using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.XLS;
namespace Worksheets
{
class Program
{
static void Main(string[] args)
{
// Create new XLSDocument
XLSDocument document = new XLSDocument();
// Add worksheets
Worksheet worksheet1 = document.WorkBook.Worksheets.Add("Demo worksheet 1");
Worksheet worksheet2 = document.WorkBook.Worksheets.Add("Demo worksheet 2");
// Get worksheet by name
Worksheet worksheetByName = document.WorkBook.Worksheets.ByName("Demo worksheet 2");
// Set cell values
worksheet1.Cell(0, 0).Value = "This is Demo worksheet 1";
worksheetByName.Cell(0, 0).Value = "This is Demo worksheet 2";
// Save document
document.SaveAs("Worksheets.xls");
}
}
}

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

First steps tutorials:

Advanced Examples: