CODEWITHSUNDEEP
c#excel
Netanel Stern
Netanel Stern

Reputation: 159

Write multiple sheets in excel file using ByteScout Spreadsheet

I have several DataTable objects and I want to write them to one excel file but various sheets.

I'm using bytescout.spreadsheet to work with excel files.

How can I write multiple table sheets to excel file using this tool and C#?

Upvotes: 0

Views: 1360

Answers (1)

Philip Pittle
Philip Pittle

Reputation: 12305

Read the manual: http://bytescout.com/products/developer/spreadsheetsdk/bytescoutxls_working_with_worksheets_in_xls_document.html

using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.Spreadsheet;
namespace Worksheets
{

internal class Program
{
    private static void Main(string[] args)
    {
    // Create new Spreadsheet
        Spreadsheet document = new Spreadsheet();
      // 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");
    }
}

Upvotes: 1

Related Questions