Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Long fields with excel
Message
 
À
26/08/2005 09:21:39
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:
01044274
Vues:
13
Then force it to be a character expression in Excel:

oExcel.cells(lnCells,18)=[']+ALLTRIM(NUMCTA)



>i'cant use copy to c:\yy type xls look my program
>
>the problem is numcta field , that data is a account number of bank.
>
>oExcel.cells(lnCells,10)=ALLTRIM(sexo)
> oExcel.cells(lnCells,12)=ALLTRIM(dircorres)
> oExcel.cells(lnCells,13)=ALLTRIM(ciudadcorr)
> oExcel.cells(lnCells,14)=telcorresp
> oExcel.cells(lnCells,17)=ALLTRIM(formapago)
> oExcel.cells(lnCells,18)=' '+ALLTRIM(NUMCTA)
> oExcel.cells(lnCells,20)=ALLTRIM(banco)
> DO case
> CASE ctacorrien=.T.
> oExcel.cells(lnCells,21)='PLSANCHK'
> CASE ctaahorros=.t.
> oExcel.cells(lnCells,21)='PLSANSAV'
> CASE TARJCREDIT=.t.
> oExcel.cells(lnCells,21)='TARJCREDIT'
> CASE UPPER(SUBSTR(clasetarje,1,1))='V'
> oExcel.cells(lnCells,22)='PV'
> CASE UPPER(SUBSTR(clasetarje,1,1))='M'
> oExcel.cells(lnCells,22)='PM'
> ENDCASE
> oExcel.cells(lnCells,24)=ALLTRIM(dptocorres)
> oExcel.cells(lnCells,25)=ALLTRIM(tmstart)
> oExcel.cells(lnCells,26)=ALLTRIM(operador)
> SKIP
> ENDDO
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform