ranges in Excel
ranges in Excel
- Subject: ranges in Excel
- From: Jean-Christophe Helary via AppleScript-Users <email@hidden>
- Date: Tue, 7 Jan 2020 22:58:19 +0900
Excel ranges are defined with column letters and row numbers.
But when I check my Excel sheet in AppleScript I only have column numbers and
row numbers.
Is there a trivial way to create a range of column 1 to column 2 so that it
translates to range "A:B" ?
Also, that seems to be a bug in Excel, but when Excel opens an ODS file
(LibreOffice format, supported in Excel), the "used range" is totally weird
(the range goes all the way to the physical column limit, even though only a
few columns are used, hence my questions above, that comes after a check of
which columns are really filled with data), but the same data, in an xlsx sheet
produces exactly what is expected.
Jean-Christophe Helary
-----------------------------------------------
http://mac4translators.blogspot.com @brandelune
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden