ByteScout Barcode Suite – C# – Swap cells and their values with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Swap cells and their values with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-C-sharp-Swap-cells-and-their-values-with-spreadsheet-sdk.pdf

swap cells and their values with spreadsheet sdk in C# with ByteScout Barcode Suite

How to apply ByteScout Barcode Suite for swap cells and their values with spreadsheet sdk in C#

The documentation is crafted to assist you to apply the features on your side easily. ByteScout Barcode Suite was made to help with swap cells and their values with spreadsheet sdk in C#. 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.

C# code snippet like this for ByteScout Barcode Suite works best when you need to quickly implement swap cells and their values with spreadsheet sdk in your C# application. If you want to implement this functionality, you should copy and paste code below into your app using code editor. Then compile and run your application. Use of ByteScout Barcode Suite in C# is also described in the documentation included along with the product.

Trial version along with the source code samples for C# can be downloaded from our website

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 Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            // Open existing Spreadsheets
            Spreadsheet document1 = new Spreadsheet();
	document1.LoadFromFile("input.xls");

            // Get first cell value
            object value1 = document1.Worksheet(0).Cell("A1").Value;
            // Get another cell value
            object value2 = document1.Worksheet(0).Cell("B1").Value;

            // Swap them
            object value3;
            value3 = value2;
            value2 = value1;
            value1 = value3;

            document1.Worksheet(0).Cell("A1").Value = value1;
            document1.Worksheet(0).Cell("B1").Value = value2;

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

            // Save document
            document1.SaveAs("Output.xls");

            // Close Spreadsheet
            document1.Close();

            // open generated XLS document in default program
            Process.Start("Output.xls");

        }
    }
}