如何使用C＃windows应用程序打开excel文件 [英] How to open excel file using C# windows application

问题描述

excel表格与c＃windows应用程序完美打开，如果它也有密码保护，但是唯一的错误是它以只读模式打开。当我单独打开它而不是在visual studio中它完全打开。

excel sheet is opening perfectly with c# windows application,event if it has password protection also , but the only error is it opens in "read only mode".when i open it separately not in visual studio it opens perfectly.

using Excel = Microsoft.Office.Interop.Excel;

我尝试过：

What I have tried:

errorProvider1.Dispose();
     string fileExcel;
     fileExcel = @"D:\PROJECT WORK 5-4-2018 DONE AT HOME\6B.xlsx";
     Excel.Application xlapp;
     Excel.Workbook xlworkbook;
     xlapp = new Excel.Application();

     xlworkbook = xlapp.Workbooks.Open(fileExcel, 0, true, 5, "", "", true,Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,"\t", false, false, 0, true, 1, 0);

     xlapp.Visible = true;

推荐答案

你终于明白了，

ya finally got it ,

string fileExcel;
     fileExcel = @"D:\PROJECT WORK 5-4-2018 DONE AT HOME\6B.xlsx";
     Excel.Application xlapp;
     Excel.Workbook xlworkbook;
     xlapp = new Excel.Application();

     xlworkbook = xlapp.Workbooks.Open(fileExcel, 0, false, 5, "", "", true,Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,"\t", false, false, 0, true, 1, 0);

     xlapp.Visible = true;

xlworkboob中的
第三个参数是只读模式我保持为真所以它现在只在读取时显示我保持错误:-) .fifth参数是密码***....

in xlworkboob third argument is read only mode i kept it true so it was showing in read only now i kept false done:-) .fifth argument is password "***"....

关闭它

to close it

System.Diagnostics.Process[] process = System.Diagnostics.Process.GetProcessesByName("Excel");
           foreach (System.Diagnostics.Process p in process)
           {
               if (!string.IsNullOrEmpty(p.ProcessName))
               {
                   try
                   {
                       p.Kill();
                   }
                   catch { }
               }
           }

这篇关于如何使用C＃windows应用程序打开excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！