Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Different Excel cells width in same column
Message
From
10/06/2011 05:08:49
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Different Excel cells width in same column
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01513983
Message ID:
01513983
Views:
108
Hi,
Can I set the different cell width in SAME column ?
oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).ColumnWidth = 15
oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).value = rpt012->itmcode
				
oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).ColumnWidth = 40			
oExcel.activesheet.Range("D"+TRIM(PADR(nrow,11))).value = rpt012->desc
I found it the result have same column width 40.

Please advise.
Thanks.
Derek Yim
Next
Reply
Map
View

Click here to load this message in the networking platform