Applescript for getting data from a spreadsheet
bobs at twft.com
Fri Dec 9 10:49:26 CST 2011
This may be a little off topic, but the goal is to create an app that looks up mac addresses from a telnet session into a series of procurve switches, and then compare that with a known list of mac addresses in an excel spreadsheet, and trace them through a network to find where the device is at. I do this regularly by hand, but I want to make a stack that can do it.
I read through the dictionary of Microsoft Excel to try to find a way to get the data from a range of cells, but as usual, nothing works in Applescript like you would expect, and of course the dictionary provides no examples of how the command should be written. All the help forums are useless because the advice people give there is usually either outdated, or simply wrong on it's face.
So does anyone have any experience using Applescript to select a range of cells in a certain sheet of a certain workbook? If I could get that far, I think I could just copy/paste the data into a datagrid and go from there. BTW I am using Office 2008 (for Mac of course). This is important because apparently they rewrote the dictionary between 2004 and 2008 and a lot of things that used to work in 2004 do not anymore.
More information about the use-livecode