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

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

Re: How to delete a column from Excel File using java

Show all headers | View raw

On Friday, April 26, 2013 1:34:02 AM UTC-7, Paturi PRADEEP GOUD wrote:
> 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); } } } }

Why not just use sheet.removeColumn( columnNumber ) ?
-- 
Fred K

Back to comp.lang.java.help | Previous | Next — Previous 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