Need help with Office Script

Question

I dont know how to get rid of the error

Type 'string' is not assignable to type '(string | number | boolean)[]'. while running my script even though my fields should all be string and are indicated as string

Answer 1

@Lz._

This is my script:

 function main(  
      workbook: ExcelScript.Workbook,  
      
      OrderID:string,  
      Date:string,  
      Tech:string,  
      Route:string,  
      ShippingMethod:string,  
      StreetAddress:string,  
      City:string,  
      Reqarray: arrayvar[]  
    )    
      
    { let selectedSheet = workbook.getActiveWorksheet();  
      selectedSheet.getRange("D3").setValue([OrderID]);  
      selectedSheet.getRange("E4").setValue([Date]);  
      selectedSheet.getRange("D7").setValue([ShippingMethod]);  
      selectedSheet.getRange("A3").setValue([Tech]);  
      selectedSheet.getRange("A4").setValue([Route]);  
      selectedSheet.getRange("A5").setValue([StreetAddress]);  
      selectedSheet.getRange("A6").setValue([City]);  
  
      selectedSheet.getRange("A9:E9").setValues([["ItemNumber","Description","ProductCode","VendorNumber","Qty"]]);  
      
      let newTable = workbook.addTable(selectedSheet.getRange("A9:E9"),true);  
      newTable.setName('Items');  
      
      selectedSheet.setName('ReqFormTemplate');  
      
      const starterrow = 2;   
      for (let i=0; i < Reqarray.length; i++) {  
        const currentObject = Reqarray[i];  
        const formattedrow = [[currentObject.ItemNumber,currentObject.Description,currentObject.ProductCode,currentObject.VendorNumber,currentObject.Qty]];  
        const rowRange = `A${starterrow + i}:E${starterrow + i}`;  
        selectedSheet.getRange(rowRange).setValues(formattedrow);  
      }  
      
    }  
      
    interface arrayvar {  
      ItemNumber: string,  
      Description: string,  
      ProductCode: string,  
      VendorNumber: string,  
      Qty: number  
    }