This project is read-only.

fail to read currency

Aug 12, 2010 at 2:35 AM
i tried to read a cell with value 4,600.00
Decimal payment = Decimal.Parse(
                      row.GetCell(j).ToString()
                  );
but get "_*4,600.00"
any idea?

 

Aug 13, 2010 at 8:36 AM
Can you sent me the original file?
Aug 15, 2010 at 3:33 PM

Hi tonygus,

Set the category of Format Cells Number to Accounting in EXCEL

You will get the  _*

 

I have fixed it using  row.GetCell(i).NumericCellValue

but you must make sure the cell is "Value", for Text it will throw an exception,

which is very annoying

 

that will be great if NPOI have sth like this:

row.GetCell(i).Value