怎么样用Excel导入txt文本中的特定数据

excel

1个回答

写回答

小海螺owo

2025-12-08 23:30

+ 关注

excel
excel

excel中,当打开时会自动加载一个名为"logg"的文件夹下所有以.txt为后缀的文件,并将其导入到Sheet1中。以下是一个示例代码:Sub Workbook_Open()Dim folderPath As String, fileExtension As StringfolderPath = "F:logg"fileExtension = "*.txt"Dim file, i, jFor i = 1 To Dir(folderPath & fileExtension, vbNormal)file = folderPath & ii = i + 1ReDim items(1 To 5) As Stringj = 1Do While j

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号