Decimal type in Excel 97

[E-Cube]

I am creating an vb.net application that uses Excel 97 to generate xls reports.

I create an array object that contains dot.net decimal types and pass that
array object into a range object from Excel 97, would errors occur? I ask
because I get 0x800A03EC when setting a range objects value method to the
data array I created.


Thank you in advance for your assistance.

[Jerry W. Lewis]

You must explicitly coerce from decimal to double before putting them into a
range object.

Jerry

"E-Cube" wrote:

> I am creating an vb.net application that uses Excel 97 to generate xls reports.
>
> I create an array object that contains dot.net decimal types and pass that
> array object into a range object from Excel 97, would errors occur? I ask
> because I get 0x800A03EC when setting a range objects value method to the
> data array I created.
>
>
> Thank you in advance for your assistance.
>
>

[E-Cube]

Jerry,

Thank you that worked.

Eric

"Jerry W. Lewis" wrote:

> You must explicitly coerce from decimal to double before putting them into a
> range object.
>
> Jerry
>
> "E-Cube" wrote:
>
> > I am creating an vb.net application that uses Excel 97 to generate xls reports.
> >
> > I create an array object that contains dot.net decimal types and pass that
> > array object into a range object from Excel 97, would errors occur? I ask
> > because I get 0x800A03EC when setting a range objects value method to the
> > data array I created.
> >
> >
> > Thank you in advance for your assistance.
> >
> >