Options

buffer overrun when using excel automation for importing

Michael_SchumacherMichael_Schumacher Member Posts: 81
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

  • Options
    miciebmicieb 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!
  • Options
    Michael_SchumacherMichael_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 ;-)
Sign In or Register to comment.