Converting Excel File into a Dictionary using xlrd module

from xlrd import open_workbook
import json
import os
os.chdir("d:/2018/mayank")

def parse_xlsx():
    workbook = open_workbook('demo.xlsx')
    sheets = workbook.sheet_names()
    active_sheet = workbook.sheet_by_name(sheets[0])
    num_rows = active_sheet.nrows
    num_cols = active_sheet.ncols
    header = [active_sheet.cell_value(0, cell).lower() for cell in range(num_cols)]
    for row_idx in range(1, num_rows):
        row_cell = [active_sheet.cell_value(row_idx, col_idx) for col_idx in range(num_cols)]
        yield dict(zip(header, row_cell))

for row in parse_xlsx():
    print (row)

Comments

Post a Comment

Popular posts from this blog

Converting Excel File to JSON File using xlrd module

from xlrd import open_workbook import json import os os.chdir("d:/2018/mayank") book = open_workbook('demo.xlsx') sheet = book.sheet_by_index(0) # read header values into the list keys = [sheet.cell(0, col_index).value for col_index in range(sheet.ncols)] print ("keys are", keys) dict_list = [] for row_index in range(1, sheet.nrows):     d = {keys[col_index]: sheet.cell(row_index, col_index).value          for col_index in range(sheet.ncols)}     dict_list.append(d) j = json.dumps(dict_list) with open('data.json', 'w') as f:     f.write(j)
Read more

Using Oracle with Python

Install the module     pip install cx_Oracle Import the module     import cx_Oracle Establish the connection     cn = cx_Oracle.connect('userid/password@servername') #rest commands are same as MySQL
Read more

Using time module

The time module provides the current date and time using time() function The time.time() returns the number of second elapsed from 1/1/1970 12:00 am till current date and time called as ticks >>> import time >>> time.time() 1522211915.914467 We can also convert these ticks into actual date and time using function time.localtime() >>> time.localtime(time.time()) time.struct_time(tm_year=2018, tm_mon=3, tm_mday=28, tm_hour=10, tm_min=10, tm_sec=0, tm_wday=2, tm_yday=87, tm_isdst=0) It returns a structure having different fields for date and time which we can convert into date or time format >>> t=time.localtime(time.time()) >>> currentdate='%02d-%02d-%d' % (t.tm_mday,t.tm_mon,t.tm_year) >>> currentdate '28-03-2018' >>> currenttime='%02d-%02d-%02d' % (t.tm_hour,t.tm_min,t.tm_sec) >>> currenttime '10-12-05' We can also use this structure inside the functions and ...
Read more