Re^2: I prefer my indexes to start at:

Since sheet row 2 is usually the first row of data in a spreadsheet, thinking of the header as data row(0) makes sense as it's followed by the first data row of data(1).

my $name = "Eric Beavers\n"; my $email = "elb"; my $website = "carryingstones.com\n"; print $name, $email, '@', $website;

Comment on Re^2: I prefer my indexes to start at:

Replies are listed 'Best First'.
Re^3: I prefer my indexes to start at: by Tux (Canon) on Sep 19, 2022 at 08:13 UTC
Assumption is the mother of all FU's The danger in your remark is the word usually. Been there done that. And even if the data you are dealing with initially had a header row, there is no guarantee that the next time you get that data from external sources will have (the same) header line or that they either left it out, changed the order, spelling, casting or even inserted line(s) before the header to add "comments" or "instructions". Excel is likely one of the most misused/abused end-user tools in the (ICT) world. I never assumer anything in Excel, not even correct encoding or default (date) formatting. Enjoy, Have FUN! H.Merijn	[reply]

Replies are listed 'Best First'.

Re^3: I prefer my indexes to start at:
by Tux (Canon) on Sep 19, 2022 at 08:13 UTC

Assumption is the mother of all FU's

The danger in your remark is the word usually. Been there done that. And even if the data you are dealing with initially had a header row, there is no guarantee that the next time you get that data from external sources will have (the same) header line or that they either left it out, changed the order, spelling, casting or even inserted line(s) before the header to add "comments" or "instructions". Excel is likely one of the most misused/abused end-user tools in the (ICT) world. I *never* assumer anything in Excel, not even correct encoding or default (date) formatting.

Enjoy, Have FUN! H.Merijn

[reply]