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.

import java.io.BufferedReader;
import java.io.FileReader;

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    private static final String[] COL_LETTERS = {"A","B","C","D","E","F","G","H","I","J"};

    public static void main(String[] args)
    {
        try
        {
            Worksheet sheet = new Worksheet();
            sheet.setName("Imported");

            int row = 1;
            try (BufferedReader br = new BufferedReader(new FileReader("c:\\test\\input.csv")))
            {
                String line;
                while ((line = br.readLine()) != null)
                {
                    String[] parts = line.split(",");
                    for (int c = 0; c < parts.length && c < COL_LETTERS.length; c++)
                    {
                        sheet.set(COL_LETTERS[c] + row, new Cell(parts[c].trim()));
                    }
                    row++;
                }
            }

            Workbook book = new Workbook();
            book.getSheets().add(sheet);
            book.save("c:\\test\\output.xlsx", true);

            System.out.println("Imported " + (row - 1) + " rows from CSV.");
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Import CSV data

Need help? Ask our developers: