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

Excel throws -2147417851 (80010105) The server threw an exception. for no apparent reason
 

Does these help ?

http://support.microsoft.com/kb/q177991/
http://groups.google.co.uk/group/mic...574a5f 04e11a


NickHK


"Lars-Erik Aabech" wrote in message
...
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

Excel throws -2147417851 (80010105) The server threw an exception. for no apparent reason
 

Not really, this should apply:

Version of Passing Array to
Microsoft Excel Worksheet Range
-----------------------------------------
9.0 (Excel 2000) F

F: The maximum number of elements in the array is limited by available
memory or the Excel worksheet maximum size (65536 rows X 256 columns).
However, the maximum number of elements in the array that you can pass to
Excel using the Excel Transpose function is 5461. If you exceed this limit,
you receive the following error message:
Run-time error '13':
Type Mismatch

My arrays are smaller, and I don't use transpose..

L-E


"NickHK" wrote in message
...
Does these help ?

http://support.microsoft.com/kb/q177991/
http://groups.google.co.uk/group/mic...574a5f 04e11a


NickHK


"Lars-Erik Aabech" wrote in message
...
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