Consider asc(ord('A')+mycolno), or some minor tweak of that.
Jeremy
From: advanced_delphi@yahoogroups.com
[mailto:advanced_del...@yahoogroups.com] On Behalf Of Alberto Narduzzi
Sent: Wednesday, February 25, 2009 7:58 AM
To: advanced_delphi@yahoogroups.com
Subject: Re: [advanced_delphi] TExcelApplication and columns in a Sheet
neomavez,
> Analyzing an excel spreadsheet, I have to display a message like this:
> "Column 2 contains no numbers"
> But instead of 2 should say "B", so that 29 = "C", and so on...
I thought that 2 (0=A, ...) or at least 3 (1=A ...) should be "C".
Then (I never used Excell sheets, so here I talk as newbie), cannot you
just go on top of the sheet and look there for the column names
(provided you gave them names, otherwise they always begin with "A")?
Or define a sort of template to give a name to every column number.
Just my 2c
Cheers, A.
