{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Trim spaces"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":3,"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":"Data","index":0,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Question1","Question2",null,"Words","New words"]
["medium","very good",null,99,"unknown"]
["low","good",null,"excellent","wonderful"]
[" medium","bad"]
["medium","very bad"]
["medium","excellent"]
["high","very     good"]
["   low","   good"]
["low",99]
[99,"very bad"]
[99,"excellent"]
[99,"excellent"]
["medium","very good"]
["low","good"]
[" medium","bad"]
["medium","very bad"]
["medium","excellent"]
["high","very     good"]
["   low","   good"]
["low",99]
[99,"very bad"]
[99,"excellent"]
[99,"excellent"]
["medium","very good"]
["low","good"]
[" medium","bad"]
["medium","very bad"]
["medium","excellent"]
["high","very     good"]
["   low","   good"]
["low",99]
[99,"very bad"]
[99,"excellent"]
[99,"excellent"]

{"sheet":"Trim spaces","index":1,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2022.4.1.12345 - Cleaning text data - Start time: 21/10/2022 at 17:31:02 / End time: 21/10/2022 at 17:31:03 / Microsoft Excel 16.015629"]
[null,"Data: Workbook = Demo_TRM.xls / Sheet = Data / Range = 'Data'!$A:$B / 33 rows and 2 columns"]
[null,"Replace characters: Workbook = Demo_TRM.xls / Sheet = Data / Range = 'Data'!$D$1:$D$3 / 2 rows and 1 column"]
[null,"by: Workbook = Demo_TRM.xls / Sheet = Data / Range = 'Data'!$E$1:$E$3 / 2 rows and 1 column"]
[null,"Cleaning text data: Left & Right"]
[null,"Spaces between words: 1"]
[]
[]
[]
[]
[null,"Clean text:"]
[]
[null,"Question1","Question2"]
[null,"medium","very good"]
[null,"low","good"]
[null,"medium","bad"]
[null,"medium","very bad"]
[null,"medium","wonderful"]
[null,"high","very good"]
[null,"low","good"]
[null,"low","unknown"]
[null,"unknown","very bad"]
[null,"unknown","wonderful"]
[null,"unknown","wonderful"]
[null,"medium","very good"]
[null,"low","good"]
[null,"medium","bad"]
[null,"medium","very bad"]
[null,"medium","wonderful"]
[null,"high","very good"]
[null,"low","good"]
[null,"low","unknown"]
[null,"unknown","very bad"]
[null,"unknown","wonderful"]
[null,"unknown","wonderful"]
[null,"medium","very good"]
[null,"low","good"]
[null,"medium","bad"]
[null,"medium","very bad"]
[null,"medium","wonderful"]
[null,"high","very good"]
[null,"low","good"]
[null,"low","unknown"]
[null,"unknown","very bad"]
[null,"unknown","wonderful"]
[null,"unknown","wonderful"]
[]
[]
[null,"Coding table:"]
[]
[null,"Replace...","by"]
[null,"99","unknown"]
[null,"excellent","wonderful"]