{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Header Information","UDIs"],"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":"Header Information","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Single Registration Number (SRN) Reference"]
["Company Name"]
["*Company Global Location Number (GLN)"]
["Company FSN Reference"]
["FSN Issue date "]
[]
["*Company Global Location Numbers (GLNs) is a mandatory item. GLNs are used to identify legal entities such as companies. You may already know your GLN but if not contact you local GS1 Membership Organisation or GS1 UK at healthcare@gs1uk.org. If you are a distributor you also need to be identified using a GLN. Please contact GS1 UK at healthcare@gs1uk.org for more information."]

{"sheet":"UDIs","index":1,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,6],[0,7,1,7]]}
["Mandatory Items",null,null,"Optional Items ",null,null,null,"Tables notes:\n•The GTIN should be prepended by zeros, if necessary, to make up to 14 digits. The GTIN column will be flagged in red if the entered GTIN is incorrect/ invalid\n•The GTIN column must be in text format\n•If all batches/serial numbers are affected, then columns D/E may be left blank.\n•The use-by-date and date-of-manufacture should be formatted in Excel date format and displayed as yy/mm/dd \n•If there is any missing information, the cell should be left as a clear field.\n•Any additional fields (i.e. NHS supply chain codes) should be added after the existing columns. The order of the columns should not be changed."]
["Device Identifier GTIN\n","Catalogue Number (Manufacturer Product Code) \n","Product Description","Batch/Lot Number ","Serial Number\n","Use-by Date ","Date of Manufacture  \n"]