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
  Joining Excel data into existing Excel file RemFreeman 0 96 May-08-2020, 04:01 PM
Last Post: RemFreeman
  How can I copy and paste data from text file into an Excel sheet? IrishOrigi 14 572 Mar-19-2020, 07:25 PM
Last Post: Larz60+
  problem coverting string data file to dictionary AKNL 22 746 Mar-10-2020, 01:27 PM
Last Post: AKNL
  Filtering Excel Document Data Based On Numerical Values eddywinch82 30 2,614 Feb-25-2020, 06:08 PM
Last Post: eddywinch82
  Insert data into sql after joining two excel data from python NeerajYadav 2 252 Jan-29-2020, 02:29 PM
Last Post: parthi1705
  How to import data to excel jkessous 4 568 Jan-26-2020, 07:53 PM
Last Post: snippsat
  Comparing data from two Excel sheets Stuart_Houghton 0 237 Jan-19-2020, 02:49 PM
Last Post: Stuart_Houghton
  Read csv file, parse data, and store in a dictionary markellefultz20 4 682 Nov-26-2019, 03:33 PM
Last Post: DeaD_EyE
  [split] Print JSON Dictionary to Excel? venukommu 1 355 Nov-15-2019, 09:33 PM
Last Post: micseydel
  Exporting list with dictionary to Excel veromi22 0 311 Oct-15-2019, 12:54 AM
Last Post: veromi22

Forum Jump:


Users browsing this thread: 1 Guest(s)