P
Problem reading with Percentage values
Hi,
I am using OleDB provider to read excel file. I am facing the
problem when reading percentage values from some excel sheets (very rarely).
Suppose a cell has 42.3%, when reading the value it comes like 0.423... but
while reading other Workbook's excel sheets (for those actual value is
24.7%), it reads properly like 24.7.... When i checked excel sheet cell
Format for both Workbooks, it is same with Percentage with 1 decimal.
Connection String i am using to read excel sheet is
Provider=Microsoft.ACE.OLEDB.12.0; Data Source='"
+ strFilePath.Replace("'", "''") + "';Extended Properties=Excel 12.0;
where strFilePath provides the path to excel document.
Thanks
Anil
I am using OleDB provider to read excel file. I am facing the
problem when reading percentage values from some excel sheets (very rarely).
Suppose a cell has 42.3%, when reading the value it comes like 0.423... but
while reading other Workbook's excel sheets (for those actual value is
24.7%), it reads properly like 24.7.... When i checked excel sheet cell
Format for both Workbooks, it is same with Percentage with 1 decimal.
Connection String i am using to read excel sheet is
Provider=Microsoft.ACE.OLEDB.12.0; Data Source='"
+ strFilePath.Replace("'", "''") + "';Extended Properties=Excel 12.0;
where strFilePath provides the path to excel document.
Thanks
Anil