You need to sign in to do that
Don't have an account?
jishan 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);
}
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);
}