Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP6 and Excel
Message
De
07/02/2004 10:02:29
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
00806542
Message ID:
00875141
Vues:
43
>Hilmar
>
>I regard you as the VFP /Excel expert...

This, I am definitely not. But I will see if I can help.

> ... - here's one for you
>
>My axis currently reads
>Jan 03
>Feb 03
>etc to
>Dec 03
>
>I want it to read
>Jan 04
>Feb 03
>etc to
>Dec 03
>
>How do I do it

Several ideas come to mind. In Excel, you could:
  • Edit each field (F2, if you do it manually in Excel), erasing the last character ("3") and replacing it with "4".
  • Use search and replace.
  • Insert each value manually (typing the entire value).

    The last option seems to me the simplest to implement with Automation:
    with .oSheet
      .Cells(1,1).Value = "Jan 04"
      .Cells(1,2).Value = "Feb 04"
      ...
    endwith
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Précédent
    Suivant
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform