ByteScout Barcode Suite – C# – Change data in existing spreadsheet with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Change data in existing spreadsheet with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-C-sharp-Change-data-in-existing-spreadsheet-with-spreadsheet-sdk.pdf

How to change data in existing spreadsheet with spreadsheet sdk in C# with ByteScout Barcode Suite

This code in C# shows how to change data in existing spreadsheet with spreadsheet sdk with this how to tutorial

An easy to understand guide on how to change data in existing spreadsheet with spreadsheet sdk in C# with this source code sample. ByteScout Barcode Suite is the set that includes three different SDK products to generate barcodes, read barcodes and read and write spreadsheets: Barcode SDK, Barcode Reader SDK and Spreadsheet SDK. It can be applied to change data in existing spreadsheet with spreadsheet sdk using C#.

Want to quickly learn? This fast application programming interfaces of ByteScout Barcode Suite for C# plus the guidelines and the code below will help you quickly learn how to change data in existing spreadsheet with spreadsheet sdk. Simply copy and paste in your C# project or application you and then run your app! Check C# sample code samples to see if they respond to your needs and requirements for the project.

Our website gives trial version of ByteScout Barcode Suite for free. It also includes documentation and source code samples.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Program.cs

      using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.Spreadsheet;
using System.Diagnostics;
using System.IO;

namespace Changing_data_in_existing_XLS
{
    class Program
    {
        static void Main(string[] args)
        {
            // Open Spreadsheet
            Spreadsheet document = new Spreadsheet();
            document.LoadFromFile("AdvancedReport.xls");

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

            // Set cell value
            worksheet.Cell(1, 1).Value = "Homer Jay Simpson 2";

            // delete output file if exists already
            if (File.Exists("AdvancedReport_Modified.xls")){
                File.Delete("AdvancedReport_Modified.xls");
            }


            // Save document
            document.SaveAs("AdvancedReport_Modified.xls");

            // Close Spreadsheet
            document.Close();

            // open output document in default viewer
            Process.Start("AdvancedReport_Modified.xls");
        }
    }
}