Web中打开Excel，并且进行编辑保存

最新推荐文章于 2024-06-06 09:30:31 发布

ZHUDANLOVEcsdn

最新推荐文章于 2024-06-06 09:30:31 发布

阅读量3.7k

点赞数

分类专栏： Excel操作技术文档文章标签： excel .net web xml

本文链接：https://blog.csdn.net/zhudan50/article/details/37603181

版权

Excel操作技术文档专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.首先新建网站

2.把设置好格式的excel保存为xml格式，点击另存。

3.xml文件添加到网站项目中

4.添加浏览页aspx代码如下

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ExcelBrowse.aspx.cs" Inherits="ExcelBrowse" %>

<!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>
    <script type="text/javascript">
    function ScreenSpliter(header, footer, middle)
    {
     this._header = document.getElementById(header);
     this._footer = document.getElementById(footer);
     this._middle = document.getElementById(middle);

     document.body.style.margin = "0px";
     document.body.style.overflow = "hidden";
     this._middle.style.overflow = "auto";
     this.resize(null);
     registerEventHandler(window, 'resize', getInstanceDelegate(this, "resize"));
    }
    function load_XmlDocumentFromElement(Id)
    {
        var hf = document.getElementById(Id);
        if(hf != null)
        {
            var xmldoc = new ActiveXObject("Microsoft.XMLDOM");
            xmldoc.loadXML(hf.value);
            return xmldoc;
        }
        return null;
    }

    function get_NodeAttributeText(root, node_name, attr_name)
    {
        var node = root.selectSingleNode(node_name);
        if(node != null)
            return node.getAttribute(attr_name);
        else
            return null;
    }

    function set_ExcelDisplayMode(sheet)
    {
        sheet.AllowPropertyToolbox = false;
        sheet.DisplayToolbar = true;
        sheet.DisplayOfficeLogo = false;
        sheet.DisplayWorkbookTabs = false;
        sheet.DisplayTitleBar = false;
    }

    function set_ProtectModeForEdit(sheet)
    {
        var protection = sheet.ActiveSheet.Protection;
        protection.AllowInsertingRows = true;
        protection.AllowDeletingRows = true;
        protection.AllowFormattingColumns = true;
        protection.AllowSorting = true;
        protection.Enabled = true;

        sheet.activeWindow.enableResize = false;
    }

5.aspx.cs文件代码如下

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml;
using System.IO;
using System.Text;
public partial class ExcelBrowse : System.Web.UI.Page
{
    private string _Targ_file = "市气象局.xml";
    protected void Page_Load(object sender, EventArgs e)
    {

if (IsPostBack == true)
return;

        //取得Excel内容------------------------------------------
        string file_name = Server.MapPath("Excel/" + _Targ_file);
        XmlDocument xml = new XmlDocument();
        xml.Load(file_name);
        if (xml != null)
            _hf_ExcelXmlData.Value = xml.OuterXml;

        //取得Excel设置------------------------------------------
        XmlNode node = get_ExcelSetting(_Targ_file);
        if (node != null)
            _hf_ExcelSetting.Value = node.OuterXml;
    }
    static public XmlNode get_ExcelSetting(string key)
    {
        string file = HttpContext.Current.Server.MapPath("App_Data/Excels.xml");
        XmlDocument doc = new XmlDocument();
        doc.Load(file);
        //-------------------------------------------------------
        if (doc != null)
        {
            XmlNode root = doc.DocumentElement;
            if (root != null)
            {
                string query = string.Format("sheet[@filename='{0}']", key);
                XmlNode node = root.SelectSingleNode(query);
                if (node != null)
                    return node;
            }
        }