c# - 如果 Excel 未打开，则无法更新 Excel 文件？

Question

我正在尝试使用 C# 中的 Oledb 和数据集读取和更新 Excel。

无论 Excel 文件是否打开，读取操作都可以正常工作。

仅当文件打开时更新操作才有效但是 如果 Excel 文件未打开，更新操作会出错

Code :
string query2 = "SELECT * FROM [Fixtures Input$A:IP]";
        string qupdate;        
        string conStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("SAE.xls") + ";Mode=ReadWrite;" + "Extended 
Properties=\"Excel 8.0;IMEX=0;HDR=YES;TypeGuessRows=0;ImportMixedTypes=Text\"";
        con = new OleDbConnection(conStr);
        con.Open();
        cmd2 = new OleDbCommand(query2, con);
        adap2 = new OleDbDataAdapter(cmd2);
        ds2 = new DataSet();
        adap2.Fill(ds2, "Fixtures Input");

        #region "DoingRowEmpty"
        for (int i = 1; i <= 10; i++)
        {
            DataRow aaa = ds2.Tables[0].Rows[i];
            aaa.BeginEdit();
            //aaa.ItemArray[2] = "test";
            aaa.EndEdit();
            id = Convert.ToString(i);

            qupdate = "UPDATE [Fixtures Input$] SET [Fixtures] = '', [Fixture Type] = '', [x] = '' , [(R/N)] = '' , [Fixture Quantity] = '' ,"
                      + " [Quantity of Gangs] = '' , [Sensor mount] = '' , [new lamps] = '', [High bay] = '', [burn/year] = '' ,[Ladder] = ''  where [id] = '" + id + "'";

            adap2.UpdateCommand = new OleDbCommand(qupdate, con);

            adap2.Update(ds2.Tables[0]);
}
#endregion

有什么建议吗？

Answer 1

是否有必要在运行程序之前打开 Excel 文件？