EXCEL unknown values - #VALUE (#WAARDE)

micieb

Is there anybody who knows how it is possible to enforce error-handling when importing an excel file (using table 370 excel buffer)?

When there are fields like #VALUE or #NAME, etc... then Navision generates an error or crashes. 8-[

Anybody an idea or example? thanks.

Xypher

Nav creates a throw from the statement, within ReadSheet(),

"Cell Value as Text" := DELCHR(FORMAT(XlWrkSht.Range(xlColID + xlRowID).Value),'<',' ');

when Excel tries to send back a data type not supported by Nav (due to #VALUE, #NAME, etc.)

To simply alleviate this you can alter the above line of code to match the below.

"Cell Value as Text" := DELCHR(FORMAT(XlWrkSht.Range(xlColID + xlRowID).Text),'<',' ');

I'm just curious as to why this was never tested prior to release. Since it is not uncommon at all to find #VALUE, #NAME, etc popping up in excel documents.

(Furthermore why the explicit use of ' ' with DELCHR(...,'<',' ');. Is this to provide legibility? Or do they just not care to use the said function's default value of the [, Which] parameter?)