title: Angular - How to Check Excel File Filtered Or Not?
body: <p><strong>Original Excel File</strong></p>
  <p><a href="https://i.stack.imgur.com/XNMNn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XNMNn.png" alt="enter image description here" /></a></p>
  <p><strong>Filtered Excel File</strong></p>
  <p><a href="https://i.stack.imgur.com/iwnkx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iwnkx.png" alt="enter image description here" /></a></p>
  <p><strong>code</strong></p>
  <pre><code>onFileChange(evt: any) {
      /* wire up file reader */
      const target: DataTransfer = &lt;DataTransfer&gt;(evt.target);
      if (target.files.length !== 1) throw new Error('Cannot use multiple files');
      const reader: FileReader = new FileReader();
      reader.onload = (e: any) =&gt; {
        /* read workbook */
        const bstr: string = e.target.result;
        const wb: XLSX.WorkBook = XLSX.read(bstr, { type: 'binary' });
  
        /* grab first sheet */
        const wsname: string = wb.SheetNames[0];
        const ws: XLSX.WorkSheet = wb.Sheets[wsname];
  
        /* save data */
        this.data = &lt;AOA&gt;(XLSX.utils.sheet_to_json(ws, { header: 1 }));
        console.log(this.data);
      };
      reader.readAsBinaryString(target.files[0]);
    }
  </code></pre>
  <p><strong>Questions?</strong></p>
  <ol>
  <li><p>How to check excel file filtered or not?</p>
  </li>
  <li><p>How to read the filtered value data only?</p>
  </li>
  </ol>