CODEWITHSUNDEEP
excelcom
Hristo Alexsiev
Hristo Alexsiev

Reputation: 146

Reading Excel via COM interop

My coworker have made a srcript that open excel and read values from it. But it has problem it read the value as i see it in the file. I have value 9.12345678 depending on the column size it returns 9.1, 9 and so on. He uses the Text propertie. I have tried using Value and Value2 but no efffect i cannot get 9.12345678. Any Ideas ? Thanks in advance.

Upvotes: 0

Views: 45

Answers (1)

Hristo Alexsiev
Hristo Alexsiev

Reputation: 146

AS Gerg said on Workbook object you set

xlBook.PrecisionAsDisplayed := FALSE;

And then on the range Object You use the .Value Many thanks

Upvotes: 1

Related Questions