Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Dictionary for Excel Data
#1
We use Roster for our team members. I want to use Python to check the team members shift for particular date and check how much of work is done. So I'm trying to get data using Python and organize it:

- Use dictionary to store use name, shift for the particular date (The Roster excel sheet rows and columns

-Then add the efforts to the dictionary later

How can I achieve this? i'm trying to fetch data but somehow not getting the format I want in the dictionary. Could someone help?

In Excel Rows Range (12, 37) in the column (4) has all the names of the team members

In Excel Row (11) and column (5 to 35) has all dates for the particular month

I need to export this data into the dict and find the shift of particular person for particular date and also later need to append the efforts from some other source. How can I do it?

# Give the location of the file 
loc = (get_current_roster())
#print(loc)
  
# To open Workbook 
wb = xlrd.open_workbook(loc) 
sheet = wb.sheet_by_index(0) 
  
# For row 0 and column 0 
print(sheet.cell(29, 4).value)
print(sheet.nrows)
print(sheet.ncols)
#for i in range(12,37): #This cells have the Names in the Excel Sheet  
#    print(sheet.cell_value(i, 4))
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Exporting list with dictionary to Excel veromi22 0 68 Oct-15-2019, 12:54 AM
Last Post: veromi22
  How to import data from database to excel nick123 1 223 Oct-09-2019, 04:39 PM
Last Post: sm51251
  Import data from excel to Teradata steve87bg 3 428 Sep-18-2019, 01:36 PM
Last Post: steve87bg
  Organizing Data in Dictionary Ranjirock 3 185 Aug-27-2019, 02:48 PM
Last Post: Ranjirock
  iterate read data from excel sheet jp2017 1 299 Jun-19-2019, 07:45 PM
Last Post: micseydel
  Python validate excel values data types Useruser00 0 479 Apr-08-2019, 01:29 PM
Last Post: Useruser00
  Nested Dictionary to excel VictoriaE 1 601 Feb-23-2019, 03:26 AM
Last Post: Larz60+
  Data in excel Hass 1 428 Nov-30-2018, 03:59 PM
Last Post: nilamo
  data from excel mida1 0 482 Oct-12-2018, 02:02 PM
Last Post: mida1
  Read data and save in excel parthi1705 0 597 Apr-09-2018, 09:37 AM
Last Post: parthi1705

Forum Jump:


Users browsing this thread: 1 Guest(s)