trying to edit the data in an excel file

[caro sm]

hello...i'm a new member here
i'm trying to edit the data in an excel file
this the code i'm able to read and change data but not able to update the data
Any help ???

import java.io.FileNotFoundException;
import java.io.BufferedInputStream;
import java.io.FileOutputStream;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFRow;

public class Main {

    public static void main( String [] args ) {
        try {

             InputStream input = new BufferedInputStream(
                        new FileInputStream ("file1.xls"));
            POIFSFileSystem fs = new POIFSFileSystem( input );
            HSSFWorkbook wb = new HSSFWorkbook(fs);
            HSSFSheet sheet = wb.getSheetAt(0);

                      double x;
            Iterator rows = sheet.rowIterator();
            while( rows.hasNext() ) {
                HSSFRow row = (HSSFRow) rows.next();
                System.out.println("\n");
                Iterator cells = row.cellIterator();
                while( cells.hasNext() ) {

                    HSSFCell cell = (HSSFCell) cells.next();
                    if(HSSFCell.CELL_TYPE_NUMERIC==cell.getCellType()){
                        x=cell.getNumericCellValue();
                    if (x<20)  {x=20;
                    cell.setCellValue(x);
                    }
                    else {x=cell.getNumericCellValue();
                    cell.setCellValue(x);}
                    System.out.print( cell.getNumericCellValue()+"     " );}
                    else
                    if(HSSFCell.CELL_TYPE_STRING==cell.getCellType())
                        System.out.print( cell.getStringCellValue()+"     " );
                    else
                        if(HSSFCell.CELL_TYPE_BOOLEAN==cell.getCellType())
                        System.out.print( cell.getBooleanCellValue()+"     " );
                        else
                            if(HSSFCell.CELL_TYPE_BLANK==cell.getCellType())
                                System.out.print( "BLANK     " );
                                else
                            System.out.print("Unknown cell type");

                }


            }


        } catch ( IOException ex ) {
            ex.printStackTrace();
        }
        
  
  }

}

[caro sm]

you are right i will get use to do that...thank you

[Tony Docherty]

Can you be more specific about what your problem is. Do you mean you can't update a cell value, formula etc or that you can't save your changes or is it something else altogether?

[caro sm]

the changes are done and outputed but not saved to the old excel file

[Tony Docherty]

It's a while since I used POI but don't you just create a FileOutputStream and pass it to the workbook's write method(). Something like:

        out = new FileOutputStream(saveFile);
        workbook.write(out);