Nov-28-2018, 04:27 AM
(Nov-27-2018, 02:42 PM)thatIsTheCase Wrote: What method are you using to read xlsx file? What SQL db are you going to? Give some more details or show code please. I am wrapping up an excel automation project so it is fresh (in-head).
As i mentioned, reading the file is done.I have used following packages(at the moment)
Excel package used - Openpyxl
Database - As now i am thinking of Sqlite3(Advise me better options ,if any)
Task pending at my end is to read cells and send them into database via insert statements.I need to know the technical approach to accomplish that.