write array starting from specific column to new workbook using xlwt

Question

I am trying to write an array (data = [][]) to a worksheet I will create using xlwt. My question is can I specify a column to start from? I am planning to use a for loop to iterate through the array retrieving the values row by row starting a new line with each row ex: first row starts at C1, next row starts at C2 etc... I have read the documentation and examples but cannot find a clear way to do this. Any help would be greatly appreciated!

The examples are included in the documentation if one knows where to look... Also typing the first '(' will often give a description of the parameters a method accepts and what they do — Corey
– Corey, Commented Jul 13, 2011 at 14:07

Gerrat · Accepted Answer · 2011-06-21 21:00:13Z

5

Something like:

wb = xlwt.Workbook()
ws = wb.add_sheet('Sheet1')
for r, row in enumerate(data):
    for c, col in enumerate(row):
        ws.write(r, 2 + c, label=col)

answered Jun 21, 2011 at 21:00

Gerrat

29.9k9 gold badges78 silver badges104 bronze badges

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

Collectives™ on Stack Overflow

write array starting from specific column to new workbook using xlwt

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related