Automator pour obtenir des annotations PDF et les exporter vers Excel

En supposant que vous connaissez les bases d'Automator....Créer un flux de travail avec ces actions :

Dans l'action AppleScript, copiez et collez ce qui suit :

    on run {input, parameters}
    set delimitedList to paragraphs of (input as string)
    set myExport to ""
    do shell script "touch /tmp/myFile.csv"
    repeat with myLines in delimitedList
        set myLineExport to ""
        set AppleScript's text item delimiters to {"    "}
        set listItems to every text item of myLines
        repeat with eachItem in listItems
            set myLineExport to myLineExport & "\"" & eachItem & "\","
        end repeat
        set myExport to myExport & myLineExport & "
"
    end repeat
    write_to_file(myExport, (POSIX file "/tmp/myFile.csv" as alias), false)
    return POSIX file "/tmp/myFile.csv" as alias
end run

on write_to_file(this_data, target_file, append_data)
    try
        set the target_file to the target_file as string
        set the open_target_file to open for access file target_file with write permission
        if append_data is false then set eof of the open_target_file to 0
        write this_data to the open_target_file starting at eof
        close access the open_target_file
        return true
    on error
        try
            close access file target_file
        end try
        return false
    end try
end write_to_file

Note : Vous pouvez rencontrer des problèmes si vos annotations contiennent des citations, cependant il n'y aura aucun problème si vous utilisez des citations intelligentes.

Vous pouvez sélectionner votre pdf dans la première invite.

Sources : https://www.macosxautomation.com/applescript/sbrt/sbrt-09.html