Information générale
Catégorie:
COM/DCOM et OLE Automation
Excel recognises delimiters for cell columns and for a new line,
so:
_CLIPTEXT = "One" + CHR(9) + "1" + CHR(13) + "Two" + CHR(9) + "2"
oXL.Range("B2").Select
oXL.ActiveSheet.Paste
Would put "One","1","Two","2" in B2,C2,B3,C3 respectively.
Ian.
>I'm can't recall the specifics, but I recall a discussion that copying the data to the clipboard using _cliptext and paste while in Excel.
>
>PF
>
>>I have been working on updating an Excel spreadsheet with data from VFP 6. I can do all of the basic processes, but the way I am updating is very slow. I am currently using oleapp.range("A1").value=somevalue then oleapp.range("A2").value=anothervalue and so on. Some of these processes involve a large amount of data. Is there a way to select a range of cells and update them all from an array or other source that would improve the performance?
>>
>>Thanks in advance for any suggestions.
Précédent
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