Microsoft Office

[AppleScript]区切り文字が複数あるtxtファイルをExcelで開く


AppleScriptでデキストデータをExcel | OKWave

に答えてみた


tell application "Finder"
set theAliasFileResult to choose file "ファイルを選択"
set theFileResultText to theAliasFileResult as text
end tell


tell application "Microsoft Excel"
(open text file filename theFileResultText data type delimited other char "|" with use other and space)
end tell

「delimited_other_char.rtf」をダウンロード

「delimited_other_char.scpt.zip」をダウンロード


こんな感じではどうでしょう

Microsoft ExcelのAppleScriptのリファレンスは以下のURLにPDFがあります。
http://download.microsoft.com/download/3/A/7/3A70FB4B-0C6A-43E3-AAB7-AC9166B25632/Excel2004AppleScriptRef.pdf

日本語のドキュメントはチョット古いですが、以下のURLのPDFが参考になります。
http://download.microsoft.com/download/6/C/A/6CA6174A-FF8E-4B24-AD50-45B4AEC988D3/excel.pdf

|

Office For Mac

Image00230127_92148


Office for Mac : Simplify Your Work | Office For MacOffice for Mac : Simplify Your Work | Office For Mac:新しいウィンドで開きます

| | コメント (0) | トラックバック (0)

その他のカテゴリー

Accessibility | AccessibilityCheck | AccessibilityForm | AccessibilityInDesign | AccessibilityPDF | Acrobat | Acrobat Action | Acrobat Annotation | Acrobat AppleScript | Acrobat Custom Menu | Acrobat Layer | Acrobat Plug-ins | Acrobat Portfolios | Acrobat Print | AcrobatBarcode | AcrobatDialog | AcrobatForm | AcrobatJS | AcrobatMenu | AcrobatPDF | AcrobatStamp | AcrobatX | AcrobatYouTube | AddressBook | Adobe | Adobe InDesign | AdobeAppleScript | AdobeBridge | AdobeIllustrator | AdobeJSX | aed | Alfresco | Android | AnimationGif | App iOS | App Store | Apple | AppleScript | AppleScriptBasics | AppleScriptErrorNum | AppleScriptRename | AppleScriptTools | AppleSymbols | Applications | Barcode | Barcode2D | BarcodePostal | BetterHTMLExport | Book | Browser | buzz | CAD | CharacterEntity | CharacterSets | Chrome | Cold Case | Color | Colors | Cool Site | CriminalMind | CSS | Cutting | DecoMail | DecorationMail | Design | Desktop | Diff | Diy | DJ | dmg | DNS | Documents | Download | DTP | eBook | Editer | eMail | Envelopes | ePUB | ExifTool | Facebook | FFmpeg | File System | Fonts | FontsTool | FontsWeb | FOOD | FormPrint | ftp | Gadget | Geo | Gif Animation | glee | Google | Graphic | HexEditor | HTML | HTML5 | IE | iGoogle | info | iPhoto | ISBN | ISO | iTunes | iWork | iWorkNumbers | iWorkNumbersCalendar | iWorkNumbersTimecard | iWorkPages | JavaScript | JeditX | JeditX Regexp | JeditXAppleScript | JIS | jquery | Kanji | Kids | Kitchen | Letterpress Printing | Letterpress Site | Letterpress Typography | Library | logo | Mac Admin | Mac Archiver | Mac Browser | Mac Browser Plugin | Mac DEV | Mac QuickLook | Mac Spotlight | Mac Video | MacServer | Map | Microsoft Office | Mobby | Moto | Movies | Music | Network Basic | ntp | OCR | OCR Font | Office | OfficePowerPoint | OSX | Pantone | Paper | pdf | PDFlib | Permission | Phone | Photo | Pictograms | Pictures | Press | Print | Printer | Printing Home | Printing Tools | Public | QuickLook | QuickTime | QuickTimeSetting | QuickTimeSound | Real Media | ReName | ResourceFork | ruby | Sample | Screen | ScreenCast | Search | Security | SEO | Server | Sharing | Sign | SLAResource | Sound | Souvenir | Spotlight | Stamp | SWF | Tutorial PSD | TV | Twitter | Typeface Design | Typography | Typography Goods | Typography Letterpress | Unicode | Utilities | Video | Web Font | WebClip | WebFont | Wedding | Windows | WindowsMedia | Writing | XML | XMP | YouTube | YouTube Rss