Number Stored as Text in Excel Output

[anvi kon]

Hi,

I'm using jxl for exporting data from java to excel.
when I export data on excel the number stored as text not numbers, so I can't do arithmetic on these fields.

What is the best way to stored as a number on excel?


thanks,

[Rob Spoor]

How are you creating your cells?

Moving to Other Open Source Projects.

[anvi kon]

I'm creating cells like below

public Label getFormattedLabel(int colnum, int rownum, String value, String type) 
{

Label label2 = new Label(colnum, rownum, value); 

if(type == "d") 
label2.setCellFormat(getDataFont());

return label2; 
}

Calling like below

WritableWorkbook wb = null; 
NumberFormat nfCurrency = NumberFormat.getCurrencyInstance(java.util.Locale.US);

wb.getSheet(0).addCell(getFormattedLabel(0, 3 , nfCurrency.format("123333.77"), "d")); 

thanks

[Ulf Dittmer]

Isn't there a way to set the cell type explicitly to numeric? Also, "Label" sounds more like string-type entity than a numeric entity.