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組件安裝