{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Problem","Input","Output"],"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":"Problem","index":0,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Problem Statement"]
[null,"In the Input sheet some names of the employees will be populated in column A as shown below. The rows in which data will be available is uncertain. Provide the output in Output sheet in column A. First row should contain number of names, second row should contain number of unique name and third onwards list all the unique names in Descending order."]
[]
[null,"Blank and white characters(example space,tab,etc) values to be eliminated from the output"]
[]
[null,"The macro should read input from Input tab and write the output in Output tab"]
[]
["Module Name"]
[null,"Module1"]
[]
["Macro Name"]
[null,"NameAnalysis"]
[null,"Note :  NameAnalysis should be defined as public"]
[]
["Input Example1",null,"Input Example2"]
["Arun",null,"Apple"]
["Rahul",null,"Water Melon"]
["Seema",null,"Bannana"]
["Anubhavi",null,"Orange"]
["Sheetal",null,"Sweet Lime"]
["Karan",null,"Grapes"]
["Ranjith",null," "]
["Rahul",null,"Apple"]
["Sheetal",null,"Orange"]
["Paul",null,"       "]
[null,null,"Apricot"]
[]
["Output Example1",null,"Output Example2"]
[10,null,9]
[8,null,7]
["Sheetal",null,"Water Melon"]
["Seema",null,"Sweet Lime"]
["Ranjith",null,"Orange"]
["Rahul",null,"Grapes"]
["Paul",null,"Bannana"]
["Karan",null,"Apricot"]
["Arun",null,"Apple"]
["Anubhavi"]
[]
[]
["* Please see the sample in \"Input\" tabs and \"Output\" tabs"]

{"sheet":"Input","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Arun"]
["Rahul"]
["Seema"]
["Anubhavi"]
["Sheetal"]
["Karan"]
["Ranjith"]
["Rahul"]
["Sheetal"]
["Paul"]

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