Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

341
Views
Read specific rows of excel file in angular using xlsx package

I have read excel file in angular11 using xlsx package.

the bellow code read all rows which start from first row if data available and also skip from empty row. Now I want to start reading from specific row and also want to read empty row?

const target:DataTransfer=<DataTransfer>(evt.target); 
    if(target.files.length!==1) throw new Error('Can not select multiple
    files');   const reader:FileReader=new FileReader();  
    reader.onload=(e:any)=>{
        const bstr:string=e.target.result;
        const wb:XLSX.WorkBook=XLSX.read(bstr,{type:'binary'});
        const wsname:string=wb.SheetNames[0];
        const ws:XLSX.WorkSheet=wb.Sheets[wsname];
        // console.log(ws);
        this.ExcelData=(XLSX.utils.sheet_to_json(ws ,{header:1}));
        console.log(this.ExcelData);
    
      };   reader.readAsBinaryString(target.files[0]);
about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!