Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#NAME? error for no apparent reason... | Excel Worksheet Functions | |||
Excel is behaving strangely for no apparent reason. | New Users to Excel | |||
Excel throws exception if cell being edited | Excel Programming | |||
Excel resizes images with no apparent reason | Excel Programming | |||
Error -2147417851 '"The server threw an exception" | Excel Programming |