Database / dictionary - export to excel sheet

This is the place for queries that don't fit in any of the other categories.

Database / dictionary - export to excel sheet

Postby theRandy » Tue Oct 29, 2013 10:07 pm

Not really sure how i would go about making what i want to make so i need some pointers in the right direction.

I want to make a script to save me some time at work, what i want to do have a sort of database or dictionary that holds:

Case number - primary key
Type - Refund, Replacement, Refurbishment etc
Unit - phone, tablet, chair etc
date - self explanatory
Price - Price of unit

I want to be able to tell python to print out the total refunds for a given date range, look up a specific case number and have it print all the information above etc.
I would also like to have it export all this information to an excel sheet.
As i said i don't know where to start with this or how deep my knowledge of python would need to be to accomplish this, any help on this would be much appreciated thankyou.
theRandy
 
Posts: 1
Joined: Tue Oct 29, 2013 9:56 pm

Re: Database / dictionary - export to excel sheet

Postby rrashkin » Fri Nov 01, 2013 12:30 pm

Take a look at the SQLITE3 database interface. SQL can be a little daunting but you only need to use a few basic commands.
___________________
Bob Rashkin
User avatar
rrashkin
 
Posts: 35
Joined: Tue Feb 12, 2013 4:47 pm


Return to General Coding Help

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], W3C [Linkcheck] and 4 guests