From excel to Omnigraffle

Scripting Forums AppleScript | Mac OS X
#1

Hello Scripters!
I am fairly new to all of this, I am currently taking an introductory course in a range of languages (python, maple, bash, matlab, java is next), and sorta know my way around the terminal but the furthest I have gone with Applescript is implementing someone else’s script for a word-counter.

Every month I do a ranking of the top 100 hockey players (for a specific type of fantasy hockey) for a top fantasy hockey site. I do all the computing and list generating in Excel, then I put it all into Omnigraffle. There is a hell of a lot of cutting and pasting involved, and I am wondering if its something I can make easier via automator/applescript.

Here is the first list I made… Scroll past the writing.

I have it all laid out in that order on an Excel sheet, but I have to copy/paste between 900-1000 different values, re-order them all, and then colour code them!

The most work is the copy-paste, so basically I would just need it to copy from first excel cell, into the first Graffle cell, then repeat. You can hit tab to get to the next cell in the Graffle document.

And yes, I have exhaustively searched for how to do this natively in Omnigraffle… I even downloaded Visio 2013 to try and use it as a middleman.

Thanks for any advice! The quicker the better, if possible, as I need to get it done this weekend.
Thanks,
Austin Wallace

Model: Mac
Operating System: Mac OS X (10.8)

#2

Hello and welcome to Macscripters.

I can’t find a link to anything in your post.

I’d also like to see a link of an image of a finished Omnigraffle document, in addition to the excel file which you extract the data from. :slight_smile:

#3

Oops! My bad. http://hockey.dobbersports.com/dobberpics/913Top100Rotov2.pdf
I will post the excel link, but it is just a table of values. I am not currently at that computer.

#4

Hello.

It looks great so far, I doubt I can help you through this weekend, but maybe we can have fixed something until next?

I have a copy of Omnigraffle and Excel, so I think I should be able to patch something together that will work for you, should you be interested.

#5

Thanks! That would be awesome. I sent you an email on Saturday.

#6

Hello.

I wonder why you didn’t reply here, I’ll check my mailbox and come back to you, by tomorrow.

#7

Hello.

I have replied to your mail. Just bring it on. :slight_smile:

#8

:smiley:
Thanks a ton! It’s great meeting someone on here who uses both problems, I appreciate this a ton. I’ll send you the files this afternoon.

#9

Hello.

I’m sure we can work something out, if you want to get hold of me between mails, then just send me a private message here. :slight_smile:

#10

Hello.

I can’t find anything in my mailbox yet.

#11

Just wanted to give a huge thank you to McUsrII!
He has fully automated the transfer of data from Excel to Omni. saving me 900 copy-and-pastes a month!
Everything works perfectly, and for a fairly complicated script he did it quite quickly.

#12

Hello.

Thank you very much. The CustomMergeSort of Nigel Garvey saved the day for me! :slight_smile: