Comments by Member 13788610 (Top 4 by date)

This works: ws['B2']=data[1][0]

print(r[0]) # <<< This line
works printing all fruit.

The other lines give errors:

ws.append(data[r][0]) # <<< This line
TypeError: list indices must be integers, not list

ws.append(row[0]) # <<< This line
NameError: name 'row' is not defined

ws.append(r[0]) # <<< This line
File "C:\Python27\lib\site-packages\openpyxl\worksheet\worksheet.py", line 780, in append
self._invalid_row(iterable)
File "C:\Python27\lib\site-packages\openpyxl\worksheet\worksheet.py", line 860, in _invalid_row
type(iterable))
TypeError: Value must be a list, tuple, range or generator, or a dict. Supplied value is <type 'str'>

Answered: https://stackoverflow.com/a/49930895/4539999
line = line.rstrip('\r\n')
# print([line[i:j].strip(' ') for i,j in izip_longest(start, end)])
ws.append([line[i:j].strip(' ') for i,j in izip_longest(start, end)])