方法'Open'/'Run'的重载没有接受'1'参数 [英] no overload for method 'Open'/'Run' takes '1' arguments

问题描述

我在SSIS中用C#编辑脚本任务时显示了标题，我遇到了这个问题，我尝试了几种在线找到的解决方案，但是没有用.你能找出原因吗?

I met this problem as title showed when I editing script task in C # in SSIS, I tried several solutions found online, but don't work. can you find out why?

using Microsoft.VisualBasic;using System;
using System.IO;using System.Collections;
using System.Collections.Generic;using System.Data;
using System.Diagnostics;using Excel = Microsoft.Office.Interop.Excel;
using Microsoft.SqlServer.Dts.Runtime;

namespace ST_46fccdfebfc844059ab81e95c062c19e.csproj
{
[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
{

    #region VSTA generated code
    enum ScriptResults
    {
        Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
        Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
    };
    #endregion

    public void Main()
    {

        string File_name = "c:\\Documents and Settings\\richard.gui\\Desktop\\ARupload.xlsm";
        string Macro_name = "test";

        Excel.Application ExcelObject = default(Excel.Application);

        Excel.Workbooks oBooks = default(Excel.Workbooks);
        Excel.WorkbookClass oBook = default(Excel.WorkbookClass);

        ExcelObject.Visible = true;

        oBooks = ExcelObject.Workbooks;
        oBook = (Excel.WorkbookClass)oBooks.Open(File_name);

        ExcelObject.Run(Macro_name);

        oBook.Save();
        ExcelObject.Application.Quit();
        ExcelObject.DisplayAlerts = true;

        ExcelObject = null;
        Dts.TaskResult = (int)ScriptResults.Success;
    }
}
}

推荐答案

也许尝试这样的事情:

// C#
Excel.Workbook wb = ThisApplication.Workbooks.Open( 
"C:\\YourPath\\Yourworkbook.xls", 
Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
Type.Missing, Type.Missing);

这篇关于方法'Open'/'Run'的重载没有接受'1'参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！