Applescript lee datos específicos de iWork Numbers

Question

Applescript lee datos específicos de iWork Numbers

#1 de Marci-man (1 votos)

0

Estoy tratando de sacar datos de una tabla en Números. Tengo un número de índice, necesito obtener el nombre asociado a él en applecript. (Eventualmente, necesito establecer nombres de archivos con una de las columnas de esta hoja de números)

aquí es lo que tengo:

tell application "iTunes"
    repeat with theTrack in selection
        set theFile to location of theTrack
        tell application "Finder" to set theName to name of theFile
        set surahNameAsString to characters 1 thru 3 of theName as text
        --set album of theTrack to surahName
        set surahNumber to surahNameAsString as integer
        log ("here")

        set aName to my getAName(surahNumber)

        --set the year of theTrack to 1985

    end repeat
end tell

on getAName(surahNumber)
    tell application "Numbers"
        activate
        set t to front document's active sheet's first table's cell whose value is surahNumber
        --set t to front document's active sheet's first table's first column
        repeat with c in t
            set theValue to c's value
        end repeat
    end tell
    return theValue
end getAName

applescript automator numbers

pregunta Marci-man 01.01.2015 - 04:08

1 respuesta

Lea otras preguntas en las etiquetas applescript automator numbers

fish shell sugiere comandos en tmux ¿El conector MagSafe 2 T se calienta mucho al cargar?

score 1 · Answer 1

Así es como lo resolví:

tell application "iTunes"

    repeat with theTrack in selection

        set theFile to location of theTrack
        tell application "Finder" to set theName to name of theFile

        set ayahInSurahCount to 0

        --set ayah information from the name of the track

        set surahNumAsString to characters 1 thru 3 of theName as text
        set surahNumber to surahNumAsString as integer

        set ayahNumberAsString to characters 4 thru 6 of theName as text
        set ayahNumber to ayahNumberAsString as integer
        -- finished

        set track number of theTrack to ayahNumber
        set genre of theTrack to "Genre"
        --getting information from the number sheet
        set aName to my getAName(surahNumber)
        --set englishName to my getEnglishName(surahNumber)
        -- finished
        set the album of theTrack to surahNumAsString & "-" & aName
        set artist of theTrack to "Abdul Basit"
        set shufflable of theTrack to false
        --set description of theTrack to englishName
        set name of theTrack to ayahNumberAsString & " - "

    end repeat
end tell

on getAName(surahNumber)
    tell application "Numbers"
        activate
        tell document 1
            tell sheet 1
                tell table 1
                    set ret to value of cell 1 of row surahNumber
                    --set value of cell 5 of row 1 to "Salam"
                end tell
            end tell
        end tell
    end tell
    return ret
end getArabicName

on getEnglishName(surahNumber)
    tell application "Numbers"
        activate
        tell document 1
            tell sheet 1
                tell table 1
                    set ret to value of cell 3 of row surahNumber
                end tell
            end tell
        end tell
    end tell
    return ret
end getEnglishName