在同一个应用程序中打开工作簿而不需要第二个应用程序。 [英] Open a workbook in same application without getting a second application.
问题描述
我尝试通过单击自定义菜单中的菜单按钮来打开existend Excel文件作为添加。然后工作簿打开但结果我有两个Excel Windows,一个带有空工作簿我在哪里单击按钮,然后单击我想要的工作簿。
所以,我想得到的是,空工作簿已关闭,而不是新工作簿是打开的。这是我的代码:
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
string strPath = @" C:\ Users \stteb \ Documents \ Ringinguch 2017.xlsx" ;;
  ;   // object misValue = System.Reflection.Missing.Value;
xlApp = Globals.ThisAddIn.Application;
// xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(strPath,
0,false,5,"","",false, Excel.XlPlatform.xlWindows,",",
true,false,0,true,false,false);
xlApp.Visible = true;
Hi Tebbos,
以下是示例
Excel。 工作簿
currentWorkBook;
         currentWorkBook = xlApp.ActiveWorkbook;
       xlApp.ScreenUpdating =
false ;
         xlWorkBook = xlApp.Workbooks.Open(strPath,
0,
false ,5,
"" ,
"" ,
false ,Excel。 XlPlatform 。xlWindows ,
"&qu ot; ,
真 ,
假 ,0,
真 ,
假 ,
假 );
currentWorkBook.Close( false );
xlApp.Visible =
真 ;
xlApp.ScreenUpdating =
真 ;
xlWorkSheet =(Excel。 工作表 )xlWorkBook.Worksheets.get_Item(1);
最好的问候,
特里跨度>
I try to open an existend Excel file by clicking a menu button in a custom made menu as add in. And the workbook gets open but as result I've two Excel Windows, one with the empty workbook where I clicked the button and that one with my wanted workbook. So wha I want to get is, that the empty workbook is closed and instead of it the new one is opend. Here my Code:
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
string strPath= @"C:\Users\stteb\Documents\Ringversuch 2017.xlsx";
//object misValue = System.Reflection.Missing.Value;
xlApp = Globals.ThisAddIn.Application;
//xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(strPath,
0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
xlApp.Visible = true;
Hi Tebbos,
Here is the example
Excel.Workbook currentWorkBook;
currentWorkBook = xlApp.ActiveWorkbook;
xlApp.ScreenUpdating = false;
xlWorkBook = xlApp.Workbooks.Open(strPath,
0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
currentWorkBook.Close(false);
xlApp.Visible = true;
xlApp.ScreenUpdating = true;
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
Best Regards,
Terry
这篇关于在同一个应用程序中打开工作簿而不需要第二个应用程序。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!