How to Write Python array into a Single Excel Spread Sheet Cell

Question

I am trying to write following array into an Excel spreadsheet cell using Python:

array = [ [a1,a2,a3], [a4,a5,a6], [a7,a8,a9], [a10, a11, a12, a13, a14]]

this is the code I am using right now:

import xlsxwriter

workbook = xlsxwriter.Workbook('arrays.xlsx')
worksheet = workbook.add_worksheet()

array = [['a1', 'a2', 'a3'],
         ['a4', 'a5', 'a6'],
         ['a7', 'a8', 'a9'],
         ['a10', 'a11', 'a12', 'a13', 'a14']]

row = 0

for col, data in enumerate(array):
    worksheet.write_column(row, col, data)

workbook.close()

This is the Output I am getting:

I want it to print it like this:

User863 · Accepted Answer · 2021-07-09 12:43:31Z

1

Using join() and set_text_wrap()

https://xlsxwriter.readthedocs.io/workbook.html#workbook-add-format https://xlsxwriter.readthedocs.io/format.html#set_text_wrap

import xlsxwriter

workbook = xlsxwriter.Workbook('arrays.xlsx')
worksheet = workbook.add_worksheet()

cell_format = workbook.add_format()
cell_format.set_text_wrap()
cell_format.set_align('vcenter')

array = [['a1', 'a2', 'a3'],
         ['a4', 'a5', 'a6'],
         ['a7', 'a8', 'a9'],
         ['a10', 'a11', 'a12', 'a13', 'a14']]

row = 0

for col, data in enumerate(array):
    worksheet.write(row, col, '\n'.join(data), cell_format)

workbook.close()

answered Jul 9, 2021 at 12:43

User863

20.1k3 gold badges20 silver badges45 bronze badges

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

2 Comments

SAI ANURAG DODDI Over a year ago

thank you @User863 if u dont mind what can i do to make the list print from the beginning in the cell

User863 Over a year ago

remove the line set_align('vcenter')

gifuzzz · Accepted Answer · 2021-07-09 12:27:04Z

0

I think you should use a "\n" to store them all in a single cell.

Try to put something like this:

array = ['\n'.join(i) for i in array]

answered Jul 9, 2021 at 12:27

gifuzzz

11 bronze badge

Collectives™ on Stack Overflow

How to Write Python array into a Single Excel Spread Sheet Cell

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related