Thread Exceldatei bearbeiten? (12 answers)
Opened by zieglerch at 2006-06-21 23:11

bo
 2006-06-22 12:24
#67549 #67549
User since
2006-05-09
76 Artikel
BenutzerIn
[default_avatar]
die letzte zeile und spalte bekommst du so:

Code: (dl )
1
2
3
my $last_row = $sheet->UsedRange->Find( { What => "*", SearchDirection => xlPrevious, SearchOrder => xlByRows } )->{Row};

my $last_col = $sheet->UsedRange->Find( { What => "*", SearchDirection => xlPrevious, SearchOrder => xlByRows } )->{Column};

View full thread Exceldatei bearbeiten?