function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jishan royjishan roy 

How to iterate sheet and multiple data write in for loop

here is my code i want to know how to iterate the Account contact oppoptunity product data in for loop can any one help it is urgent.

handleUploadFinished(event){
        alert("file uploaded");
        var file = event.target.files[0];
        console.log(file);
        // this.attachmentArray = [];
        // for(var i=0; i< file.length; i++){
        //     const fileName = file[i].name;
        //     console.log('fileName' + fileName);
       var reader = new FileReader();
       reader.onload = event => {
           alert('onload');
           var data=event.target.result;
             var workbook=XLS.read(data, {
                type: 'binary'
                
            });
            console.log(workbook);
            
            var XL_row_object = XLS.utils.sheet_to_row_object_array(workbook.Sheets["Account"]);
            console.log(workbook.SheetNames);
            var data = JSON.stringify(XL_row_object);
            console.log(data);
            var XL_row_object = XLS.utils.sheet_to_row_object_array(workbook.Sheets["Contact"]);
            //console.log(workbook.Sheets);
            var data = JSON.stringify(XL_row_object);
            console.log(data);
            var XL_row_object = XLS.utils.sheet_to_row_object_array(workbook.Sheets["Opportunity"]);
            //console.log(workbook.Sheets);
            var data = JSON.stringify(XL_row_object);
            console.log(data);
            var XL_row_object = XLS.utils.sheet_to_row_object_array(workbook.Sheets["Product"]);
            //console.log(workbook.Sheets);
            var data = JSON.stringify(XL_row_object);
            console.log(data);

       };
        reader.readAsBinaryString(file);
         
    }