Export worksheet to CSV

The following example shows you how to export a worksheet to CSV format by iterating over all populated cells.

import java.io.FileWriter;
import java.util.List;

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

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");
            Worksheet ws = (Worksheet) book.getSheets().get(0);

            List<Cell> cells = ws.getCells();
            StringBuilder sb = new StringBuilder();
            int currentRow = 0;

            for (Cell cell : cells)
            {
                String ref = cell.getReference();
                int i = 0;
                while (i < ref.length() && Character.isLetter(ref.charAt(i))) i++;
                int row = Integer.parseInt(ref.substring(i));

                if (row > currentRow)
                {
                    if (currentRow > 0) sb.append(System.lineSeparator());
                    currentRow = row;
                }
                else
                {
                    sb.append(',');
                }

                String val = cell.getValue() != null ? cell.getValue().toString() : "";
                if (val.contains(",") || val.contains("\""))
                    val = "\"" + val.replace("\"", "\"\"") + "\"";
                sb.append(val);
            }
            if (currentRow > 0) sb.append(System.lineSeparator());

            try (FileWriter fw = new FileWriter("c:\\test\\output.csv"))
            {
                fw.write(sb.toString());
            }
            System.out.println("Exported " + cells.size() + " cells to CSV.");
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Export worksheet to CSV

Need help? Ask our developers: