What is the best tool to parse xls, csv, txt files?

Question

Parsing

Hey! There is such a task: about 10 tables in various formats (prices), one of them needs to be compiled in xls format. Moreover, it should be possible to select prices and delete any positions if they match. The program should work on windows 7. Please tell me what is the best tool to use? There was an idea to write in php to perform such a task online, but it seems to me that this would not be very good. Suggested awk+.bat or .vbs scripts, but need an interface. Thank you!

Answer 1

You can do everything in PHP. CSV is essentially the same txt. You read the file into a variable (you can, for example, use the file () function, then there will immediately be an array of strings), and then iterate over this array of strings through foreach. Each string can also be split into fields: explode("field_separator", $string); As for xls, you can not bother and convert it to csv through Excel, for example, and then I have already written.