Re: Creating dictionary of items from Excel with mutliple keys

2016-08-14 Thread Peter Otten
Atri Mahapatra wrote: > I am trying to create a following dictionary. I am reading data from excel > which has data in the following format: > > Sl no: Name Thickness Length Material Width Quantity Side > > It has 20 rows of data. > > > The dictionary for the 20 rows, I would like to make is

Re: Creating dictionary of items from Excel with mutliple keys

2016-08-13 Thread Lawrence D’Oliveiro
On Sunday, August 14, 2016 at 6:43:54 AM UTC+12, Michael Selik wrote: > Rather than using xlrd or other tools to read from excel, can you save the > file as CSV (comma-separated values)? I think you'll find Python's csv > module is very pleasant to use. Trying to use Python as a substitute for VBA

Re: Creating dictionary of items from Excel with mutliple keys

2016-08-13 Thread Michael Selik
On Sat, Aug 13, 2016 at 12:46 PM Atri Mahapatra wrote: > I am trying to create a following dictionary. I am reading data from excel > Rather than using xlrd or other tools to read from excel, can you save the file as CSV (comma-separated values)? I think you'll find Python's csv module is very p

Creating dictionary of items from Excel with mutliple keys

2016-08-13 Thread Atri Mahapatra
I am trying to create a following dictionary. I am reading data from excel which has data in the following format: Sl no: Name Thickness Length Material Width Quantity Side It has 20 rows of data. The dictionary for the 20 rows, I would like to make is Data_Dict = [ { 'Name': 'X', 'Length