一批空格分隔的文本转成 xlsx
【问题】
I am trying to read data from text file (which is output given by Tesseract OCR) and save the same in excel file. The problem i am facing here is the text files are in space separated format, and there are multiple files. Now i need to read all the files and save the same in excel sheet. I am using MATLAB to import and export data. I even thought of using python to convert the files into CSV format so that i can easily import the same in MATLAB and simply excelwrite the same. But no good solution. Any guidance would be of great help.
thank you
【回答】
这个问题用SPL处理要比MATLAB简单些:
A |
|
1 |
=directory@p("D:\\files\\*.txt") |
2 |
=A1.(file(~).import(;," ")) |
3 |
=A2.(file("D:\\" /#/ ".xlsx").xlsexport (~)) |
A1:列出目录D:\\files\\下的所有文本文件。
A2:读取这些文本文件的内容。
A3:将文本文件内容分别写到xlsx。
也可以指定不同目录下的文件,或以同名文件输出到xls,可命令行调用或集成使用。