Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Drawing box for each cells
Message
From
18/09/2002 04:24:37
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00701638
Message ID:
00701655
Views:
22
>How ?
>
>would you like to send to here a sample ?
#DEFINE xlInsideHorizontal	12	
#DEFINE xlInsideVertical	11	
#DEFINE xlDiagonalDown	5	
#DEFINE xlDiagonalUp	6	
#DEFINE xlEdgeBottom	9	
#DEFINE xlEdgeLeft	7	
#DEFINE xlEdgeRight	10	
#DEFINE xlEdgeTop	8	

#DEFINE xlContinuous	1	
#DEFINE xlDash	-4115	
#DEFINE xlDashDot	4	
#DEFINE xlDashDotDot	5	
#DEFINE xlDot	-4118	
#DEFINE xlDouble	-4119	
#DEFINE xlSlantDashDot	13	
#DEFINE xlLineStyleNone	-4142	

lcExcelFile = SYS(5)+CURDIR()+'excelborder.xls'
SELECT * from orders INTO CURSOR dummy
COPY TO (lcExcelFile) TYPE xl5

LOCAL loExcel
loExcel = CreateObject("Excel.Application")
with loExcel
 .Workbooks.Open(lcExcelFile)
 .ActiveWorkbook.ActiveSheet.UsedRange.Borders.Linestyle = xlDouble
 .Visible = .T.
ENDWITH
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