{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Welcome","Trans_Updt","Master Codes","Sample Consolidated eWayBill"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":14,"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":"Welcome","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Update  EWB Transporter"]
[null,"Column Name","Type","Description","Column Value","Mandatory"]
[null,"E-Way Bill No","Number(12)","Ewaybill Number generated",123456789123,"yes"]
[null,"Transporter ID","Text(15)","Transporter ID","29AAACG0569P1Z3","yes"]

{"sheet":"Trans_Updt","index":1,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,3,2,16383],[3,3,1048575,16383],[0,6,1,16383]]}
[null,"Update  EWB Transporter",null,null,"                         * Indicates mandatory fields"]
["GSTIN: *","Name: *","Place: * ",null,"Pin Code: *"]
["E-Way Bill No *","Transporter ID *","Errors List"]

{"sheet":"Master Codes","index":2,"n_rows":85,"n_cols":18,"rows_kept":85,"cut":false,"hidden":true,"merged":[]}
["Column Name","Column Value"]
["State","ANDAMAN AND NICOBAR"]
[null,"ANDHRA PRADESH"]
[null,"ARUNACHAL PRADESH"]
[null,"ASSAM",null,null,null,null,null,null,null,null,"Inward",null,"ST_NAME","STATE_NO",null,null,"BAGS                     ","BGS"]
[null,"BIHAR",null,null,null,null,null,null,null,null,"Outward",null,"ANDAMAN AND NICOBAR",35,null,null,"BUNDLES                  ","BND"]
[null,"CHANDIGARH",null,null,null,null,null,null,null,null,null,null,"ANDHRA PRADESH",37,null,null,"BOXES                    ","BOX"]
[null,"CHHATTISGARH",null,null,null,null,null,null,"Supply",null,"Supply",null,"ARUNACHAL PRADESH",12,null,null,"CENTI METERS             ","CMS"]
[null,"DADAR AND NAGAR HAVELI",null,null,null,null,null,null,"Import",null,"Export",null,"ASSAM",18,null,null,"DOZENS                   ","DZN"]
[null,"DAMAN AND DIU",null,null,null,null,null,null,"SKD/CKD",null,"Job Work",null,"BIHAR",10,null,null,"GRAMS                    ","GMS"]
[null,"DELHI",null,null,null,null,null,null,"Job work Returns",null,"SKD/CKD",null,"CHANDIGARH",4,null,null,"HUNDRED KILOMETERS       ","HKM"]
[null,"GOA",null,null,null,null,null,null,"Sales Return",null,"Recipient Not Known",null,"CHHATTISGARH",22,null,null,"HUNDRED NUMBERS/UNITS    ","HNO"]
[null,"GUJARAT",null,null,null,null,null,null,"Sales Return",null,"Recipient Not Known",null,"DADAR AND NAGAR HAVELI",26,null,null,"HUNDRED NUMBERS/UNITS    ","HNO"]
[null,"HARYANA",null,null,null,null,null,null,"Others",null,"Exhibition or Fairs",null,"DAMAN AND DIU",25,null,null,"KILO METERS              ","KMS"]
[null,"HIMACHAL PRADESH",null,null,null,null,null,null,null,null,"Lines Sales",null,"DELHI",7,null,null,"LITRES                   ","LTS"]
[null,"JAMMU AND KASHMIR",null,null,null,null,null,null,null,null,"Others",null,"GOA",30,null,null,"MILLI LITRES             ","MLS"]
[null,"JHARKHAND",null,null,null,null,null,null,null,null,null,null,"GUJARAT",24,null,null,"METERS                   ","MTR"]
[null,"KARNATAKA",null,null,null,null,null,null,null,null,null,null,"HARYANA",6,null,null,"METRIC TONNES            ","MTS"]
[null,"KERALA",null,null,null,null,null,null,null,null,null,null,"HIMACHAL PRADESH",2,null,null,"NUMBERS/UNITS            ","NOS"]
[null,"LAKSHADWEEP",null,null,null,null,null,null,null,null,null,null,"JAMMU AND KASMIR",1,null,null,"PAIRS                    ","PAR"]
[null,"MADHYA PRADESH",null,null,null,null,null,null,null,null,null,null,"JHARKHAND",20,null,null,"QUINTALS                 ","QTS"]
[null,"MAHARASHTRA",null,null,null,null,null,null,null,null,null,null,"KARNATAKA",29,null,null,"THOUSAND NUMBERS/UNITS   ","SNO"]
[null,"MANIPUR",null,null,null,null,null,null,null,null,null,null,"KERALA",32,null,null,"THOUSAND KILOMETERS      ","TKM"]
[null,"MEGHALAYA",null,null,null,null,null,null,null,null,"Road",null,"LAKSHADWEEP",31,null,null,"THOUSAND LITRES          ","TLT"]
[null,"MIZORAM",null,null,null,null,null,null,null,null,"Air",null,"MADHYA PRADESH",23,null,null,"TEN NUMBERS/UNITS        ","TNO"]
[null,"NAGALAND",null,null,null,null,null,null,null,null,"Rail",null,"MAHARASTRA",27,null,null,"TONNES                   ","TON"]
[null,"ORISSA",null,null,null,null,null,null,null,null,"Ship",null,"MANIPUR",14]
[null,"PONDICHERRY",null,null,null,null,null,null,null,null,null,null,"MEGHALAYA",17]
[null,"PUNJAB",null,null,null,null,null,null,null,null,"< 10",null,"MIZORAM",15]
[null,"RAJASTHAN",null,null,null,null,null,null,null,null,"10 - 100",null,"NAGALAND",13]
[null,"SIKKIM",null,null,null,null,null,null,null,null,"100 - 300",null,"ORISSA",21]
[null,"TAMIL NADU",null,null,null,null,null,null,null,null,"300 - 500",null,"PONDICHERRY",34]
[null,"TELANGANA",null,null,null,null,null,null,null,null,"500 - 1000",null,"PUNJAB",3]
[null,"TRIPURA",null,null,null,null,null,null,null,null,"> 1000",null,"RAJASTHAN",8]
[null,"UTTAR PRADESH",null,null,null,null,null,null,null,null,null,null,"SIKKIM",11]
[null,"UTTARAKHAND",null,null,null,null,null,null,null,null,null,null,"TAMIL NADU",33]
[null,"WEST BENGAL",null,null,null,null,null,null,null,null,null,null,"TELANGANA",36]
[null,"OTHER COUNTRIES",null,null,null,null,null,null,null,null,null,null,"TRIPURA",16]
[null,null,null,null,null,null,null,null,null,null,null,null,"UTTAR PRADESH",9]
[null,null,null,null,null,null,null,null,null,null,null,null,"UTTARAKHAND",5]
["Trans Mode","Road",null,null,null,null,null,null,null,null,null,null,"WEST BENGAL",19]
[null,"Rail",null,null,null,null,null,null,null,null,null,null,"OTHER COUNTRIES",99]
[null,"Air"]
[null,"Ship"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Reg"]
[null,null,null,null,null,null,null,null,null,null,null,"UnReg"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Intra"]
[null,null,null,null,null,null,null,null,null,null,null,"Inter"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Inward","IN","Invoice ","INV"]
[null,null,null,null,null,null,null,null,null,null,"Outward","OUT","Bill","BIL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bill of Entry","BOE"]
[null,null,null,null,null,null,null,null,null,null,"Supply",1,"Challan","CHL"]
[null,null,null,null,null,null,null,null,null,null,"Import",2,"Credit Note","CNT"]
[null,null,null,null,null,null,null,null,null,null,"Export",3,"Others","OTH"]
[null,null,null,null,null,null,null,null,null,null,"Job Work",4]
[null,null,null,null,null,null,null,null,null,null,"For Own Use",5,"Invoice "]
[null,null,null,null,null,null,null,null,null,null,"Job work Returns",6,"Bill"]
[null,null,null,null,null,null,null,null,null,null,"Sales Return",7,"Bill of Entry"]
[null,null,null,null,null,null,null,null,null,null,"Others",8,"Challan"]
[null,null,null,null,null,null,null,null,null,null,"SKD/CKD",9,"Credit Note"]
[null,null,null,null,null,null,null,null,null,null,"Lines Sales",10,"Others"]
[null,null,null,null,null,null,null,null,null,null,"Recipient Not Known",11]
[null,null,null,null,null,null,null,null,null,null,"Exhibition or Fairs",12]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Road",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Air",3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rail",2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ship",4]
[]
[null,null,null,null,null,null,null,null,null,null,"< 10",1]
[null,null,null,null,null,null,null,null,null,null,"10 - 100",2]
[null,null,null,null,null,null,null,null,null,null,"100 - 300",3]
[null,null,null,null,null,null,null,null,null,null,"300 - 500",4]
[null,null,null,null,null,null,null,null,null,null,"500 - 1000",5]
[null,null,null,null,null,null,null,null,null,null,"> 1000",6]

{"sheet":"Sample Consolidated eWayBill","index":3,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,11,1,16383],[2,7,2,16383],[3,7,1048575,16383]]}
[null,"Consolidated  E-Way Bill Form"]
["GSTIN :",null,"Name:",null,null,"Place:",null,"Pin Code:"]
["Vehicle No","Place*","Trans Mode*","State*","E-Way Bill No*","Trans DocNo","Trans Date"]
["KA12KA1234","BANGALORE",1,"KARNATAKA",121000000040]
["KA12KA1234","BANGALORE","Road","KARNATAKA",191000000041]
[null,"BANGALORE","Rail","KARNATAKA",111000000076,"123-45","2018-03-02"]