Hi,
setCellType to the rescue:
void setCellType(int cellType)
set the cells type (numeric, formula or string)
Regards,
Leen Toelen
On 10/19/05, Murali Krishna <[EMAIL PROTECTED]> wrote:
> Hi,
> I am getting a small green icon in the cell when i insert a string which is
> numeric data in the excel cell. the exact message is "the number in this cell
> is formatted as text or preceded by an apostophe".
>
> is there anyway I can get rid of that. Below is the sample code that I wrote.
>
> Thanks,
> Murali
>
>
> public class IntFormatting {
> public static void main(String ar[]){
>
> HSSFWorkbook wb = new HSSFWorkbook();
> HSSFSheet sheet = wb.createSheet("format sheet");
> HSSFCellStyle style;
> HSSFDataFormat format = wb.createDataFormat();
> HSSFRow row;
> HSSFCell cell;
> short rowNum = 0;
> short colNum = 0;
>
> row = sheet.createRow(rowNum++);
> cell = row.createCell(colNum++);
> String s="1234343";
>
> cell.setCellValue(s);
>
> String file = "c:\\intformatting.xls";
> try{
> FileOutputStream fileOut = new FileOutputStream(file);
> wb.write(fileOut);
> fileOut.close();
> }
> catch(IOException ioe){
> ioe.printStackTrace();
> }
> System.out.println("output written to file : " + file);
> }
> }
>
>
>
> ---------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
