Re^3: WIn32::OLE debug

[choroba]

Method calls are not interpolated in double quoted strings. Therefore,

print "table rows count= $table->Rows->Count \n";

only interpolates $table. Instead, try

print 'table rows count = ', $table->Rows->Count, ".\n";

[chafelix]

Then

 
print "table rows count=",  $table->Rows->Count ,".\n"; # prints 23
foreach my $rownum (1 .. $table->Rows->Count) {
print "rownum=$rownum\n"; #prints 1
    my $row = $table->Rows->Item($rownum); #crashes!

OLE exception from "Microsoft Word": ?e? e??a? d??at? ? p??s▀as? ╡e╡???╡???? ??a╡╡?? se a?t?? t? s??????, epe?d? ? p??a?a? ??e? s?????e?╡??a ?e??? ?ata????fa. Win32::OLE(0.1712) error 0x800a1767 in METHOD/PROPERTYGET "Item" at parserworks16.pl line 191.

is there a way to look at the elements of the $table->Rows object? It would appear that this does not have an Item(1) element

[soonix]

PMFJI, but shouldn't

my $row = $table->Rows->Item($rownum); #crashes!

be more something like

my $row = $table->Rows($rownum)->Item; # probably also crashes, but di
+fferently ;-)

?

[chafelix]

Nope, same error

numrows=23

table rows count=23.

rownum=1 OLE exception from "Microsoft Word":

?e? e??a? d??at? ? p??s▀as? ╡e╡???╡???? ??a╡╡?? se a?t?? t? s??????, epe?d? ? p??a?a? ??e? s?????e?╡??a ?e??? ?ata????fa.

Win32::OLE(0.1712) error 0x800a1767 in METHOD/PROPERTYGET "Rows" at parserworks16.pl line 191.

[Anonymous Monk]

reference the docs? msdn…?? How to print row of excel file in perl uses a Cells method, can you make that work?