Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Long fields with excel
Message
 
À
25/08/2005 15:47:36
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01044055
Message ID:
01044067
Vues:
13
You need to set cell format in excel. Here is the example:
CREATE CURSOR irepo (fld1 n(15),fld2 n(15))
FOR ia=1 TO 1000
      ln=123456789012345 +RECNO()
     INSERT INTO irepo VALUES (ln,ln)
ENDFOR
COPY TO c:\yy xls

oExcel = CREATEOBJECT("Excel.Application")
WITH oExcel
	.DisplayAlerts = .f.
	.visible=.t.
	.Workbooks.Open("c:\yy.xls")
	.activesheet.Columns("B:B").select
	.Selection.NumberFormat = "0"
    	.Selection.Columns.AutoFit
ENDWITH

oexcel=null
>hi
>
>i've a problem i send mi table to excel but i try send value so many long into cells-excel put datas same this 4,56815E+15
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform