{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MAINS","DSPER","readme"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MAINS","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"★Outlookの情報を一括して抽出します★"]
[]
["Outlookの文書・カレンダー情報を取得します。"]
[null,null,null,null,null,"（↓保存先はこのPCからのアクセス件があるものにしてください）"]
["集計開始日","2015-01-01",null,"添付ファイルの保存先",null,"C:\\tdata"]
["集計終了日","2022-05-20",null,"取得文書数",null,85]
[null,null,null,null,null,"（↑最新文書からさかのぼっての件数）"]
[]
[]
["ｶﾚﾝﾀﾞｰ全文書",0]
[]
["キーワード","サーバー",null,"HIT件数",8]
[]
[null,null,"機能説明"]
[null,null,null,"カレンダー情報",null,"カレンダー情報を読み出します"]
[null,null,null,"メール文書・添付ﾌｧｲﾙ",null,"メール文書・添付ファイルを読み出します"]
[]
[null,null,null,"読み出し先",null,"DSPERシート"]
[]
[null,null,null,"キーワード検索",null,"キーワード文字が含まれる文書を抽出します"]

{"sheet":"DSPER","index":1,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["受信日時","表題","差出人","CC","本文","添付数","添付ファイル名"]
["2022-03-25T15:54:54","＼3/31まで／対象者限定☆本メールでキャッシュバック増額！","*******","****@xxxx.com","\t\t\r\n一部のウェブメールサービスやメールソフトでは画像が表示されない場合がありますので、画像表示を設定のうえご覧ください。\t \r\n <https://ai.yimg.jp/c/logo/f/2.0/","なし"]
["2022-03-25T08:16:58","極上のBBQ3点セット、お花見気分におすすめのグルメ","*******","****@xxxx.com","一部のWebメールサービスやメールソフトでは画像が表示されない場合があります。\t \r\n <https://s.yimg.jp/images/sh/newsclip/common/spacer.gif>","なし"]
["2022-03-24T11:25:56","ラスク、クッキー、チョコレートなどスイーツが満載","*******","****@xxxx.com","\t\r\n <https://yahoo.jp/eTWYuD> \t\r\n <https://s.yimg.jp/images/clear.gif> \r\n注目アイテムが続々出品中♪ \t\r\n <https://","なし"]
["2022-03-24T09:20:13","『ファイナンスVIP倶楽部』の便利な機能 ","*******","****@xxxx.com",null,"なし"]
["2022-03-09T19:49:44","【クーポンを進呈しました】最大50％OFFクーポンをチェック！","*******","****@xxxx.com","一部のウェブメールサービスやメールソフトでは画像が表示されない場合がありますので、画像表示を設定のうえご覧ください。 \t\r\n <https://yahoo.jp/laYiQO> \r\n <https:/","なし"]
["2020-03-10T14:41:26","【重要】FTPによるファイルダウンロード機能終了について","*******","****@xxxx.com","━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n本メールは、Yahoo!ジオシティーズを過去にご利用いただいたお客様へ\nお送りしております。\n\nYahoo! JAPAN IDに","なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]
[null,null,null,null,null,"なし"]

{"sheet":"readme","index":2,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["◆ツールの説明"]
[]
["Outlookのカレンダー、メール文書を直接EXCELに取り込むためのツール。"]
["いちいちOutlookを開かなくても、カレンダー情報やメール文書が直接EXCELに取り込むことが出来るツール。"]
["添付ファイルの保存機能、取り込み情報の検索機能もあります。"]
["Outlookのフォルダーから情報を取得します。"]
["（Outlookの環境が存在することが必須になります：アカウントがありメール等の送受信ができる環境）"]
[]
["◆開発"]
[]
[]
[]
["◆開発環境"]
[null,"開発環境"]
[]
[null,"os",null,"Microsoft Windows 10 Professional 1909",null,null,null,"64bit"]
[null,"excel",null,"microsoft excel 2019 64bit"]
[]
["WindowsAPI",null,null,"不使用"]
["EXCEL　コントロール",null,null,"Windows　Outlook　16.0　Obuject　Library"]
[]
["◆履歴"]
["1)2020/10"]
[null,"64ビット化に伴う再構成"]