List of shiftRows() Examples

Examples of shiftRows()

org.apache.poi.hssf.usermodel.HSSFSheet.shiftRows()
Shifts rows between startRow and endRow n number of rows. If you use a negative number, it will shift rows up. Code ensures that rows don't wrap around. Calls shiftRows(startRow, endRow, n, false, false);
Additionally shifts merged regions that are completely defined in these rows (ie. merged 2 cells on a row to be shifted). @param startRow the row to start shifting @param endRow the row to end shifting @param n the number of rows to shift
org.apache.poi.ss.usermodel.Sheet.shiftRows()
Shifts rows between startRow and endRow n number of rows. If you use a negative number, it will shift rows up. Code ensures that rows don't wrap around. Calls shiftRows(startRow, endRow, n, false, false);
Additionally shifts merged regions that are completely defined in these rows (ie. merged 2 cells on a row to be shifted). @param startRow the row to start shifting @param endRow the row to end shifting @param n the number of rows to shift

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()

        Comment comment = sheet.getCellComment(0, 0);
        assertNotNull(comment);
        assertEquals("Amdocs", comment.getAuthor());
        assertEquals("Amdocs:\ntest\n", comment.getString().getString());
        
        sheet.shiftRows(0, 1, 1);


        // comment in row 0 is gone
        comment = sheet.getCellComment(0, 0);
        assertNull(comment);

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.