write 1D numpy array to excel using xlsxwriter

Question

For example, I have the following code where I am trying to write array a to excel file

a = array([1, 2, 3])
write_excel(a)

The function that I wrote is as follow:

def write_excel(numpy_array):
    workbook = xlsxwriter.Workbook('C:\\Users\\GTS\\Desktop\\Network \\rel.xlsx')
    worksheet = workbook.add_worksheet()

    for row, data in enumerate(numpy_array):
        worksheet.write_row(row, data)

    workbook.close()

I received the following error:

Traceback (most recent call last):
  File "C:/Users/GTS/PycharmProjects/Rel1/Rel1.py", line 18, in <module>
    write_excel(a)
  File "C:\Users\GTS\PycharmProjects\Rel1", line 346, in write_excel
    worksheet.write_row(row, data)
  File "C:\Users\GTS\PycharmProjects\Rel1\venv\lib\site-packages\xlsxwriter\worksheet.py", line 69, in cell_wrapper
    return method(self, *args, **kwargs)
TypeError: write_row() missing 1 required positional argument: 'data'

You could take some help from pandas, stackoverflow.com/a/41875701/4985099 — sushanth
– sushanth, Commented Aug 15, 2020 at 11:40

Community · Accepted Answer · 2020-08-15 18:22:18Z

0

You can call write_row() directly with a numpy array. Like this:

def write_excel(numpy_array):
    workbook = xlsxwriter.Workbook('test.xlsx')
    worksheet = workbook.add_worksheet()

    worksheet.write_row(0, 0, numpy_array)

    workbook.close()

edited Aug 15, 2020 at 18:22

CommunityBot

11 silver badge

answered Aug 15, 2020 at 16:56

jmcnamara

42.1k7 gold badges98 silver badges114 bronze badges

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

Comments

Girish Hegde · Accepted Answer · 2020-08-15 11:08:53Z

0

write_row function takes arguments in the form of (row, col, data). So use worksheet.write_row(row, 0, data) instead.

answered Aug 15, 2020 at 11:08

Girish Hegde

1,5238 silver badges16 bronze badges

1 Comment

MathPro Over a year ago

thank you, but I still received the following error: line 69, in cell_wrapper return method(self, *args, **kwargs) line 1132, in write_row for token in data: TypeError: 'numpy.int32' object is not iterable

MathPro · Accepted Answer · 2020-08-15 12:01:26Z

0

I wrote this function instead it works very well

def write_excel_one(numpy_array):
    workbook = xlsxwriter.Workbook('C:\\Users\\GTS\\Desktop\\Network Interdiction Problem\\Manuscript\\rel.xlsx')
    worksheet = workbook.add_worksheet()

    for row, data in enumerate(numpy_array):
        # worksheet.write_row(row, 0, data)
        worksheet.write_number(0, row, data)
    workbook.close()

answered Aug 15, 2020 at 12:01

MathPro

191 silver badge6 bronze badges

Collectives™ on Stack Overflow

write 1D numpy array to excel using xlsxwriter

3 Answers 3

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Linked

Related