[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Windows Package
From: |
John Hudock |
Subject: |
Re: Windows Package |
Date: |
Thu, 22 Jul 2010 10:27:25 -0700 (PDT) |
I have done some additional tests and am even more confused. The COM
functions all seem to work, but for some reason can't be assigned (except
indirectly).
>>> wb=app.Workbooks.Open("C:\\OctaveTest.xls");
>>>error: can't perform indexing operations for octave_com_object type //
Error
>>> app.Workbooks.Open("C:\\OctaveTest.xls") // But call works
ans =
<COM object _Workbook (0x0x260224)>
>>> wb
>>>error: `wb' undefined near line 17 column 1
>>> ans
ans =
<COM object _Workbook (0x0x260224)>
>>> wb=ans // And I can assign ans to wb even though i can't assign
>>> original call
wb =
<COM object _Workbook (0x0x260224)>
>>> wb
wb =
<COM object _Workbook (0x0x260224)>
>>> sh = wb.Worksheets("Sheet1"); // Same problem, can't assign
>>>error: can't perform indexing operations for octave_com_object type
>>> wb.Worksheets("Sheet1")
ans =
<COM object _Worksheet (0x0x2603b4)>
>>> sh = ans // but can do call and assign ans
sh =
<COM object _Worksheet (0x0x2603b4)>
>>> sh.Range("A2:D50")
ans =
<COM object Range (0x0x258d9c)>
>>> r = ans
r =
<COM object Range (0x0x258d9c)>
>>> r.Value
ans =
{
[1,1] = -2
[2,1] = 1.0200
[3,1] = 3.0300
[4,1] = -11.760
[5,1] = -3.3300
[6,1] = 1.1500
[7,1] = 0
[8,1] = -1.1400
[9,1] = -1.1500
[10,1] = 0
[11,1] = -2.3300
[12,1] = 0
[13,1] = 4.7600
[14,1] = 4.5500
[15,1] = 7.6100
[16,1] = 5.0500
[17,1] = -0.96000
[18,1] = 9.7100
[19,1] = 0
[20,1] = -7.0800
[21,1] = 3.8100
[22,1] = -4.5900
[23,1] = 6.7300
[24,1] = 12.610
[25,1] = 8
[26,1] = 8.8900
[27,1] = 4.7600
[28,1] = 5.1900
[29,1] = 8.0200
[30,1] = 4
[31,1] = 8.2400
[32,1] = 2.0300
[33,1] = 4.4800
[34,1] = 3.3300
[35,1] = 17.510
[36,1] = 8.6300
[37,1] = 1.4400
[38,1] = 8.5400
[39,1] = 0
[40,1] = -11.150
[41,1] = 2.2100
[42,1] = 1.8100
[43,1] = 6.0300
[44,1] = -5.0200
[45,1] = -5.6300
[46,1] = -0.37000
[47,1] = -14.230
[48,1] = -5.6800
[49,1] = -0.46000
[1,2] = 5
[2,2] = 6.6700
[3,2] = 3.5700
[4,2] = 0
[5,2] = -3.4500
[6,2] = 4.4600
[7,2] = 7.6900
[8,2] = 3.9700
[9,2] = -2.2900
[10,2] = -3.1200
[11,2] = 4.0300
[12,2] = 6.9800
[13,2] = 5.0700
[14,2] = -5.5200
[15,2] = 0.73000
[16,2] = 7.2500
[17,2] = 8.1100
[18,2] = 21.250
[19,2] = -1.5500
[20,2] = 18.320
[21,2] = 5.7500
[22,2] = -2.5100
[23,2] = -24.030
[24,2] = 22.030
[25,2] = -0.93000
[26,2] = 3.2700
[27,2] = 4.5200
[28,2] = 11.690
[29,2] = 8.9100
[30,2] = 4.9800
[31,2] = 8.8100
[32,2] = -7.7900
[33,2] = 8.7800
[34,2] = 28.570
[35,2] = 5.0700
[36,2] = 27.820
[37,2] = 16.910
[38,2] = 87.850
[39,2] = -21.050
[40,2] = -42.320
[41,2] = 1.9800
[42,2] = -15.170
[43,2] = 10.400
[44,2] = -14.310
[45,2] = -10.330
[46,2] = 15.200
[47,2] = -15.320
[48,2] = -16.580
[49,2] = 5.4200
[1,3] = 3
[2,3] = -2.9100
[3,3] = -1
[4,3] = -6.0600
[5,3] = -3.2300
[6,3] = -2.2200
[7,3] = 5.6800
[8,3] = -1.0800
[9,3] = -3.2600
[10,3] = 1.1200
[11,3] = -1.1100
[12,3] = 2.2500
[13,3] = 4.4000
[14,3] = -1.0500
[15,3] = -2.1300
[16,3] = 0
[17,3] = 5.4300
[18,3] = -2.0600
[19,3] = 2.1100
[20,3] = -3.0900
[21,3] = -8.5100
[22,3] = -6.9800
[23,3] = 6.2500
[24,3] = 3.5300
[25,3] = 6.8200
[26,3] = 6.3800
[27,3] = 12
[28,3] = 2.6800
[29,3] = 5.2200
[30,3] = -4.1300
[31,3] = 6.9000
[32,3] = 0
[33,3] = -1.6100
[34,3] = -4.1000
[35,3] = -6.8400
[36,3] = -2.7500
[37,3] = 6.6000
[38,3] = 13.270
[39,3] = 5.4700
[40,3] = 6.6700
[41,3] = 2.7800
[42,3] = 3.3800
[43,3] = -5.8800
[44,3] = -8.3300
[45,3] = 2.2700
[46,3] = 1.4800
[47,3] = -18.250
[48,3] = -5.3600
[49,3] = 0
[1,4] = -6
[2,4] = -3.1900
[3,4] = 1.1000
[4,4] = -4.3500
[5,4] = -10.230
[6,4] = -3.8000
[7,4] = 6.5800
[8,4] = 0
[9,4] = -1.2300
[10,4] = -2.5000
[11,4] = -3.8500
[12,4] = -2.6700
[13,4] = 13.700
[14,4] = 3.6100
[15,4] = 1.1600
[16,4] = -6.9000
[17,4] = 4.9400
[18,4] = 0
[19,4] = 4.7100
[20,4] = -2.2500
[21,4] = -1.1500
[22,4] = -8.1400
[23,4] = 2.5300
[24,4] = 7.4100
[25,4] = 6.9000
[26,4] = 8.6000
[27,4] = 4.9500
[28,4] = -2.8300
[29,4] = 2.9100
[30,4] = -1.8900
[31,4] = 5.7700
[32,4] = -2.7300
[33,4] = -3.7400
[34,4] = -1.9400
[35,4] = 0.99000
[36,4] = -1.9600
[37,4] = 6
[38,4] = 8.4900
[39,4] = 5.2200
[40,4] = -4.9600
[41,4] = -6.0900
[42,4] = 10.190
[43,4] = -3.3600
[44,4] = -3.4800
[45,4] = 0
[46,4] = 5.4100
[47,4] = -17.090
[48,4] = -5.1500
[49,4] = 4.3500
}
>>> a = r.Value; // Data from excel correctly returned, but still can't
>>> assign to variable
>>>error: can't perform indexing operations for octave_com_object type
--
View this message in context:
http://octave.1599824.n4.nabble.com/Windows-Package-tp2296173p2299017.html
Sent from the Octave - General mailing list archive at Nabble.com.
- Re: Windows Package, (continued)
- Re: Windows Package, Martin Helm, 2010/07/21
- Re: Windows Package, Martin Helm, 2010/07/21
- Re: Windows Package, John Hudock, 2010/07/21
- RE: Windows Package, Mike G, 2010/07/21
- Re: Windows Package, Martin Helm, 2010/07/21
- Re: Windows Package, John W. Eaton, 2010/07/21
- Re: Windows Package, Martin Helm, 2010/07/21
- Re: Windows Package, John Hudock, 2010/07/21
- Re: Windows Package, Martin Helm, 2010/07/21
- Re: Windows Package, John Hudock, 2010/07/22
- Re: Windows Package,
John Hudock <=
- Re: Windows Package, Martin Helm, 2010/07/22
- Re: Windows Package, John Hudock, 2010/07/23