Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.help > #2694

How to delete a column from Excel File using java

Show all headers | View raw

I want to delete a column from Excel file using java. Following code I build to meet my requirement. but it is not working. Can anybody please help where I am going wrong.

public class Column
{
public static void main(String[] args)
{
Workbook wb = WorkbookFactory.create(new FileInputStream("Excel.xls"));
Sheet sheet = wb.getSheet("Failures");
Cell cell;
Column column;
Row row= sheet.getRow(0);
int numXolumns = row.getLastCellNum();

for(int col=0; col< numXolumns; col++)
  {
           cell = row.getCell(col);
           String columnName = cell.getStringCellValue();
           int Combo_index = 0;
           if(columnName.contains("Combo".trim()))
           {
               Combo_index=cell.getColumnIndex();
               sheet.removeRow(row);
           }
  }
}
}

Back to comp.lang.java.help | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

How to delete a column from Excel File using java Paturi PRADEEP GOUD <paturi.pradeepgoud.mca@gmail.com> - 2013-04-26 01:34 -0700
  Re: How to delete a column from Excel File using java Fred Kleinschmidt <fred.l.kleinschmidt@gmail.com> - 2013-04-26 08:04 -0700

csiph-web