How can I use automator to copy and paste excel content to a new empty document?

Question

Level 1

3 points

How can I use automator to copy and paste excel content to a new empty document?

Hi,

I would like to copy and paste the content from an excel file to another empty new document using automator, which I created a workflow like below

get specific finder item

open excel workbook

select cell from excel workbook (all content)

obtain selected content from workbook

copy to pasteboard the content of excel workbook

close the excel workbook

create new excel workbook

paste copyboard content to excel workbook

can anyone kindly suggest what's wrong with this workflow?

Thank you so much

Eddy

(i know this is a number place but I couldn't find any excel seciton sorry guys...)

MacBook (13-inch Early 2008), Mac OS X (10.6.8)

Posted on Oct 7, 2013 5:58 PM

Reply

Answer 1

SGIII

Level 8

37,744 points

Oct 7, 2013 7:05 PM in response to Eddy T

Maybe try the Mac OS X Technologies section? There are discussions about Automator workflows there, some involving Excel.

Reply

Answer 2

Mar 16, 2014 3:04 AM in response to Eddy T

I don't see any problem with your workflow. I have a similar automator script that does pretty much the same thing, but for me what happens is that it pastes the data as a picture. I created the workflow as a service (not a workflow) and it seems to solve the problem, but now it only does one file at a time, whereas I would like to do multiple files simultaneously.

Reply

Answer 3

SGIII

Level 8

37,744 points

Mar 16, 2014 8:17 AM in response to Will McNeice

now it only does one file at a time, whereas I would like to do multiple files simultaneously.

If you try a search for "loop Automator" and also "folder actions" you may find some usable pointers on how to do that. The first example on this page looks promising.

SG

Reply

Answer 4

Mar 16, 2014 9:27 AM in response to SGIII

Thanks SGill, that has done the job!

Reply