Link Search Menu Expand Document

Read TXT (Tab Delimited) - C#

Spreadsheet SDK sample in C# demonstrating ‘Read TXT (Tab Delimited)’

Hello_world.txt
Hello, world!	1	2
3	4	5

Program.cs
using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.Spreadsheet;
using System.IO;

namespace HelloWorld
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create new Spreadsheet
            Spreadsheet document = new Spreadsheet();
	document.LoadFromFile("Hello_World.txt", "\t"); // reading from TXT file using \t (TAB) as delimiter

            // Get first worksheet
            Worksheet worksheet = document.Workbook.Worksheets[0];

            // Read cell value
            Console.WriteLine("Cell (0,0) value: {0}", worksheet.Cell(0, 0).ValueAsExcelDisplays);

            // Write message
            Console.Write("Press any key to continue...");

            // Wait user input
            Console.ReadKey();
        }
    }
}

Download Source Code (.zip)

Return to the previous page Explore Spreadsheet SDK