ByteScout Data Extraction Suite - C# - Swap cells and their values with spreadsheet sdk - ByteScout

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

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

swap cells and their values with spreadsheet sdk in C# using ByteScout Data Extraction Suite

swap cells and their values with spreadsheet sdk in C#

ByteScout tutorials describe the stuff for programmers who use C#. ByteScout Data Extraction Suite was created to assist swap cells and their values with spreadsheet sdk in C#. ByteScout Data Extraction Suite is the set that includes 3 SDK products for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK.

The below SDK samples describe how to quickly make your application do swap cells and their values with spreadsheet sdk in C# with the help of ByteScout Data Extraction Suite. To use swap cells and their values with spreadsheet sdk in your C# project or application just copy & paste the code and then run your app! Use of ByteScout Data Extraction Suite in C# is also described in the documentation included along with the product.

Visit our website to get a free trial version of ByteScout Data Extraction Suite. Free trial contains many of source code samples to help you with your C# project.

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"); } } }

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Data Extraction Suite Home Page

Explore ByteScout Data Extraction Suite Documentation

Explore Samples

Sign Up for ByteScout Data Extraction Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

VIDEO

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Data Extraction Suite Home Page

Explore ByteScout Data Extraction Suite Documentation

Explore Samples

Sign Up for ByteScout Data Extraction Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Tutorials:

prev
next