title: Angular: How to select a specific Excel worksheet before importing file?
body: <p>I'm implementing a feature that allows the user to select a specific Excel worksheet from a dropdown select list before importing the file, however, I'm unsure how to add the worksheet names to the dropdown list. I've currently placeholder names in the dropdown list as I'm not sure how to incorporate the &quot;sheetNames&quot; function into the current &quot;Worksheet&quot; interface.</p>
  <p>Dropdown Select:</p>
  <pre><code>&lt;mat-form-field id=&quot;worksheetStyle&quot;appearance=&quot;fill&quot;&gt;
                          &lt;mat-label&gt;Excel Worksheet&lt;/mat-label&gt;
                          &lt;mat-select&gt;
                            &lt;mat-option *ngFor=&quot;let worksheet of worksheets&quot; [value]=&quot;worksheet.value&quot;&gt;
                              {{worksheet.viewValue}}
                            &lt;/mat-option&gt;
                          &lt;/mat-select&gt;
                        &lt;/mat-form-field&gt;
  </code></pre>
  <p>Typescript:</p>
  <pre><code>  worksheets: Worksheet[] = [
      {value: '1', viewValue: 'Sheet_1'},
      {value: '2', viewValue: 'Sheet_2'},
      {value: '3', viewValue: 'Sheet_3'},
    ];
  
  
    sheetNames(workbook) {                             
      var arr = new Array;
  
      for (let i = 0; i &lt;= workbook.length; i++) {
        arr.push(workbook.SheetNames[i])
      }
  </code></pre>