S
S
soloukhin2015-10-21 16:18:57
PHP
soloukhin, 2015-10-21 16:18:57

Excel document to MySql database with specific selection and parameters?

Is it possible to do something so that the admin could upload an excel file to the site, it was automatically processed and different columns / lines of the document were sent to different users depending on the name of the first line, for example?
Is it better that they go to the database?
Can certain rows/columns be sent to different databases?
Is it possible to work with excel files or is it better with CSV?
I have never dealt with excel processing because there are so many questions

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Max, 2015-10-21
@MaxDukov

xls2csv, then LOAD DATA INFILE to MySQL, and then do whatever you want with them.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question