Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Spreading a cursor across and down a sheet
I need to create one sheet with two 'tables' on them. The data for the table is coming from only one cursor. I use the COPY TO ... TYPE XL5 from within FoxPro. I specify all required fields and Excel shows the each record in one row.
However I need to break up the rows, and repeat the first column from the first 'table' in the second 'table'
A coworker suggested a copy/cut-paste in the worksheet, this might work, I haven't tried it yet. I have a feeling that I should be able to spread the contents over ranges of cells, but I don't know how.
Can anyone give me any pointers?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement