andyj/excel2html.htm

## excel2html.htm
<html>
<head>
	<style>
		*{
			font-family: arial;
			font-size: 11px;
		}
		table{
			border-collapse: collapse;
			border: 1px solid silver;
		}
		tr{
			border-bottom: 1px solid silver;
		}
		/*This will style the header row!*/
		tr:first-child td {
			background-color: #EEE;
			border: 1px solid silver;
			font-weight: bold;
			padding: 2px;
			text-align: center;
		}
	</style>
<script language="javascript">

function createTable() {

    // Get the data
	var excelData = document.getElementById('csv').value;

    // split into rows
    excelRow = excelData.split(String.fromCharCode(10));

    // split rows into columns
    for (i=0; i<excelRow.length; i++) {
        excelRow[i] = excelRow[i].split(String.fromCharCode(9));

    }

	// start to create the HTML table
	var myTable = document.createElement("table");
	var myTbody = document.createElement("tbody");

	// Loop over the rows
    for (i=0; i<excelRow.length - 1; i++) {

		// create a row in the HTML table
		var myRow = document.createElement("tr");

		// Loop over the columns and add TD to the TR
		for (j=0; j<excelRow[i].length; j++) {
			// Loop over the row columns
			if (excelRow[i][j].length != 0) {
					var myCell = document.createElement("td");
					myCell.innerHTML = excelRow[i][j];
            }
			myRow.appendChild(myCell);
		}
		myTbody.appendChild(myRow);
	}
		myTable.appendChild(myTbody);

    document.body.appendChild(myTable);
	// console.log(myTable)
}
</script>
</head>
<body>
<p>
	On your XLSX document "Select All" then "copy" the data, come to this page, put focus on the &lt;textarea> box and "paste" the text in. In some instance (large data sets) this might take a couple of seconds.
	Once there simply click the button to product the table.
	</p>
<textarea id="csv" placeholder="Paste XLSX content here" style="width: 300px; height: 100px;"></textarea><br/>
<input type="button" value="Create HTML Table from XLSX content" onclick="createTable()" >
</body>
</html>
	<html>
	<head>
	<style>
	*{
	font-family: arial;
	font-size: 11px;
	}
	table{
	border-collapse: collapse;
	border: 1px solid silver;
	}
	tr{
	border-bottom: 1px solid silver;
	}
	/This will style the header row!/
	tr:first-child td {
	background-color: #EEE;
	border: 1px solid silver;
	font-weight: bold;
	padding: 2px;
	text-align: center;
	}
	</style>
	<script language="javascript">

	function createTable() {

	// Get the data
	var excelData = document.getElementById('csv').value;

	// split into rows
	excelRow = excelData.split(String.fromCharCode(10));

	// split rows into columns
	for (i=0; i<excelRow.length; i++) {
	excelRow[i] = excelRow[i].split(String.fromCharCode(9));

	}

	// start to create the HTML table
	var myTable = document.createElement("table");
	var myTbody = document.createElement("tbody");

	// Loop over the rows
	for (i=0; i<excelRow.length - 1; i++) {

	// create a row in the HTML table
	var myRow = document.createElement("tr");

	// Loop over the columns and add TD to the TR
	for (j=0; j<excelRow[i].length; j++) {
	// Loop over the row columns
	if (excelRow[i][j].length != 0) {
	var myCell = document.createElement("td");
	myCell.innerHTML = excelRow[i][j];
	}
	myRow.appendChild(myCell);
	}
	myTbody.appendChild(myRow);
	}
	myTable.appendChild(myTbody);

	document.body.appendChild(myTable);
	// console.log(myTable)
	}
	</script>
	</head>
	<body>
	<p>
	On your XLSX document "Select All" then "copy" the data, come to this page, put focus on the <textarea> box and "paste" the text in. In some instance (large data sets) this might take a couple of seconds.
	Once there simply click the button to product the table.
	</p>
	<textarea id="csv" placeholder="Paste XLSX content here" style="width: 300px; height: 100px;"></textarea><br/>
	<input type="button" value="Create HTML Table from XLSX content" onclick="createTable()" >
	</body>
	</html>