import xlsx = require("xlsx");
import _ = require("lodash");
const workbook = xlsx.readFile("BR.xlsx");
const arrayx = {};
arrayx["RateName"] = {};
arrayx["Benefit"] = {};
arrayx["BenefitType"] = {};
arrayx["PremiumType"] = {};
arrayx["SmokingStatus"] = {};
arrayx["SABand"] = {};
function importWorksheetData(workbook: xlsx.WorkBook) {
    var sheets = _.compact(workbook.SheetNames.map(x => {
        return x.substring(0, 4) === "Life" ? x : 0;
    }));
    sheets.forEach(sheet => {
        console.log("Starting Sheet: " + sheet);
        const worksheet = workbook.Sheets[sheet];
        var startC = 0;
        var startR = 0;
        var limitC = 1500;
        var limitR = 1500;
        for (let C = 0; C < limitC; C++) {
            for (let R = 0; R < limitR; R++) {
                if (worksheet[xlsx.utils.encode_cell({ c: C, r: R })]) {
                    startC = C + 2;
                    startR = R;
                    C = limitC;
                    R = limitR;
                }
            }
        }
        console.log(startR, startC);
        for (let R = startR + 1; R < limitR; R++) {
            for (let C = startC; C < limitC; C++) {
                var x = {};
                x["RateName"] = worksheet[xlsx.utils.encode_cell({ c: startC, r: R })].v;
                x["Benefit"] = worksheet[xlsx.utils.encode_cell({ c: startC + 1, r: R })].v;
                x["BenefitType"] = worksheet[xlsx.utils.encode_cell({ c: startC + 2, r: R })].v;
                x["PremiumType"] = worksheet[xlsx.utils.encode_cell({ c: startC + 3, r: R })].v;
                x["SmokingStatus"] = worksheet[xlsx.utils.encode_cell({ c: startC + 4, r: R })].v;
                x["SABand"] = worksheet[xlsx.utils.encode_cell({ c: startC + 5, r: R })].v;
                x["Age"] = worksheet[xlsx.utils.encode_cell({ c: startC + 6, r: R })].v;
                x["Term"] = worksheet[xlsx.utils.encode_cell({ c: C + 7, r: startR - 1 })].v;//(C - startC + 1);
                x["Discount"] = worksheet[xlsx.utils.encode_cell({ c: C + 7, r: R })].v;
                arrayx["RateName"][x["RateName"]] = 1;
                arrayx["Benefit"][x["Benefit"]] = 1;
                arrayx["BenefitType"][x["BenefitType"]] = 1;
                arrayx["PremiumType"][x["PremiumType"]] = 1;
                arrayx["SmokingStatus"][x["SmokingStatus"]] = 1;
                arrayx["SABand"][x["SABand"]] = 1;


                // console.log(x);
                if (!worksheet[xlsx.utils.encode_cell({ c: C + 8, r: R })] && R == startR + 1) {
                    limitC = C + 1;
                    // console.log("C");
                }
            }
            if (!worksheet[xlsx.utils.encode_cell({ c: startC, r: R + 1 })]) {
                limitR = R + 1;
                // console.log("R");
            }
        }
        console.log("******************************************************************************************************");
    });
}


importWorksheetData(workbook);
console.log(arrayx);