Autoit and Excel Copy and Paste

[jerimy]

Hi all, I have an excel program in which there is a pivot table in which the J column will exclude what is in the pivot table. I need to write a script(with a hotkey)1. Open the minimize excel sheet I have open. 2. Take the first symbol in the pivot table which is P7 and put it into the J column. The problem is that I always have symbols in the J colum and I need the script to copy the symbol and always paste it the next row. For instance if I have info from J1 to J20 I need the script to copy and paste the info in J21, then when I hit the Hotkey again I need it to put the next symbol in J22. Anyone have any ideas of how to do this? Thanx for the help!!!

[PsaltyDS]

Hi all, I have an excel program in which there is a pivot table in which the J column will exclude what is in the pivot table. I need to write a script(with a hotkey)1. Open the minimize excel sheet I have open. 2. Take the first symbol in the pivot table which is P7 and put it into the J column. The problem is that I always have symbols in the J colum and I need the script to copy the symbol and always paste it the next row. For instance if I have info from J1 to J20 I need the script to copy and paste the info in J21, then when I hit the Hotkey again I need it to put the next symbol in J22. Anyone have any ideas of how to do this? Thanx for the help!!!

Read the sheet into an array with $avArray = _ExcelReadSheetToArray($oExcel) and you get:

$avArray[0][0] = last row number

$avArray[0][1] = last col number

[jerimy]

Read the sheet into an array with $avArray = _ExcelReadSheetToArray($oExcel) and you get:

$avArray[0][0] = last row number

$avArray[0][1] = last col number

thanx for the reply but fairly new in writing scripts in autoit. Will this copy and paste for me? Sorry I dont know how to write this

[PsaltyDS]

thanx for the reply but fairly new in writing scripts in autoit. Will this copy and paste for me? Sorry I dont know how to write this

No, that gives you the number of rows and columns used, which you seemed to be trying to figure out. The actual copying is trivial. Look at the other _Excel* functions in the help file.

[nfaustin]

Have a look at this UDF.

http://www.autoitscript.com/forum/index.php?showtopic=34302&hl=_ExcelCOM_UDF&st=0

It has copy and paste function.

_ExcelCopy($oExcel, 1, 1 , 1, 1)
_ExcelPaste($oExcel, 1,1)

Use PsaltyDS's code posted above to get the row and column for the copy & paste parameter.

[PsaltyDS]

Have a look at this UDF.

http://www.autoitscript.com/forum/index.php?showtopic=34302&hl=_ExcelCOM_UDF&st=0

It has copy and paste function.

_ExcelCopy($oExcel, 1, 1 , 1, 1)
_ExcelPaste($oExcel, 1,1)

Use PsaltyDS's code posted above to get the row and column for the copy & paste parameter.

Most of Locodarwin's UDF is now part of the AutoIt's standard set of includes as Excel.au3 -- see the _Excel* functions in the current help file.

[nfaustin]

Yes, but _ExcelCopy(), _ExcelPaste() and the others are not yet included in the Excel.au3 in current help file v3.3.1.1 (beta).

Edited September 25, 2009 by nfaustin

[Hawkwing]

Yes, but _ExcelReadCell and _ExcelWriteCell are in there, which would serve his purposes just fine, without using the clipboard.

[Dfields]

I have the same "type" of problem, only it has a bit of a twist to it. And it is driving me insane!

1. I have one column in an Excel workbook called "Index" that has a list of text, this column has 2000 rows each with a unique entry.

2. I have worksheets, 2000 of them, and each tab is named to match each cell in the in the Index worksheet all in the same workbook.

3. I need to copy the first cell

4. Paste that text into a different program in a search window.

5. Press enter

6. Select the results

7. Press ctrl + a to copy everything in the results window

8. Take the results back to Excel to the matching worksheet and paste it in column A, row 1

9. Loop through this until it has gone to each cell in the Index work sheet.

I know for you guys who do this all the time it is probably a simple script to code out, but for me I do not have the skill set to accomplish this with. If I do this manually, which I have been doing, it is going to take a VERY long time. Any help that could be given would be highly appreciated. Thanks everyone.

[water]

Please open a new thread. You necro a nearly 5 years old thread