jexcel_将excel数据导入到页面

automationanywhere / 2023-05-05 / 原文

jexcel_将excel数据导入到页面

       还需解决的课题:下载jszip.js和xlsx.js  

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="有效代码_将excel数据导入到网页.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title></title>
    <%--CSS--%>
    <link href="/web_page_ssc/css/jexcel.css" rel="stylesheet" />
    <link href="/web_page_ssc/css/jsuites.css" rel="stylesheet" />

    <%--JS--%>
    <%--Jexcel包--%>
    <script src="../web_page_ssc/js/jexcel.js"></script>
    <script src="../web_page_ssc/js/jsuites.js"></script>   

    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.13.5/jszip.js"></script>
    <script src="https://bossanova.uk/jspreadsheet/v3/xlsx.js"></script>

</head>
<body>
    <form id="form1" runat="server">
        <div id="spreadsheet1"></div>
    </form>
</body>
<script>
    jexcel.fromSpreadsheet('/temp/2023-05-05-092829.xlsx', function (result) {
        if (!result.length) {
            console.error('jspreadsheet: Something went wrong.');
        } else {
            if (result.length == 1) {
                jspreadsheet(document.getElementById('spreadsheet1'), result[0]);
            } else {
                jexcel.createTabs(document.getElementById('spreadsheet1'), result);
            }
        }
    });

</script>
</html>