Python Forum
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))
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Matching Data - Help - Dictionary manuel174102 1 357 Feb-02-2024, 04:47 PM
Last Post: deanhystad
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 1,926 Jun-06-2023, 05:49 PM
Last Post: rajeshgk
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,048 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,802 Dec-12-2022, 08:22 PM
Last Post: jh67
  Trying to Get Arduino sensor data over to excel using Python. eh5713 1 1,621 Dec-01-2022, 01:52 PM
Last Post: deanhystad
  Appending a row of data in an MS Excel file azizrasul 3 1,139 Nov-06-2022, 05:17 PM
Last Post: azizrasul
  Moving data from one Excel to another and finding maximum profit azizrasul 7 1,414 Oct-06-2022, 06:13 PM
Last Post: azizrasul
  get data from excel and find max/min Timmy94 1 1,077 Jul-27-2022, 08:23 AM
Last Post: Larz60+
  How to keep columns header on excel without change after export data to excel file? ahmedbarbary 0 1,130 May-03-2022, 05:46 PM
Last Post: ahmedbarbary
  [SOLVED] Concat data from dictionary? Winfried 4 1,666 Mar-30-2022, 02:55 PM
Last Post: Winfried

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020