How to add rows/columns in worksheet

Question

asked 2013-06-11 13:39:21 +0800

1 ● 1

Hi I want to add rows/columns to excel sheet using java class with spreadsheet object... Please let me know the solution for this problem

Answer 1

answered 2013-06-12 12:35:32 +0800

zknl
124 ● 2

Hi,

i just know to add single row/column to sheet like following:

int lCol = spreadsheet.getBook().getWorksheetAt(0).getRow(13).getFirstCellNum();

int rCol = spreadsheet.getBook().getWorksheetAt(0).getRow(13).getLastCellNum();

/////to add row Ranges.range(spreadsheet.getBook().getWorksheetAt(0), 13,lCol, 13,rCol).insert(Range.SHIFTDOWN, Range.FORMATLEFTABOVE);

//// to add column
Ranges.range(spreadsheet.getBook().getWorksheetAt(0), 13,lCol, 13,rCol).insert(Range.SHIFTRIGHT, Range.FORMATRIGHTBELOW);

here 13 is no of row after which u want to add row

or you can add multiple rows as well ( but when i tried it gets appended at start of current worksheet )

for(int l=0; l<4;l++)
    {
        spreadsheet.getBook().getWorksheetAt(0).createRow(l);
    }

hope this will help u....

1 Answer