How to import xlsx with preview?

Question

PHP

Good night, you need to make the following functionality:
1) Load a txt, xlsx, csv file and similar formats
2) Show this table in the iframe for preview, if the file is txt, then make this table using separators and display it in the same iframe
3) Select which column goes to which column in the database
Question: how would you implement this? Are there any libraries for working with this format (for preview). Even if there is a preview, how do you select a column and load it into the mysql database?

Answer 1

Reading text files line by line is not a problem, xlsx with no problem will have to be completely read (unpacked) and this is a waste of resources