如何优化打开和关闭excel工作簿以提取数据以更快地运行?

I currently know of two methods to open and close excel workbooks to extract data from them to summarize in a single workbook.I currently know of two methods to open and clo