Loading info using interop
Posted: 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
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