ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Exception from HRESULT: 0x800A03EC (https://www.excelbanter.com/new-users-excel/100541-exception-hresult-0x800a03ec.html)

nano2k

Exception from HRESULT: 0x800A03EC
 
Hi

The code that generates this error is the following:

public void SetBuffer2(object[,] buf, int firstRow, int firstColumn,
int upperBound0, int upperBound1, int wSheetIndex)
{
Excel.Worksheet wSheet = this.GetWorkSheet(wSheetIndex);
if (wSheet!=null)
{
Excel.Range range = (Excel.Range)wSheet.Cells[firstRow,
firstColumn];
range = range.get_Resize(upperBound0, upperBound1);
range.Value2 = buf; // <<<--- THIS LINE GENERATES THE ERROR
}
}


The bounds of the arrays are ok.
It seems that the error is raised because of some value that is
"longer" than accepted by the cell ( ? )
I'm trying to insert an approx 13KB -length text into some cell. I
mean, the value corresponding to some cell is a 13KB sized string.
If I truncate the string for that particular cell, to under 1KB,
everything goes with no problems at all.
I also found this problem discussed he

http://groups.google.ro/group/micros...a77ec8cd6ad468

But no solution :(

Any help?
Thanks in advance.



All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com