C#创建并传数据至excel中，提示：无法保存，文件属性为只读模式

Question

        private void CreateExcelFile(string FileName)
        {
            //create
            object Nothing = System.Reflection.Missing.Value;
            var app = new Excel.Application();
            app.Visible = false;
            Excel.Workbook workBook = app.Workbooks.Add(Nothing);
            Excel.Worksheet worksheet = (Excel.Worksheet)workBook.Sheets[1];
            worksheet.Name = "Work";
            //headline
            worksheet.Cells[1, 1] = "FileName";
            worksheet.Cells[1, 2] = "FindString";
            worksheet.Cells[1, 3] = "ReplaceString";

            worksheet.SaveAs(FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode./*xlNoChange*/xlExclusive, Type.Missing, Type.Missing, Type.Missing);
            workBook.Close(false, Type.Missing, Type.Missing);
            app.Quit();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            string[] abc = new string[1000];
            for (int i = 0; i < 1000; i++)
            {
                abc[i] = i.ToString();
            }
            WriteToExcel("哈哈哈哈哈", abc);
        }

        private void WriteToExcel(string excelName, string[] abc)
        {
            //open
            object Nothing = System.Reflection.Missing.Value;
            var app = new Excel.Application();
            
            app.Visible = false;
            Excel.Workbook mybook = app.Workbooks.Open(excelName, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing);
            Excel.Worksheet mysheet = (Excel.Worksheet)mybook.Worksheets[1];
            mysheet.Activate();
            //get activate sheet max row count
            int maxrow = mysheet.UsedRange.Rows.Count + 1;
            for (int i = 1; i < 1000; i++)
            {
                mysheet.Cells[maxrow, i] = abc[i].ToString();
            }
            mybook.Save();
            mybook.Close(false, Type.Missing, Type.Missing);
            mybook = null;
            app.Quit();
        }

程序里在哪里设置为只读了？怎么改成可写?

Answer 1

只读的情况，查看任务管理器 Excel.exe,杀了即可，不建议使用微软的office组件 ，考虑下 npoi ？