{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Custom_Sort_Order"],"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":"Custom_Sort_Order","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Sort Order","Field Value",null,null,"Subject","Student","Marks"]
[1,"Maths",null,null,"English","Nick",34]
[2,"Science",null,null,"Maths","Vishesh",43]
[3,"English",null,null,"Science","Julian",56]
[null,null,null,null,"English","Sandrahan",76]
[null,null,null,null,"Maths","Lester",65]
[null,null,null,null,"Science","Harald",36]
[]
[]
["Note:"]
["If you try to sort this data on subject using normal excel sort you won't be able"]
["to sort this like in the order given in 1st table. However, by using the code in"]
["this sample worksheet you can apply any sort order you wish by simply putting"]
["the sort order against the field value."]