using xlwt writing data into the excel but in this code not properly inserting into the column

Question

import xlwt
wbk = xlwt.Workbook()
sheet = wbk.add_sheet('python')
row = 0
f = open('newfile.txt')
for line in f:
L = line.strip().split()
for i,c in enumerate(L):
    sheet.write(row,i,c)
    row += 1
    wbk.save('examp1.xls')

in this code it is inserted into columns but each column gets iterating not in the same row

What is your question? Can you please show example of what is in newfile.txt and what you are getting? and what you expected? — Anand S Kumar
– Anand S Kumar, Commented Aug 13, 2015 at 3:59

e4c5 · Accepted Answer · 2015-08-13 04:54:41Z

1

Remember that python is a language in which code blocks are defined by the indentation level. If you want to put each field from a CSV into a separate column in a spreadsheet, the second loop should be an inner loop of the first. Unless I am very much mistaken you don't want to save the file after every operation. That would cause a massive slow down.

import xlwt
wbk = xlwt.Workbook()
sheet = wbk.add_sheet('python')
row = 0
f = open('newfile.txt')
for line in f:
   L = line.strip().split()
   for i,c in enumerate(L):
       sheet.write(row,i,c)
       row += 1

wbk.save('examp1.xls')

edited Aug 13, 2015 at 4:54

answered Aug 13, 2015 at 4:38

e4c5

53.9k11 gold badges110 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

using xlwt writing data into the excel but in this code not properly inserting into the column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related