Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem reading with Percentage values

1 view
Skip to first unread message

reading with Percentage values@discussions.microsoft.com Problem reading with Percentage values

unread,
Nov 24, 2009, 1:13:01 AM11/24/09
to
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

0 new messages