{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","Project Status","Hazards","Incidents","Project Status Whole Report","Incidents Whole Report","Hazards Whole Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Home","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[11,1,11,3],[12,1,12,3],[13,1,13,3],[1,1,1,3],[3,1,3,3],[4,1,4,3],[5,1,5,3]]}
[]
[null,"FILE IMPORTER"]
[]
[null,"IMPORT FILES - DYNAMIC RANGES"]
[null,"To import new reports into the specified worksheets, click the above command button and follow the prompts"]
[null,"The Import Files process will: \nLoop through each of the files listed below and import the required data into the associated worksheet\nThe required data is determined by matching the column headings in row 1 of the associated worksheets with column headings in row 1 of the file specified\nMultiple function are used to ensure that the files exist and the specified column headers are present in the source files"]
[null,null,"File Path & Name","Worksheet"]
[null,null,"C:\\Users\\danie\\Documents\\Sample\\Project Status.xlsx","Project Status"]
[null,null,"C:\\Users\\danie\\Documents\\Sample\\Hazard Data.xlsx","Hazards"]
[null,null,"C:\\Users\\danie\\Documents\\Sample\\Incident Register.xlsx","Incidents"]
[null,"Insert or delete file >>"]
[null,"IMPORT FILES - ENTIRE WORKSHEETS"]
[null,"To import whole reports into the specified worksheets, click the above command button and follow the prompts"]
[null,"The Import Files process will: \nImport only the files specified in the code into the worksheets specified in the code\nNote that the whole worksheet will be copied if using this function"]

{"sheet":"Project Status","index":1,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Project","Status","Project Description"]

{"sheet":"Hazards","index":2,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Project","Hazard: Number","Short Description"]

{"sheet":"Incidents","index":3,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Date of Incident","Injured Employee:","Project / Indirect","Location","Brief Detail of Event"]

{"sheet":"Project Status Whole Report","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Incidents Whole Report","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hazards Whole Report","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}