您好,
可以在服务器上直接导入Excel,使用代码参考如下:
- protected void ImportBtn_Click(object sender, EventArgs e)
- {
- string uriString = "http://localhost/ExcelIO/xsapi/import";
- System.Net.WebClient myWebClient = new System.Net.WebClient();
- string fileName = MapPath("Test.xls");
- byte[] responseArray = myWebClient.UploadFile(uriString, "POST", fileName);
- string spreadjsJsonResult = System.Text.Encoding.UTF8.GetString(responseArray);
- HiddenField1.Value = spreadjsJsonResult;
- }
复制代码
- <script type="text/javascript">
- $(document).ready(function () {
- $("#ss").wijspread();
- var spread = $("#ss").wijspread("spread");
- var sheet = spread.getActiveSheet();
- //---------------------------------------------------------
- //Import Excel to SpreadJS.
- if ($("#HiddenField1").val() != "") {
- var data = JSON.parse($("#HiddenField1").val());
- spread.fromJSON(data.spread);
- }
- //Export SpreadJS to Excel.
- $("#ExportBtn").click(function () {
- var data = spread.toJSON();
- var dataObj = {
- "spread": spread.toJSON(),
- "exportFileType": "xlsx",
- "excel": {
- "saveFlags": 0,
- "password": ""
- }
- };
- var content = JSON.stringify(dataObj);
- $("#HiddenField1").val(content);
- });
- //---------------------------------------------------------
- });
- </script>
复制代码
- <body>
- <form id="form1" runat="server">
- <div>
- <div id="ss"></div>
- <asp:Button ID="ImportBtn" runat="server" Text="Import Excel" OnClick="ImportBtn_Click" />
- <asp:Button ID="ExportBtn" runat="server" Text="Export Excel" OnClick="ExportBtn_Click" />
- <asp:HiddenField ID="HiddenField1" runat="server" />
- </div>
- </form>
- </body>
复制代码 |