Copy a single column of a excel sheet to other excel sheet

[Prasad Rooge]

is it possible to copy a single column of a excel sheet to other excel sheet??

[Tero Muhonen]

Hi Prasad,

I would take a look Apache POI API (http://poi.apache.org/). Here's an example from the POI guide:

InputStream inp = new FileInputStream("workbook.xls");
    //InputStream inp = new FileInputStream("workbook.xlsx");

    Workbook wb = WorkbookFactory.create(inp);
    Sheet sheet = wb.getSheetAt(0);
    Row row = sheet.getRow(2);
    Cell cell = row.getCell(3);
    if (cell == null)
        cell = row.createCell(3);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue("a test");

    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("workbook.xls");
    wb.write(fileOut);
    fileOut.close();

[Prasad Rooge]

well i did it using JXL...

Workbook workbook = Workbook.getWorkbook(new File("new.xls"));
            Sheet sheet = workbook.getSheet(0);
            Cell policies[] = sheet.getColumn(1);

Thanks anyways

[Campbell Ritchie]

Thank you for the solutions, and welcome to the Ranch both of you