Write String to Excel Sheet using jExcel API

Question

I was going through this article by which I can start writing to Microsoft Excel sheet. But it shows only how to write an Integer. In my case I need to write Strings to Excel Sheet. In that strings I have IP Address as well.

So below is the scenario in which it is failing because ipAddress is String with dots in between the number. And also I cannot convert that String to Integer because of dots in between the number so that is the reason I was looking for other alternative.

So is there any other alternative to Number class below which I can use for String?

addNumber(sheet, 0, j, ipAddress);


private void addNumber(WritableSheet sheet, int column, int row, Integer integer) throws WriteException,
        RowsExceededException {
    Number number;
    number = new Number(column, row, integer, times);
    sheet.addCell(number);
}

NARENDRA · Accepted Answer · 2012-11-16 03:52:21Z

4

you can try by using new Label() as follow

sheet.addCell(new Label(column, row, String))

answered Nov 16, 2012 at 3:52

NARENDRA

3951 gold badge7 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Write String to Excel Sheet using jExcel API

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related