60 lines
1.9 KiB
HTML
60 lines
1.9 KiB
HTML
|
<!DOCTYPE html>
|
||
|
|
<html lang="en">
|
||
|
|
<head>
|
||
|
|
<meta charset="UTF-8">
|
||
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
||
|
|
<title>Excel Preview</title>
|
||
|
|
<link rel="stylesheet" href="../../layui-v2.8.18/layui/css/layui.css" media="all"/>
|
||
|
|
<style>
|
||
|
|
|
||
|
|
</style>
|
||
|
|
</head>
|
||
|
|
<body>table {
|
||
|
|
border-collapse: collapse;
|
||
|
|
border: 1px solid black;
|
||
|
|
}
|
||
|
|
th, td {
|
||
|
|
border: 1px solid black;
|
||
|
|
padding: 5px;
|
||
|
|
text-align: center
|
||
|
|
}
|
||
|
|
<input type="file" id="excelFileInput" accept=".xlsx, .xls" />
|
||
|
|
<table id="previewTable"></table>
|
||
|
|
|
||
|
|
<script src="../../js/xlsx.full.min.js"></script>
|
||
|
|
<script>
|
||
|
|
document.getElementById('excelFileInput').addEventListener('change', handleFileSelect, false);
|
||
|
|
|
||
|
|
function handleFileSelect(event) {
|
||
|
|
const file = event.target.files[0];
|
||
|
|
const reader = new FileReader();
|
||
|
|
|
||
|
|
reader.onload = function(e) {
|
||
|
|
const data = e.target.result;
|
||
|
|
const workbook = XLSX.read(data, {type: 'array'});
|
||
|
|
|
||
|
|
const sheetName = workbook.SheetNames[0];
|
||
|
|
const sheet = workbook.Sheets[sheetName];
|
||
|
|
|
||
|
|
const table = document.getElementById('previewTable');
|
||
|
|
table.innerHTML = '';
|
||
|
|
|
||
|
|
const range = XLSX.utils.decode_range(sheet['!ref']);
|
||
|
|
for (let R = range.s.r; R <= range.e.r; ++R) {
|
||
|
|
const row = table.insertRow(-1);
|
||
|
|
for (let C = range.s.c; C <= range.e.c; ++C) {
|
||
|
|
const cellRef = XLSX.utils.encode_cell({c: C, r: R});
|
||
|
|
const cell = sheet[cellRef];
|
||
|
|
const text = cell ? cell.v : '';
|
||
|
|
const cellElement = row.insertCell(-1);
|
||
|
|
cellElement.appendChild(document.createTextNode(text));
|
||
|
|
}
|
||
|
|
}
|
||
|
|
};
|
||
|
|
|
||
|
|
reader.readAsArrayBuffer(file);
|
||
|
|
}
|
||
|
|
</script>
|
||
|
|
</body>
|
||
|
|
</html>
|