owc spreadsheet问题

如何取得当前spreadsheet中单元格的值

解决方案 »

  1.   

    补充一下:
    owc控件
    后台:
    using System;
    using System.Data;
    using System.Configuration;
    using System.Collections;
    using System.Web;
    using System.Web.Security;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Web.UI.WebControls.WebParts;
    using System.Web.UI.HtmlControls;
    using System.IO;public partial class ReportForms_Templet : System.Web.UI.Page
    {
        OWC11.SpreadsheetClass sheet = new OWC11.SpreadsheetClass();
        
        public string FileName = string.Empty;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ShowSheet();
            }
        }
        protected void Btn_Save_Click(object sender, EventArgs e)
        {             
            string c = sheet.ActiveSheet.Cells.get_Item(1, 1).Text.ToString();
        }
    #region //自定义方法
        private void ShowSheet()
        {
            sheet.ActiveCell[2, 1] = "aaa";
            sheet.ActiveSheet.Cells[2, 2] = "bbbb";
            FileName = Server.MapPath("~") + "\\Temp.html";
            if (File.Exists(FileName))
            {
                File.Delete(FileName);
            }
            sheet.Export(FileName, OWC11.SheetExportActionEnum.ssExportActionNone, OWC11.SheetExportFormat.ssExportHTML);
        }
    #endregion
    }前台:<body>
        <form id="form1" runat="server">
        <div>
          <table width="800px"  class="Table_Main">
            <tr>
              <td width="10%" valign="top">
                  &nbsp;</td>
              <td valign="top">
                <object classid="clsid:0002E559-0000-0000-C000-000000000046" width="100%" id="Spreadsheet1" height="200" align ="middle">
                <param name="HTMLURL" value="<%=FileName%>"/>
                </object>
              </td>
            </tr>
            <tr>
             <td colspan="2" align="center">
                 <asp:Button ID="Btn_Save" runat="server" OnClick="Btn_Save_Click" Text="保  存" />
                 <asp:Button ID="Btn_Cancel" runat="server" Text="取  消" /></td>
            </tr>
          </table>
        </div>
        </form>
    </body>
    </html>
    怎样取得控件里单元格的值
      

  2.   

    private void ShowSheet()
        {
            sheet.ActiveCell[2, 1] = "aaa";  // string cellVal = sheet.ActiveCell[2, 1];不就是获得单元格的值吗？
            sheet.ActiveSheet.Cells[2, 2] = "bbbb";
            FileName = Server.MapPath("~") + "\\Temp.html";
            if (File.Exists(FileName))
            {
                File.Delete(FileName);
            }
            sheet.Export(FileName, OWC11.SheetExportActionEnum.ssExportActionNone, OWC11.SheetExportFormat.ssExportHTML);
        }