xlsx转JSON

最新推荐文章于 2023-11-28 16:36:44 发布

BLUESKYHOST

最新推荐文章于 2023-11-28 16:36:44 发布

阅读量362

点赞数

分类专栏： nodeJS 文章标签： html

本文链接：https://blog.csdn.net/BLUESKYHOST/article/details/109483232

版权

nodeJS 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

下载插件

npm i xlsjs

示例

<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
		<title></title>

	</head>
	<script src="./js_xlsx.core.min.js" type="text/javascript" charset="utf-8"></script>
	<script src="./jquery.min.js" type="text/javascript" charset="utf-8"></script>
	<body>
		<input type="file" id="file" />
	</body>
</html>
<script type="text/javascript">
	// 读取本地excel文件

	$(function() {
		document.getElementById('file').addEventListener('change', function(e) {
			var files = e.target.files;
			if (files.length == 0) return;
			var f = files[0];
			if (!/\.xlsx$/g.test(f.name)) {
				alert('仅支持读取xlsx格式！');
				return;
			}
			readWorkbookFromLocalFile(f, function(workbook) {
				readWorkbook(workbook);
			});
		});
	});
		//解析xml返回数据
	function readWorkbook(workbook) {
		var sheetNames = workbook.SheetNames; // 工作表名称集合
		var worksheet = workbook.Sheets[sheetNames[0]]; // 这里我们只读取第一张sheet
		var csv = XLSX.utils.sheet_to_csv(worksheet);
		let stringResult = csv.replace(/(\r\n)|(\n)/g, ',');
		let stringResult2 = stringResult.split(',');
		console.log(stringResult2);

		return
		// console.log(sheetNames);
		// console.log(worksheet);
		// return
		// document.getElementById('result').innerHTML = csv2table(csv);
	}
//读区文件xml
	function readWorkbookFromLocalFile(file, callback) {
		var reader = new FileReader();
		reader.onload = function(e) {
			var data = e.target.result;
			var workbook = XLSX.read(data, {
				type: 'binary'
			});
			if (callback) callback(workbook);
		};
		reader.readAsBinaryString(file);
	}
</script>

BLUESKYHOST

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
xlsx转JSON

下载插件npm i xlsjs<!DOCTYPE html><html> <head> <meta charset="utf-8"> <title></title> </head> <script src="./js_xlsx.core.min.js" type="text/javascript" charset="utf-8"></script> <script sr
复制链接

扫一扫