Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export Cursor data to Excel
Message
De
04/03/2004 14:23:01
 
 
À
04/03/2004 14:17:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00883201
Message ID:
00883203
Vues:
11
>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

I think it's just a display issue in Excel. If you look the cells the dates are filled in and if you delete the "overflow" values in Excel and pagedown then up again, to refresh the screen, you will see the dates are display correctly.
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform