{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":20,"n_cols":32,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,0,10,2],[0,0,0,2]],"flags":["formulas_cached_only"]}
["*Template for major data import"]
[null,"(Date: dd/MM/yyyy)","(Date: dd/MM/yyyy)","(12 chars)","(12 chars)","(8 chars)","(8 chars)","(30 chars)","(30 chars)","(8 chars)","(8 chars)","(8 chars)","(10 chars)","(10 chars)","(10 chars)","(10 chars)","(12 chars)","(12 chars)","(12 chars)","(12 chars)","(20 chars)","(20 chars)","(12 chars)","(12 chars)","(12 chars)","(12 chars)","(5 chars)","(30 chars)","(9 chars)","(Value range from 0 to 32767)","(Number, use System Currency Decimal)","(20 chars)"]
[null,"FromDate","ToDate","FromItemType","ToItemType","FromItemGroup","ToItemGroup","FromItemCode","ToItemCode","UOM","FromLocation","ToLocation","FromProjNo","ToProjNo","FromDeptNo","ToDeptNo","FromSalesAgent","ToSalesAgent","FromPriceCategory","ToPriceCategory","FromDebtorType","ToDebtorType","FromAreaCode","ToAreaCode","FromDebtorCode","ToDebtorCode","CurrencyCode","DisplayTerm","GEQty","Priority","FixedPrice","Discount"]
["Sample","2010-01-01","2010-12-31","DIGI",null,"PHONE",null,null,null,"PCS","HQ",{"$nulls":9},"GOOD",null,null,null,"300-A0001",null,"MYR",null,2,32767,100,10]
[]
[]
[]
[]
[]
[]
["Template for simple data import"]
[null,"(Date: dd/MM/yyyy)","(Date: dd/MM/yyyy)","(12 chars)","(8 chars)","(30 chars)","(8 chars)","(8 chars)","(10 chars)","(10 chars)","(12 chars)","(12 chars)","(20 chars)","(12 chars)","(12 chars)","(5 chars)","(30 chars)","(9 chars)","(Value range from 0 to 32767)","(Number, use System Currency Decimal)","(20 chars)"]
[null,"FromDate","ToDate","ItemType","ItemGroup","ItemCode","UOM","Location","ProjNo","DeptNo","SalesAgent","PriceCategory","DebtorType","AreaCode","DebtorCode","CurrencyCode","DisplayTerm","GEQty","Priority","FixedPrice","Discount"]
["Sample","2010-01-01","2010-12-31","DIGI","PHONE",null,"PCS","HQ",{"$nulls":4},"GOOD",null,"300-A0001","MYR",null,2,null,100,10]
[]
[]
[]
[]
[]
["* Note: When using the template for major data import, be advised that if the To- column is left empty, the program will automatically fill the information in that column with the information available from the From- column."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}