0 votos

Applescript lee datos específicos de iWork Numbers

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

esto 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

1voto

David M Williams Puntos 195

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

AppleAyuda.com

AppleAyuda es una comunidad de usuarios de los productos de Apple en la que puedes resolver tus problemas y dudas.
Puedes consultar las preguntas de otros usuarios, hacer tus propias preguntas o resolver las de los demás.

Powered by:

X