{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["設定","DATA"],"not_rendered":{"charts":0,"images":5,"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":"設定","index":0,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["シートの保存（Excel、csv、pdf）",null,null,"DATAシート部分を別ファイルにして保存します"]
[]
[]
[]
[]
[]
[null,"パラメーター"]
[]
[null,"保存パス","C:\\temp"]
[]
[null,"保存ファイル名","テスト保存001"]
[]
[null,"ファイルフォーマット選択"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"pdfフォーマットはexcelやcsvの保存と少し違う処理になるよ"]
[null,"主な処理の流れ"]
[]
[null,"Sheets(\"DATA\").Select",null,"保存するシートを選択"]
[null,"Sheets(\"DATA\").Copy",null,"保存するシートをコピー"]
[null,"▼"]
[null,"Filename = Application.GetSaveAsFilename(InitialFileName:=nmfile & fmtchr, FileFilter:=\"Excelファイル,*\" & fmtchr)",null,null,null,null,null,null,null,null,"パラメータのセット"]
[null,"   ",null,"nmfile","ファイル名"]
[null,null,null,"fmtchr","ファイル名フォーマットのパラメーター"]
[null,null,null,"Split(\".xlsx,.csv,.pdf\", \",\") ",null,null,"split 関数で内容をfmtchrに収容"]
[null,"▼"]
[null,"(excel、csvのファイルフォーマットの場合）"]
[null,"ActiveWorkbook.SaveAs Filename:=Filename, FileFormat:=xlCSV, CreateBackup:=False"]
[null,"ActiveWindow.Close",null,"新規シートを閉じる"]
[]
[null,"     "]
[null,"▼"]
[null,"(pdfフォーマットの場合）"]
[null,"With Sheets(\"DATA\").PageSetup  ",null,"DATAページの書式設定"]
[null,"        .Zoom = False"]
[null,"        .FitToPagesWide = 1"]
[null,"        .FitToPagesTall = 1"]
[null,"        .CenterHorizontally = True"]
[null,"        .TopMargin = Application.CentimetersToPoints(1)"]
[null,"        .BottomMargin = Application.CentimetersToPoints(1)"]
[null,"End With"]
[null,"     "]
[null,"Worksheets(\"DATA\").Activate"]
[null,"Worksheets(\"DATA\").ExportAsFixedFormat Type:=xlTypePDF, Filename:=Filename ",null,null,null,null,null,"選択したシートをPDF出力"]
[]
[]
[]
[]
["ver　2021/10/14"]
["CSV保存のバグの修正"]

{"sheet":"DATA","index":1,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["受注番号","受注日","受注先コード","受注先名","郵便番号","住所1","住所2","電話番号","担当部署","担当者","品番","品名","数量","単価","支払い条件","納期","運送業者","備考"]
[20100001,"2020-11-01",1102011,"ＡＢＣシステム開発株式会社","761-8057","香川県高松市",null,"087-869-73**","開発部","小田","A1133","金型部品33",5,12500,"120日為手","2020-12-01","路線便可","納期前倒し不可"]
[20100002,"2020-11-02",1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ001","保守部品001",250,1530,"120日為手","2020-12-01"]
[20100003,"2020-11-03",1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E005","電装部品005",1500,825,"120日為手","2020-12-03"]
[20100004,"2020-11-03",1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E007","電装部品007",2500,922,"120日為手","2020-12-03"]
[20100005,"2020-11-04",1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E009","電装部品009",1250,1210,"120日為手","2020-12-04"]
[20100006,"2020-11-05",1102011,"ＡＢＣシステム開発株式会社","761-8057","香川県高松市",null,"087-869-73**","開発部","小田","A3216","金型部品25",150,18000,"120日為手","2020-12-05","白猫便限定"]
[20100007,"2020-11-05",1102014,"ZZ産業","812-0000","福岡県福岡市博多区",null,"092-431-****","購買部","山崎","S001","仕上げ材001",480,580,"90日為手","2020-12-05"]
[20100008,"2020-11-05",1102014,"ZZ産業","812-0000","福岡県福岡市博多区",null,"092-431-****","購買部","山崎","S005","仕上げ材005",100,1925,"90日為手","2020-12-05",null,"代替品でも可"]
[20100009,"2020-11-06",1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E007","電装部品007",1100,922,"120日為手","2020-12-06"]
[20100010,"2020-11-07",1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E001","電装部品001",3000,1460,"120日為手","2020-12-07"]
[20100011,"2020-11-08",1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ001","保守部品001",50,1530,"120日為手","2020-12-08"]
[20100012,"2020-11-09",1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ002","保守部品002",100,2230,"120日為手","2020-12-09"]
[20100013,"2020-11-09",1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ005","保守部品005",120,1820,"120日為手","2020-12-09"]
[20100014,"2020-11-09",1102014,"ZZ産業","812-0000","福岡県福岡市博多区",null,"092-431-****","購買部","山崎","S005","仕上げ材005",500,1925,"90日為手","2020-12-09"]
[20100015,"2020-11-09",1102011,"ＡＢＣシステム開発株式会社","761-8057","香川県高松市",null,"087-869-73**","開発部","小田","A1255","金型部品11",65,55400,"120日為手","2020-12-09","白猫便限定","納期前倒し可"]
[20100016,"2020-11-09",1102011,"ＡＢＣシステム開発株式会社","761-8057","香川県高松市",null,"087-869-73**","開発部","小田","A2051","金型部品25",112,32500,"120日為手","2020-12-09","白猫便限定"]
[20100017,"2020-11-10",1102014,"ZZ産業","812-0000","福岡県福岡市博多区",null,"092-431-****","購買部","山崎","S005","仕上げ材005",500,1925,"90日為手","2020-12-10"]
[20100018,"2020-11-11",1102013,"生産商会","399-7402","長野県松本市会田",null,"0263-48-****","製造1課","小川","E001","電装部品001",3000,1460,"120日為手","2020-12-11"]
[20100019,"2020-11-12",1102012,"互換工業","230-0033","神奈川県横浜市鶴見区朝日町",null,"045-510-****","生産部","浜崎","Ｍ001","保守部品001",50,1530,"120日為手","2020-12-12",null,"場合により数量増"]