I have a question about reading xls files in python then parsing it to sqlDatabase.
The thing is, that the xls file(pricelist) we as a company use are ordered and it's pretty easy to sort that out. The problem comes with xls files from other companies.
(We are a laptop repair/sales company.)
Our Pricelist have names for each col_index and each row_index contain the specs(info) for the laptop
-HP ---------DV6000-----R10 -------bla
The other companies... don't
Theirs would have 3 cols, or more and rows would differ aswell asin
it looks like a freaking news article.... So it comes down to this:
Taking all the pricelists and adding them to our main pricelist, but that would require someone todo that every so day or often... and I need to cancel that from happening.
So the question is, how would I start to parse the pricelists... retrieving all the correct information regarding each laptop, and sorting them into the main database(this part is simple).
Speed is not that important for us, regarding the parsing.
It's just getting the information from the unordered xls files and parsing them to be sorted into one db.
Anyone have any ideas?