开发者

Copying and pasting between two separate programs using Automator in Mac OS X

开发者 https://www.devze.com 2022-12-21 04:52 出处:网络
Ok, so I have an excel spreadsheet that contains data that I would like to copy directly into an SQLite db using Menial Base, a db editor. I have tried a number of different methods such as trying to

Ok, so I have an excel spreadsheet that contains data that I would like to copy directly into an SQLite db using Menial Base, a db editor. I have tried a number of different methods such as trying to convert from .csv and .txt extensions, and nothing is working the way I need it to, so I am now resorting to Automator. From what I understand, Automator is a very powerful application, I just don't have any clue how to get it to do what I need it to, or if it's even capable of doing what I need it to. All I need it to do is copy a cell from excel, command-tab over to Base, and paste it into a cell, go back to Excel, press down and copy the next value, and then go back over into Base, press down, and paste. Then repeat and repeat and repeat a thousand times. Its not overly complicated, but I was wondering if anyone out there knows if this sort of thing is possible in automator. Would I maybe need to write my own AppleScri开发者_如何学运维pt or something? Any thoughts or insights would be greatly appreciated! Thanks


I don't know exactly how you might go about doing the copy and paste function, but it looks as though using an AppleScript is going to be your best bet. See here, Hope that helps

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号