Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export Cursor data to Excel
Message
 
À
04/03/2004 14:17:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00883201
Message ID:
00883213
Vues:
9
Does "copy to TYPE xls" overflow also?

>Hi,
>
>Yesterday I almost lost the remaining hairs in my almost bald head :(
>
>Below is a simple sequence that reproduces the behavior I was experimenting.
>
>My program generated a cursor (with many columns) and there was some columns with dates and other with numeric calculated values. After filling the cursor with many rows it was exported to Excel.
>
>Due to a logic error my program was generating numeric overflow when storing some numeric values into cursor numeric columns. Till this point it's all ok, BUT, when I looked at the resulting Excel spreadsheet the result was not only overflow in those numeric columns, but ALSO in some date columns. Want to check it? Just run the prg below.
>
>Create Cursor Test (Field1 D, Field2 N (1), Field3 D)
>
>dDate = Date ()
>
>For I = 1 To 20
>    Insert Into Test (Field1, Field2, Field3) ;
>              Values (dDate , I     , dDate )
>EndFor
>
>Select Test
>Browse
>Export To C:\Temp\Test.xls Type XL5
>
>Is that a bug in Excel, VFP or what? Note that in the browse window all dates are ok.
>
>Fernando
Imagination is more important than knowledge
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform