js中json格式数据转csv格式数据，可复制到excel文件中

实现ctrl+c的效果，将数据复制到粘贴板中

<script type="text/javascript">
		function copyUrl2()
		    {
		        var Url2=document.getElementById("biao1").innerText;
		        var oInput = document.createElement('input');
		        oInput.value = Url2;
		        document.body.appendChild(oInput);
		        oInput.select(); // 选择对象
		        document.execCommand("Copy"); // 执行浏览器复制命令
		        oInput.className = 'oInput';
		        oInput.style.display='none';
		        console.log('复制成功');
		    }
			
		</script>
		<div cols="20" id="biao1">2323232</div>
		<input type="button" onClick="copyUrl2()" value="点击复制代码" />

实现ctrl+c的功能，将数据粘贴到粘贴板中，ctrl+v可以将复制的数据粘贴

实现json数据转csv格式，并且粘贴到excel中

<script type="text/javascript">
			const arr = [{
					value: '123'
				},
				{
					value: '456'
				},
				{
					value: '789'
				},
				{
					value: '290'
				}
			]

			function copyUrl2() {
				function jsontoCSV(arrData) {
					let csv = ''
					let row = ''
					for (let index in arrData[0]) {
						row += index + ','
					}
					row = row.slice(0, -1)
					csv += row + '\r\n'
					for (let i = 0; i < arrData.length; i++) {
						let rows = ''
						for (let index in arrData[i]) {
							let arrValue = arrData[i][index] == null ? '' : '' + arrData[i][index]
							rows += arrValue + ','
						}
						rows = rows.slice(0, rows.length - 1)
						csv += rows + '\r\n'
					}
					console.log(csv)
					return csv
				}
				const csv = jsontoCSV(arr)
				console.log(csv)
				var Url2 = csv;
				let oInput = document.createElement('textarea')
				oInput.value = csv
				document.body.appendChild(oInput)
				oInput.select()
				document.execCommand('Copy')
				oInput.className = 'oInput'
				oInput.style.display = 'none'
				console.log('复制成功')
			}
		</script>
		<div cols="20" id="biao1">2323232</div>
		<input type="button" onClick="copyUrl2()" value="点击复制代码" />

效果图：实现json格式转csv格式