Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can i set excel cell to text format?
Message
From
27/06/2011 06:26:18
 
 
To
All
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
How can i set excel cell to text format?
Environment versions
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01516198
Message ID:
01516198
Views:
83
Hi, all
I use vb.net and write a export excel function. In first , i want to set the cell from A to F will be text format.
But i don't know my below code can not , how can i do. Anyone can give some idea to me. Thank you~~~
 Dim Sheet As Excel.Worksheet
Sheet.Columns("A:F").Select()                   
 Sheet.Selection.NumberFormatLocal = "@"                        'In this will display error, worksheet  no public member selection
Next
Reply
Map
View

Click here to load this message in the networking platform