EXCEL unknown values - #VALUE (#WAARDE)

micieb
micieb Member Posts: 13
edited 2008-07-09 in NAV/Navision Classic Client
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.
Straight forward... Move!

Comments

  • Xypher
    Xypher Member Posts: 297
    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?)

Categories