{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"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":"Sheet1","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,4,1],[2,2,2,3],[2,4,2,5],[2,6,2,7]]}
[]
[null,null,null,"元号表示テスト"]
[null,"番号","元データ",null,"そのまま表示すると",null,"新元号非対応のExcelでの対応"]
[null,null,"シリアル値","表示文字列","表示形式で","TEXT（Excel関数）","数式","Geg（ユーザー関数）"]
[null,null,"元日付データ",null,"新元号非対応","新元号非対応","数式で対応","VBAで自作"]
[null,1,"2019-01-01","ggge年m月d日",{"$f":"C6","v":"2019-01-01"},{"$f":"TEXT(C6,D6)","v":"平成31年1月1日"},{"$f":"IF(C6<DATEVALUE(\"2019/5/1\"),TEXT(C6,D6),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(DATE(YEAR(C6)-30,MONTH(C6),DAY(C6)),D6),\"平\",\"令\"),\"成\",\"和\"),\"H\",\"R\") )","v":"平成31年1月1日"},{"$f":"Gng(C6,D6)","v":"平成31年1月1日"}]
[null,2,"2019-04-30","ggge年mm月dd日",{"$f":"C7","v":"2019-04-30"},"平成31年04月30日",{"$f":"IF(C7<DATEVALUE(\"2019/5/1\"),TEXT(C7,D7),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(DATE(YEAR(C7)-30,MONTH(C7),DAY(C7)),D7),\"平\",\"令\"),\"成\",\"和\"),\"H\",\"R\") )","v":"平成31年04月30日"},{"$f":"Gng(C7,D7)","v":"平成31年04月30日"}]
[null,3,"2019-05-01","ggge年m月d日","2019-05-01","平成31年5月1日","令和1年5月1日","令和1年5月1日"]
[null,4,"2019-12-31","gggee年mm月dd日","2019-12-31","平成31年12月31日","令和01年12月31日","令和01年12月31日"]
[null,5,"2020-01-01","gge年m月d日","2020-01-01","平32年1月1日","令2年1月1日","令2年1月1日"]
[null,6,"2020-04-01","gee年m月d日","2020-04-01","H32年4月1日","R02年4月1日","R02年4月1日"]
[null,7,"2021-04-01","ge/m/d","2021-04-01","H33/4/1","R3/4/1","R3/4/1"]
[null,8,"2022-04-01","gee/mm/dd","2022-04-01","H34/04/01","R04/04/01","R04/04/01"]
[null,9,"2023-04-01","gee.mm.dd","2023-04-01","H35.04.01","R05.04.01","R05.04.01"]
[null,10,"2024-04-01","gee-mm-dd","2024-04-01","H36-04-01","R06-04-01","R06-04-01"]