Will figure in the front line 13 removed from the line 14 began to read the data F7 - avg such marks don't as long as the back of the data import to excel in one line, more than thousands of TXT and finally into the thousands of rows of data in the excel

CodePudding user response:

Simple solution:
The front line 13 removed, change file extensions to the XLS, again opened by EXCEL.
Of course, you can also use VB to read in the file, and then from 13 began to analyze the data, then wrote the EXCEL file.

CodePudding user response:

Thousands of files, human is too inefficient

CodePudding user response:

1. Cycle read TXT file
2. The whole text file into the variable s
3. Remove the # to the fp1 - data before
4. Read string, marked by - avg cycle between clear numerical symbols, divided these Numbers with the split directly into the array
5. Write excel array
6. Repeat four