Need AppleScript to export Numbers spreadsheet

Thanks for that. TextMate is just a code editor. I can execute the Perl script directly from the command-line in Terminal, or from the editor window using a macro.

I could easily change it to parse Tab instead of Comma delimited plain text, but that's not the problem. The problem is having to split my workflow into two parts: exporting (whether by using the built-in Export To CSV, or by copy+pasting into a plain-text file), and then executing the rest.

It's not a big deal really, I was just curious to know if there was any way to access the export function of Numbers programmatically (scriptically?) using AppleScript.

-dZ.

Thanks, but if I have to copy+paste the spreadsheet, I have many other ways to do it. I was looking for a "one-click" solution that would do it for me. I guess there is none.

Thanks for the help! 🙂

-dZ.

Fantastic, Jacques!!!

However, I get one error. It's strange, though, because the CSV file is created correctly and all, but the script ends with "{path to filename without extension} wasn't found."

At that point it stops the workflow, even though it generated the CSV file.

Here are my new Automator workflow actions:

1. As for Confirmation

2. Run AppleScript (provided by you)

     on run
          tell application "Numbers" to tell front document
               set tPath to (POSIX file (get path)) as string
               tell tPath to if it ends with ".numbers" then set tPath to text 1 thru -9 -- remove extension
               save as "LSDocumentTypeCSV" in file tPath -- Numbers automatically adds the ".csv"
          end tell
          return tPath as alias -- return the path of the CSV file to the next action
     end run

3. Run Shell Script:

     cd "{root path of script}"
     build_leaderboard.pl > out.log

4. Get Specified Finder Items

5. Upload to FTP

It breaks at the end of step #2.

Thanks much!

-dZ.

Message was edited by: DZ-Jay

Oh, I think I see the problem. The variable tPath contains the path without the extension, and even if Numbers automatically adds it, the variable is not updated. So the "return tPath as alias" statement fails because the file without extension does not exist.

Should I just concatenate the extension to the tPath variable before returning?

-dZ.

By the way, I fixed the problem by concatenating the extension to "tPath" before returning. Now my workflow is fully automatic! 🙂

Thanks a million!

-dZ.