﻿function convertCSV_CAD() {

    var gTable = document.getElementById("tableTwo");

    if (gTable == null) {
        return;
    }

    var r = 0;
    csvout = window.document;
    numofRows = gTable.rows.length - 2;
    numofCells = gTable.rows[0].cells.length - 1;
    var rowcsv = [numofRows];
    var cntrows = 0;
    var startcol;
    if (showCADPoints) {
        startcol = 2
    }
    else {
        startcol = 0
    }
    for (r == 0; r <= numofRows; r++) {
        var c = startcol;
        var tempdata = "";
        for (c == startcol; c <= numofCells; c++) {
            if (c != numofCells) {
                tempdata += gTable.rows[r].cells[c].innerHTML + ",";
            } else {
                tempdata += gTable.rows[r].cells[c].innerHTML + "<br>";
            }
        }
        rowcsv[r] = tempdata;
    }

    var disp_setting = "toolbar=yes,location=no,directories=yes,menubar=yes,";
    disp_setting += "scrollbars=yes,width=650, height=600, left=100, top=25";
    var docCSV = window.open("", "", disp_setting);
    docCSV.document.open();
    docCSV.document.write('<html><head><title>Crime iMap CSV</title>');
    docCSV.document.write('</head><body>');
    var rowcnt = 0;
    for (rowcnt == 0; rowcnt <= rowcsv.length - 1; rowcnt++) {
        docCSV.document.write(rowcsv[rowcnt]);
    }
    docCSV.document.write('</body></html>');
    docCSV.document.close();
    docCSV.focus();

}

function convertCSV_RMS() {

    var gTable = document.getElementById("tableOne");

    if (gTable == null) {
        return;
    }

    var r = 0;
    csvout = window.document;
    numofRows = gTable.rows.length - 2;
    numofCells = gTable.rows[0].cells.length - 1;
    var rowcsv = [numofRows];
    var cntrows = 0;
    var startcol;
    if (showCrimePoints) {
        startcol = 2
    }
    else {
        startcol = 0
    }
    for (r == 0; r <= numofRows; r++) {
        var c = startcol;
        var tempdata = "";
        for (c == startcol; c <= numofCells; c++) {
            if (c != numofCells) {
                tempdata += gTable.rows[r].cells[c].innerHTML + ",";
            } else {
                tempdata += gTable.rows[r].cells[c].innerHTML + "<br>";
            }
        }
        rowcsv[r] = tempdata;
    }

    var disp_setting = "toolbar=yes,location=no,directories=yes,menubar=yes,";
    disp_setting += "scrollbars=yes,width=650, height=600, left=100, top=25";
    var docCSV = window.open("", "", disp_setting);
    docCSV.document.open();
    docCSV.document.write('<html><head><title>Crime iMap CSV</title>');
    docCSV.document.write('</head><body>');
    var rowcnt = 0;
    for (rowcnt == 0; rowcnt <= rowcsv.length - 1; rowcnt++) {
        docCSV.document.write(rowcsv[rowcnt]);
    }
    docCSV.document.write('</body></html>');
    docCSV.document.close();
    docCSV.focus();

}

function CreateExcelSheet() {

    var tblExample = document.getElementById("tableOne");
    if (tblExample == null) {
        return;
    }

    if (window.ActiveXObject) {

        var x = tblExample.rows;

        var xls = new ActiveXObject("Excel.Application");
        xls.visible = true;
        xls.Workbooks.Add;
        for (i = 0; i < x.length; i++) {
            var y = x[i].cells;
            for (j = 0; j < y.length; j++) {
                xls.Cells(i + 1, j + 1).Value = y[j].innerText;
            }
        }

        xls.SaveAs("C:\\table.xls");

    }

}