Import CSV data

The following example shows you how to import data from a CSV file into a worksheet by reading each line and populating cells.

C# example

using System;
using System.IO;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            string[] colLetters = { "A","B","C","D","E","F","G","H","I","J" };
            string[] lines = File.ReadAllLines("c:\\test\\input.csv");

            Worksheet sheet = new Worksheet();
            sheet.Name = "Imported";

            for (int r = 0; r < lines.Length; r++)
            {
                string[] parts = lines[r].Split(',');
                for (int c = 0; c < parts.Length && c < colLetters.Length; c++)
                {
                    string cellRef = colLetters[c] + (r + 1);
                    sheet[cellRef] = new Cell(parts[c].Trim());
                }
            }

            Workbook book = new Workbook();
            book.Sheets.Add(sheet);
            book.Save("c:\\test\\output.xlsx", true);

            Console.WriteLine("Imported " + lines.Length + " rows from CSV.");
        }
    }
}

VB example

Imports System
Imports System.IO
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim colLetters As String() = {"A","B","C","D","E","F","G","H","I","J"}
        Dim lines As String() = File.ReadAllLines("c:\test\input.csv")

        Dim sheet As New Worksheet()
        sheet.Name = "Imported"

        For r As Integer = 0 To lines.Length - 1
            Dim parts As String() = lines(r).Split(","c)
            For c As Integer = 0 To Math.Min(parts.Length, colLetters.Length) - 1
                Dim cellRef As String = colLetters(c) & (r + 1)
                sheet(cellRef) = New Cell(parts(c).Trim())
            Next
        Next

        Dim book As New Workbook()
        book.Sheets.Add(sheet)
        book.Save("c:\test\output.xlsx", True)

        Console.WriteLine("Imported " & lines.Length & " rows from CSV.")

    End Sub
End Module

IndependentsoftProfessional software libraries for developers

Spreadsheet .NET > Tutorial > Import CSV data

Need help? Ask our developers: