Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can i set excel cell to text format?
Message
De
27/06/2011 06:26:18
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Titre:
How can i set excel cell to text format?
Versions des environnements
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01516198
Message ID:
01516198
Vues:
84
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform