mORMot Open Source

udihamudi

Member

Registered: 2022-09-16

Posts: 14

Member not found

Hi All,

Getting the above error message for the following line of code -

xlWorksheet.Range(xlRange).Value:=xlValues;

Any ideas?

Thanks!

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: Member not found

Impossible to find out what you expect with so few elements of context.

Are you using an OleVariant xlWorksheet?

It sounds out of mORMot scope, I am afraid.

udihamudi

Member

Registered: 2022-09-16

Posts: 14

Re: Member not found

Yes, not my code but trying to understand and debug -

xlWorksheet   : oleVariant;

////

xlValues[numCol]:=oleVariant(UTF8toUTF16(lTable[numRow][numCol]));

////

xlRange:=oleVariant('A'+intToStr(numRow+1)+':'+colNumToColStr(nbCols)+intToStr(numRow+1));

when I print xlRange it seems ok, xlValues cannot be printed out - seems like some kind of array.

Last edited by udihamudi (2022-09-23 15:58:08)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: Member not found

This has nothing to do with mORMot.

Please try to use some other platform, e.g. stackoverflow or DelphiPraxis.

udihamudi

Member

Registered: 2022-09-16

Posts: 14

Re: Member not found

I printed the exception type and message, saying -

EOleSysError raised, with message: Member not found

Does this give us any clue?

Thanks

igors233

Member

Registered: 2012-09-10

Posts: 241

Re: Member not found

It means object you retrieved do not contain that member (Value or what ever you used). There are examples (and I think library) for working with Excel through OleAPI.

This is not a problem for this forum.