ByteScout Data Extraction Suite – C# – Remove columns from existing spreadsheet with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – C# – Remove columns from existing spreadsheet with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-C-sharp-Remove-columns-from-existing-spreadsheet-with-spreadsheet-sdk.pdf

How to remove columns from existing spreadsheet with spreadsheet sdk in C# with ByteScout Data Extraction Suite

This code in C# shows how to remove columns from existing spreadsheet with spreadsheet sdk with this how to tutorial

On this page you will learn from code samples for programming in C#.Writing of the code to remove columns from existing spreadsheet with spreadsheet sdk in C# can be executed by programmers of any level using ByteScout Data Extraction Suite. ByteScout Data Extraction Suite: the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can remove columns from existing spreadsheet with spreadsheet sdk in C#.

These C# code samples for C# guide developers to speed up coding of the application when using ByteScout Data Extraction Suite. This C# sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Want to see how it works with your data then code testing will allow the function to be tested and work properly.

The trial version of ByteScout Data Extraction Suite can be downloaded for free from our website. It also includes source code samples for C# and other programming languages.

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.IO;
using System.Diagnostics;

namespace Removing_columns_from_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];

            // Remove Column
            worksheet.Columns.Delete(1, 1);

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

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

            // Close Spreadsheet
            document.Close();

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