[Octave-bug-tracker] [bug #59176] error: com_get: property/method invocation on the COM object failed with error `0x8002000e'

[anonymous]

URL:
  <https://savannah.gnu.org/bugs/?59176>

                 Summary: error: com_get: property/method invocation on the
COM object failed with error `0x8002000e'
                 Project: GNU Octave
            Submitted by: None
            Submitted on: Fri 25 Sep 2020 09:56:39 AM UTC
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Unexpected Error or Warning
                  Status: None
             Assigned to: None
         Originator Name: David
        Originator Email: davidampurua@gmail.com
             Open/Closed: Open
                 Release: 5.2.0
         Discussion Lock: Any
        Operating System: Microsoft Windows

    _______________________________________________________

Details:

Hello everyone,

Frist of all I have to say that this is my first bug report ever so please be
gentle with me.
The problem that I have detect is the next one, I have a code that has been
done in Matlab (and it run well), but with Octave return an error

The code is the following:
eAplicacion = actxserver ('Excel.Application');
eLibro = eAplicacion.Workbooks.Open(abspath([cabeceraOut nombreTipo
'.xlsx']));
eLibro.Worksheets.Item(1).Name = 'page1';

And the error this one:
error: com_get: property/method invocation on the COM object failed with error
`0x8002000e'

So, I ran the debugger and I saw that If I put this:
eLibro.Worksheets(1).Name = 'page1'; instead of eLibro.Worksheets.Item(1).Name
= 'page1';

There is no error, and everything goes fine. But the thing is according to
Microsoft’s documentation
(https://docs.microsoft.com/en-us/office/vba/api/excel.worksheets.item) both
are equivalent.
So both would have to be correct right?

And, in advance, thanks you very much for your help.




    _______________________________________________________

Reply to this item at:

  <https://savannah.gnu.org/bugs/?59176>

_______________________________________________
  Message sent via Savannah
  https://savannah.gnu.org/