buffer overrun when using excel automation for importing

Michael_Schumacher

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?

micieb

Hello, i wanted to know if you ever found out more about the buffer overrun emerging from Microsoft Excel?

grtz

Michael_Schumacher

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

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...