ByteScout Data Extraction Suite – C# – Set shrinktofit for cells with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – C# – Set shrinktofit for cells with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-C-sharp-Set-shrinktofit-for-cells-with-spreadsheet-sdk.pdf

How to set shrinktofit for cells with spreadsheet sdk in C# using ByteScout Data Extraction Suite

Step-by-step tutorial on how to set shrinktofit for cells with spreadsheet sdk in C#

Quickly learn how to set shrinktofit for cells with spreadsheet sdk in C# with this sample source code. What is ByteScout Data Extraction Suite? It 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. It can help you to set shrinktofit for cells with spreadsheet sdk in your C# application.

The following code snippet for ByteScout Data Extraction Suite works best when you need to quickly set shrinktofit for cells with spreadsheet sdk in your C# application. Follow the instructions from scratch to work and copy the C# code. Want to see how it works with your data then code testing will allow the function to be tested and work properly.

All these programming tutorials along with source code samples and ByteScout free trial version are available for download 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 System.Diagnostics;
using Bytescout.Spreadsheet;
using System.IO;


namespace HelloWorld
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create new Spreadsheet
            Spreadsheet document = new Spreadsheet();

            // Add new worksheet
            Worksheet worksheet = document.Workbook.Worksheets.Add("HelloWorld");

            // Set cell value
            worksheet.Cell(0, 0).Value = "Very, very, very, very long text";

            // Shrink text
            worksheet.Cell(0, 0).ShrinkToFit = true;

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