通过xml来存储数据：

1.ajax页面

private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   string sql = "select USR_NAME,USR_SEX from USR where USR_ID =2";
   DataSet ds = Morrowsoft.DB.DataAccess.dataSet(sql);
   string xmlstr="<?xml version=\"1.0\" encoding=\"gb2312\"?>";
   xmlstr+="<Table ID=\"Table1\">";
   for(int i=0;i<ds.Tables[0].Columns.Count;i++)
   {
    xmlstr+="<"+ds.Tables[0].Columns[i].ColumnName+">";
    xmlstr+=ds.Tables[0].Rows[0][i].ToString();
    xmlstr+="</"+ds.Tables[0].Columns[i].ColumnName+">";
   }
   xmlstr+="</Table>";
   Response.Write(xmlstr);
  }

2.前台页面：

       <script type="text/vbscript" language="vbscript">

function Taod(str)
dim i
for i=0 to Form1.Cell52.GetVarCount-1 '根据ID得到变量名称
Form1.Cell52.EnumVar i,strName,strType '根据变量名称得到变量所指的区域
Form1.Cell52.GetAreaVar strName,col1,row1,col2,row2,sheet '这个通过变量名返回的起始位置和结束的位置
dim xmlvalue
xmlvalue=getxmltext(str,strName)
if not xmlvalue="" then
Form1.Cell52.S col1,row1,0,xmlvalue '这个是给某个单元格赋值的  临时赋了strName
end if
Next   
end function

</script>

<script type="text/javascript" language="javascript">

function getxmltext(xmlstr,nodename)
{
var xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
xmlDoc.loadXML(xmlstr);
var node=xmlDoc.documentElement.selectSingleNode(nodename);


if(node!=null)

return node.text;
else
return "";
}
function Load()
    {
        var cellObj = document.getElementById('Cell52');
        cellObj.Login("LinkReport","","13100104551","6760-1253-0314-6003"); //注册Cell组件  
        var open = cellObj.OpenFile("test.cll","");
        if (open == -1)
        {
         alert('文件不存在');
        //绑定信息
        //report();
        var url = "AjaxData.aspx";
        //Ajax调用 加载数据库数据
        Taod(str);

</script>

<body>

<form>

<OBJECT id="Cell52" style="WIDTH: 936px; HEIGHT: 592px" codeBase="cab/CellWeb5.cab" classid="clsid:3F166327-8030-4881-8BD2-EA25350E574A" VIEWASTEXT>

</OBJECT>

</form>

</body>