How to fill excel data from arraylist in java

Question

0.00/5 (No votes)

See more:

First i have arraylist data like 1,2,3,4,5,6,7,8
after i click the button it will put the arraylist data to my excel database.
But the arraylist data wouldn't start from column A but start from column F in the excel

Before that, i want to using excel to be my database to store some data. This is my first time i using excel for my database

Posted 31-Mar-13 19:18pm

yudhistira adytia

Updated 25-Mar-20 14:16pm

Add a Solution

Comments

Nountylegre 11-Apr-19 10:06am

Here is another sample based on this java excel library:

List<integer> data = new ArrayList<integer>();
data.add(1);
data.add(2);
data.add(3);
// ...

SpreadsheetInfo.setLicense("FREE-LIMITED-KEY");

ExcelFile workbook = ExcelFile.load("input.xlsx");
ExcelWorksheet worksheet = workbook.getWorksheet(0);
ExcelColumn column = worksheet.getColumn("F");

for (int i = 0; i < data.size(); i++) {
Integer value = data.get(i);
column.getCell(i).setValue(value);
}

workbook.save("output.xlsx");

Member 15694833 2-Jul-22 21:02pm

This comment ended up in the Mel Gibson movie "Hot Seat" after it was copy/pasted into this gif: https://www.shutterstock.com/video/clip-1071725005-access-granted-sign-security-guard-control-successful

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Khandekar · Answer 1 · 2013-03-31T19:43:00

Hello,

Here is a sample based on apache POI.

Java

public void fillData(int[] intArr)
{
    int startCell = 6;     // Corrosponds to F
    HSSFWorkbook workbook = null;
    HSSFSheet sheet = null;
    HSSFCell cell = null;
    HSSFRow sheetRow = null;

    workbook = new HSSFWorkbook();
    sheet = workbook.createSheet("WorkSheet");
    sheetRow = getRow(sheet, 0);
    for (int val : intArr)
    {
        cell = sheetRow.createCell(startCell);
        cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
        cell.setCellValue(((Integer) value).doubleValue());
    }
}

/**
 * Helper method to retrieve the numbered row. If row does not exists then
 * a new row is inserted and it's reference is returned.
 * @param sheet The worksheet from which a row reference is sought.
 * @param rowNum the row number
 * @return the reference to the numbered row.
 */
protected final HSSFRow getRow(HSSFSheet sheet, int rowNum)
{
    HSSFRow sheetRow = null ;

    sheetRow = sheet.getRow(rowNum);
    if (null == sheetRow)
        sheetRow = sheet.createRow(rowNum);

    return sheetRow;
}

More info can be found at Apache POI Site[^].

Regards,