asp.net中安装使用OWC组件生成&#101xecEL步骤

fp2003/owc11.msi

引用

microsoft office web components 11.0

c:/program files/common files/microsoft shared/web components/11/owc11.dll

安装文件office2003安装光盘/fp2003/owc11.msi
office2003安装光盘/office11/owc11.msi

默认安装完office2003现在不知道以前是不是有了,安装后在studio2005系统中可以找到这个组件

但是asp中仍然不能使用这个组件

'检查组件是否被支持及组件版本的子程序
sub objtest(strobj)
  on error resume next
  isobj=false
  verobj=""
  set testobj=server.createobject (strobj)
  if -2147221005 <> err then  '感谢网友iamfisher的宝贵建议
    isobj = true
    verobj = testobj.version
    if verobj="" or isnull(verobj) then verobj=testobj.about
  end if
  set testobj=nothing
end sub

函数检测失败

 using system;
using system.collections.generic;
using system.componentmodel;
using system.data;
using system.drawing;
using system.text;
using system.windows.forms;
using microsoft.office.interop.owc11;

namespace msowc
{
    public partial class form1 : form
    {
        public form1()
        {
            initializecomponent();
        }

        private void button1_click(object sender, eventargs e)
        {
            microsoft.office.interop.owc11.spreadsheetclass xlsheet =new microsoft.office.interop.owc11.spreadsheetclass();
            //合并单元格
            xlsheet.get_range(xlsheet.cells[1, 1], xlsheet.cells[1, 14]).set_mergecells(true);
            xlsheet.activesheet.cells[1, 1] = "一级帐表";
            //字体加粗
            xlsheet.get_range(xlsheet.cells[1, 1], xlsheet.cells[1, 14]).font.set_bold(true);
            //单元格文本水平居中对齐
            xlsheet.get_range(xlsheet.cells[1, 1], xlsheet.cells[1, 14]).set_horizontalalignment(microsoft.office.interop.owc11.xlhalign.xlhaligncenter);
            //设置字体大小
            xlsheet.get_range(xlsheet.cells[1, 1], xlsheet.cells[1, 14]).font.set_size(14);
            //设置列宽
            xlsheet.get_range(xlsheet.cells[1, 3], xlsheet.cells[1, 3]).set_columnwidth(50);

            //画边框线
            xlsheet.get_range(xlsheet.cells[1, 1], xlsheet.cells[10, 15]).borders.set_linestyle(microsoft.office.interop.owc11.xllinestyle.xlcontinuous);

            //写入数据  (这里可根据需要由ds生成)
            for (int row = 2; row < 10; row++)   //注意写入数据时,必须从第一行开始写excel里没有第"0"行
            {
                for (int i = 0; i < 15; i++)
                {
                    xlsheet.activesheet.cells[row, i + 1] = 123.456;
                }
            }
            try
            {
                string saveexefilename = textbox1.text;
                //将数字格式化为金额(要格式化的单元格内的值必须为数值型)
                xlsheet.get_range(xlsheet.cells[2, 1], xlsheet.cells[10, 15]).set_numberformat("￥#,##0.00");
                xlsheet.export(saveexefilename, microsoft.office.interop.owc11.sheetexportactionenum.ssexportactionnone, microsoft.office.interop.owc11.sheetexportformat.ssexportxmlspreadsheet);
                textbox2.text = "系统输出成功";
            }
            catch
            {

            }

        }

    }
}

原文来自参考http://dev.csdn.net/article/74/74867.shtm 

asp.net中使用owc组件步骤,owc组件安装