85262_zh-TW

liliconcom

如何在循環中打開私有數據表

所有，
我有一個相當簡單的問題。我的理解是，當您將數據表打開為私有時，如果不保留數據表名稱的引用，則會丟失表。那麼，如何保留數據表，尤其是當您將它們作為循環的一部分打開時。例如： 

 

FilePath = "C:\Test.xlsx"; 

SheetsList = Get Excel Worksheets(FilePath); 
OpenDts = {}; 

for(i = 1, i <= N Items(SheetsList), i++,
  dt = Open(FilePath,
     "Private",
     Worksheets(SheetsList[i]),
     Use for all sheets( 0 ),
     Concatenate Worksheets( 0 ),
     Create Concatenation Column( 0 ),
     Worksheet Settings(1,
          Has Column Headers( 1 ),
          Number of Rows in Headers( 1 ),
          Headers Start on Row( 1 ),
          Data Starts on Row( 2 ),
          Data Starts on Column( 1 ),
          Data Ends on Row( 0 ),
          Data Ends on Column( 0 ),
          Replicated Spanned Rows( 1 ),
          Replicated Spanned Headers( 0 ),
          Suppress Hidden Rows( 1 ),
          Suppress Hidden Columns( 1 ),
          Suppress Empty Columns( 1 ),
          Treat as Hierarchy( 0 ),
          Multiple Series Stack( 0 ),
          Import Cell Colors( 0 ),
          Limit Column Detect( 0 ),
          Column Separator String( "-" )
           )
     );
  Insert Into(OpenDts,"Data Table(" || SheetsList[i] || ")"); 
   );
Show(SheetsList); 
Show(OpenDts); 
<BR />// This fails 
for(i = 1, i <= N Items(OpenDts), i++, 
  OpenDts[i] << Show Window(1); 
   ); 

Re：如何在循環中打開私有數據表

@Jeff_Perkinson ，
你知道嗎，我看到了錯誤，而不是使用window命令，我應該創建一個新的數據視圖，因為它是一個私有數據表。 

FilePath = "C:\Test.xlsx"; 
SheetsList = Get Excel Worksheets(FilePath); 
OpenDts = {}; 

for(i = 1, i <= N Items(SheetsList), i++,
  OpenDts[i] = Open(FilePath,
     "Private",
     Worksheets(SheetsList[i]),
     Use for all sheets( 1 ),
     Concatenate Worksheets( 0 ),
     Create Concatenation Column( 0 ),
     Worksheet Settings(1,
          Has Column Headers( 1 ),
          Number of Rows in Headers( 1 ),
          Headers Start on Row( 1 ),
          Data Starts on Row( 2 ),
          Data Starts on Column( 1 ),
          Data Ends on Row( 0 ),
          Data Ends on Column( 0 ),
          Replicated Spanned Rows( 1 ),
          Replicated Spanned Headers( 0 ),
          Suppress Hidden Rows( 1 ),
          Suppress Hidden Columns( 1 ),
          Suppress Empty Columns( 1 ),
          Treat as Hierarchy( 0 ),
          Multiple Series Stack( 0 ),
          Import Cell Colors( 0 ),
          Limit Column Detect( 0 ),
          Column Separator String( "-" )
           )
     );
//  Insert Into(OpenDts,"Data Table(" || SheetsList[i] || ")"); 
   );
Show(SheetsList); 
Show(OpenDts); 
// This works
for(i = 1, i <= N Items(OpenDts), i++, 
  OpenDts[i] << New Data View; 
   ); 

Re：如何在循環中打開私有數據表

@Jeff_Perkinson ， 

       它仍然失敗。  我使用了確切的腳本，我確實看到數據表引用存儲在列表中。但是，當我試圖讓它們可見時，仍然會失敗。

Re：如何在循環中打開私有數據表

為了澄清，您不需要嘗試插入不同的列表（您的“OpenDTS”）。使用Open（）語句左側的列表代替“dt”。

 

FilePath = "~/Desktop/Test.xlsx"; 

SheetsList = Get Excel Worksheets(FilePath); 
OpenDts = {}; 

for(i = 1, i <= N Items(SheetsList), i++,
  OpenDts[i] = Open(FilePath,
     "Private",
     Worksheets(SheetsList[i]),
     Use for all sheets( 1 ),
     Concatenate Worksheets( 0 ),
     Create Concatenation Column( 0 ),
     Worksheet Settings(1,
          Has Column Headers( 1 ),
          Number of Rows in Headers( 1 ),
          Headers Start on Row( 1 ),
          Data Starts on Row( 2 ),
          Data Starts on Column( 1 ),
          Data Ends on Row( 0 ),
          Data Ends on Column( 0 ),
          Replicated Spanned Rows( 1 ),
          Replicated Spanned Headers( 0 ),
          Suppress Hidden Rows( 1 ),
          Suppress Hidden Columns( 1 ),
          Suppress Empty Columns( 1 ),
          Treat as Hierarchy( 0 ),
          Multiple Series Stack( 0 ),
          Import Cell Colors( 0 ),
          Limit Column Detect( 0 ),
          Column Separator String( "-" )
           )
     );
//  Insert Into(OpenDts,"Data Table(" || SheetsList[i] || ")"); 
   );
Show(SheetsList); 
Show(OpenDts); 
// This fails 
for(i = 1, i <= N Items(OpenDts), i++, 
  OpenDts[i] << Show Window(1); 
   ); 

Re：如何在循環中打開私有數據表您需要將數據表引用存儲在列表中，而不是重用dt變量。