Copy Paste from Excel to ngPrime Datatable

.txt

//Component.html
<p-column *ngFor="let col of cols; let i = index" [field]="col.field" [header]="col.header">
        <ng-template pTemplate="body" let-car="rowData">
                <span *ngIf="car.editable" [attr.data-index]="i">
                    <input type="text" (keyup)="populate($event, i)" >
                </span>
                <span *ngIf="!car.editable">{{car[col.field]}}</span>
        </ng-template>
    </p-column>
    
//Component code
populate(event, index) {
    
    const inputElement = event.target;
    const rowElement = inputElement.parentElement.parentElement.parentElement.parentElement;

    const value = inputElement.value;
    if(value.includes("\t")) {
      const cellValues = value.split("\t").map(str => str.trim());
      cellValues.forEach((val, i) => {
        const element = rowElement.querySelector(`span[data-index="${index + i}"] input`);
        if(element) {
          element.value = val;
        }
      });
    }
  }