View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lars-Erik Aabech Lars-Erik Aabech is offline
external usenet poster
 
Posts: 3
Default Excel throws -2147417851 (80010105) The server threw an exception. for no apparent reason

Hi!

I've got a .net windows service that generate rather large excel files with
mounds of data. Lately the code has begyn to generate -2147417851 (80010105)
"The server threw an exception" exceptions for no apparent reasons.

The exception occurs when I set a range's value to a two dimentional array
of the same size. I guess the arrays have become to large, they're equal or
greater than 8500x5. (Usually 80+ in column dimension)
I use an Excel interop assembly generated for Excel 2000. (not the PIA's)

I've managed to get rid of the exception by replacing some code with lesser
range value allocations, but this slows down the process even more than it
is allready.

Anyone got any good advice?

Lars-Erik