Loading info using interop

ohernandez@sistemas-liasa.com · Fri Aug 30, 2019 10:32 pm

Hi,
I have a problem importing files from excel, when the cell contents "800 3/4" as a raw material code, the result is loaded as 800.75.
I am using:
VO through Excel.Application.
.NET Interop.
.NET Devexpress worksheet.
Excel ole connection.
All of them import 800.75.
The problem is solved if the user use the apostrophe as a prefix; but we want to keep the process with no modification by the user.

TIA,
Oscar Hernandez

robert · Post by **robert** » Sat Aug 31, 2019 8:29 am

Oscar,
Can you show us some code?
Which property of the cell are you reading ?

Robert

Chris · Post by **Chris** » Sat Aug 31, 2019 8:38 am

I think that's just a "feature" of Excel, it tries to be too "smart" about it. Isn't there a way to query the contents of the cell as text format only?

robert · Post by **robert** » Sat Aug 31, 2019 8:39 am

Chris,
There is a Formula property that returns the contents of a cell as string

Robert

ohernandez@sistemas-liasa.com · Sat Aug 31, 2019 3:38 pm

Robert, Chris,
Thanks for the tip, looking for properties like Formula, we found displaytext that did the work.
We will change from a massive way to import into cell by cell using displaytext for the fields that expect string.