把Excel读入js

最新推荐文章于 2023-02-05 16:17:34 发布

ikmb

最新推荐文章于 2023-02-05 16:17:34 发布

阅读量941

点赞数

分类专栏：前端技术 .Net 综合文章标签： excel string server button json null

本文链接：https://blog.youkuaiyun.com/ikmb/article/details/4901583

版权

.Net 同时被 3 个专栏收录

104 篇文章

订阅专栏

前端技术

87 篇文章

订阅专栏

综合

55 篇文章

订阅专栏

作者：敖士伟

把Excel读入js或者html中，用ActiveXObject("Excel.Application") 不靠谱。我的思路是把excel传到Server用org.in2bits.MyXls.dll把数据读出再发到客户端，这样传输量大一点，不过感觉还是比ActiveXObject好。下面的代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ReadXLS2JS.aspx.cs" Inherits="Pro.WebApp.Common2.ReadXLS2JS" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title></title> <mce:script type="text/javascript" language="javascript"></mce:script> </head> <body> <form id="form1" runat="server"> <div> <asp:CheckBox ID="CheckBox1" runat="server" Text="是否读取第一行(表头)" /> <br /> <asp:FileUpload ID="FileUpload1" runat="server" /> <asp:Button ID="Button1" runat="server" Text="导入" οnclick="Button1_Click" /> </div> </form> </body> </html>

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using org.in2bits.MyXls; using System.IO; namespace Pro.WebApp.Common2 { public partial class ReadXLS2JS : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } //ikmb@163.com protected void Button1_Click(object sender, EventArgs e) { String savePath = Server.MapPath("~/") + "files//"; bool ReadHeader = false; if (CheckBox1.Checked) ReadHeader = true; //string cs = "1, 3"; //string vs = "tt,gg"; string cs = Request.QueryString["cs"]; string vs = Request.QueryString["vs"]; if (cs == null || vs == null) return; string[] cols = cs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); string[] names = vs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < cols.Length; i++) cols[i] = cols[i].Trim(); for (int i = 0; i < names.Length; i++) names[i] = names[i].Trim(); if (FileUpload1.HasFile) { //String filename; //filename = FileUpload1.FileName; savePath += DateTime.Now.ToString("yyyyMMddHHmmss")+".xls"; FileUpload1.SaveAs(savePath); } XlsDocument xls = new XlsDocument(savePath); Worksheet sheet = xls.Workbook.Worksheets[0]; string json = ""; Row r = null; for (int i = 0; i < sheet.Rows.Count; i++) { if (ReadHeader && i < 1) continue; if (!ReadHeader && i < 2) continue; r = sheet.Rows[(ushort)i]; string tr = ""; for (int j = 1; j <= r.CellCount; j++) { int col_index = Array.IndexOf<string>(cols, j.ToString()); if (col_index != -1) { tr += "{name: /"" + names[col_index] + "/",value:/"" + (r.CellAtCol((ushort)j).Value != null ? r.CellAtCol((ushort)j).Value.ToString() : "") + "/"},"; } } //行结束 if (tr != "") { if (tr.IndexOf(",") != -1) { tr = "[" + tr.Substring(0, tr.LastIndexOf(",")) + "]"; } json += tr + "trsplit"; } } //删除 File.Delete(savePath); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "ReadCallBack('" + json + "');", true); } } }