Home

Bytescout.XLS for .NET
Screenshots

Click to view sample
Click to view sample
Click to view sample
Click to view sample
Click to view sample
Click to view sample
Click to view sample Click to view sample

Bytescout.XLS library for .NET

Download Free Trial Buy Now More Information

How to remove columns from existing Excel (.XLS) document using Bytescout.XLS library

This source code sample removes columns from existing XLS document and saves modified document into new document file using Bytescout.XLS lib

Download example source code: bytescoutxls_removing_columns_from_existing_xls.zip (5 KB)

Source document

Column was removed and document saved as new

using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.XLS;

namespace Removing_columns_from_existing_XLS
{
class Program
{
static void Main(string[] args)
{
// Open XLSDocument
XLSDocument document = new XLSDocument("AdvancedReport.xls");
// Get Worksheet
Worksheet worksheet = document.WorkBook.Worksheets[0];
// Remove Column
worksheet.Columns.Delete(1, 1);
// Save document
document.SaveAs("AdvancedReport1.xls");
// Close XLSDocument
document.Close();
}
}
}

Download example source code: bytescoutxls_removing_columns_from_existing_xls.zip (5 KB)

Download Free Trial Buy Now More Information

Documentation online: view (separate window)

First steps tutorials:

Advanced Examples:
Products  |  Download  |  Purchase  |  Support  |  Contacts  |  Testimonials |  

ByteScout, 2003-2008. All other company and product names may be trademarks of their respective companies. Privacy Statement