Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cells and Ranges in Excel
Message
From
25/10/2002 04:49:26
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
24/10/2002 22:40:12
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00715250
Message ID:
00715310
Views:
14
>OK, figured it out, I can just use loExcel.Range(loExcel.Cells(n,n), loExcel.Cells(n,n)) instead of loExcel.Range('An:An')

:) One day this might come handy :
* Return A, AA, BC etc noation for nth column
FUNCTION _GetChar
  LPARAMETERS tnColumn && Convert tnvalue to Excel alpha notation
  IF tnColumn = 0
    RETURN ""
  ENDIF
  IF tnColumn <= 26
    RETURN chr(asc("A")-1+tnColumn)
  ELSE
    RETURN _GetChar(int(iif(tnColumn % 26 = 0, ;
           tnColumn - 1, tnColumn) / 26)) + ;
           _GetChar((tnColumn-1)%26+1)
  ENDIF
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform