buffer overrun when using excel automation for importing

Michael_Schumacher
Michael_Schumacher Member Posts: 81
edited 2006-09-18 in NAV/Navision Classic Client
Hi there.

when I try to use excel automation to read data out of excel I very often get a buffer overrun error in Navision.

One reason I found out and eliminated it:
that was when i set the Range-Variable many times to a new value without clearing it. I go around this error by adding a clear(xlrange) at the end of each iteration before setting the cell to a new line.
But there are more reasons...

Is there any way to find out which buffer runs over and why?
regards,
Michael Schumacher

oh, what day is it? Backup day. OK, let's dump all data to /dev/nul ;-)

Comments

  • micieb
    micieb Member Posts: 13
    Hello, i wanted to know if you ever found out more about the buffer overrun emerging from Microsoft Excel?

    grtz
    Straight forward... Move!
  • Michael_Schumacher
    Michael_Schumacher Member Posts: 81
    micieb wrote:
    Hello, i wanted to know if you ever found out more about the buffer overrun emerging from Microsoft Excel?

    grtz
    Nope, I didn't, otherwise there would be [solved] in title :wink:

    I saved excel tables as MSDOS-Text and importet them in temporary tables with a dataport, to get around this problem. From there I can retrieve additional data when importing with XML...
    regards,
    Michael Schumacher

    oh, what day is it? Backup day. OK, let's dump all data to /dev/nul ;-)

Categories