Bulk fill worksheet

The following example shows you how to efficiently populate a large number of rows in a worksheet using a loop.

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

public class Example {

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

            sheet.set("A1", new Cell("Name"));
            sheet.set("B1", new Cell("Value"));
            sheet.set("C1", new Cell("Category"));

            for (int i = 2; i <= 1001; i++)
            {
                sheet.set("A" + i, new Cell("Item " + (i - 1)));
                sheet.set("B" + i, new Cell(i * 1.5));
                String cat = (i % 3 == 0) ? "C" : (i % 2 == 0) ? "B" : "A";
                sheet.set("C" + i, new Cell(cat));
            }

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

            System.out.println("1000 data rows written successfully.");
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Bulk fill worksheet

Need help? Ask our developers: