嗨伙計,
我需要讀取30個Excel文件的數據,我現在的腳本如下圖,383mm有10個文件,533mm有10個文件,683mm有10個文件。 有什麼辦法可以讓我們打開一個“for 循環”類型的腳本,並將打開的 Excel 文件分配給一個數據表? 複製和粘貼 30 次看起來很尷尬。 感謝您的幫助。
dt01 = Open( "E:_383mm_001/FRF.csv" );
dt02 = Open( "E:_383mm_002/FRF.csv" );
dt03 = Open( "E:_383mm_003/FRF.csv" );
dt04 = Open( "E:_383mm_004/FRF.csv" );
dt05 = Open( "E:_383mm_005/FRF.csv" );
dt06 = Open( "E:_383mm_006/FRF.csv" );
dt07 = Open( "E:_383mm_007/FRF.csv" );
dt08 = Open( "E:_383mm_008/FRF.csv" );
dt09 = Open( "E:_383mm_009/FRF.csv" );
dt10 = Open( "E:_383mm_010/FRF.csv" );
dt11 = Open( "E:_533mm_001/FRF.csv" );
dt12 = Open( "E:_533mm_002/FRF.csv" );
dt13 = Open( "E:_533mm_003/FRF.csv" );
dt14 = Open( "E:_533mm_004/FRF.csv" );
dt15 = Open( "E:_533mm_005/FRF.csv" );
dt16 = Open( "E:_533mm_006/FRF.csv" );
dt17 = Open( "E:_533mm_007/FRF.csv" );
dt18 = Open( "E:_533mm_008/FRF.csv" );
dt19 = Open( "E:_533mm_009/FRF.csv" );
dt20 = Open( "E:_533mm_010/FRF.csv" );
dt21 = Open( "E:_683mm_001/FRF.csv" );
dt22 = Open( "E:_683mm_002/FRF.csv" );
dt23 = Open( "E:_683mm_003/FRF.csv" );
dt24 = Open( "E:_683mm_004/FRF.csv" );
dt25 = Open( "E:_683mm_005/FRF.csv" );
dt26 = Open( "E:_683mm_006/FRF.csv" );
dt27 = Open( "E:_683mm_007/FRF.csv" );
dt28 = Open( "E:_683mm_008/FRF.csv" );
dt29 = Open( "E:_683mm_009/FRF.csv" );
dt30 = Open( "E:_683mm_010/FRF.csv" );