Thank you Mark.
Following is my code, but it doesn't work at all.
Is there some problem?
==================
==================
HSSFCell cc = sourceRow.getCell(0);
if(cc ==null){
cc = sourceRow.createCell(0);
}
cc.setCellValue("");
cc.setAsActiveCell();
sheet.setColumnWidth(0, 3500);
fos = new FileOutputStream(path + "/update.xls");
wbCreat.write(fos);
Regards,
Mead
On Fri, Mar 30, 2012 at 2:31 PM, Mark Beardsley <[email protected]>wrote:
> The first thing that springs to mind is the setAsActiveCell() method
> defined
> for both XSSFCell and HSSFCell. Once you have built the worksheet, get a
> reference for cell A1 and call the setAsActiveCell() method on that before
> you save the file away; it might even be possible to call this method at
> the
> start of the process, as you are building the worksheet and creating cell
> A1
> (assuming that is top, left hand most cell that users can populate on the
> sheet).
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/how-to-set-to-first-column-and-first-row-active-tp5605774p5605803.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
