9951 explained code solutions for 126 technologies


python-scipyHow do I use Python XlsxWriter to write a NumPy array to an Excel file?


Using Python XlsxWriter, you can write a NumPy array to an Excel file. Here is an example of how to do this:

import xlsxwriter
import numpy as np

# Create a workbook and add a worksheet.
workbook = xlsxwriter.Workbook('arrays.xlsx')
worksheet = workbook.add_worksheet()

# Create an array of numbers
data = np.arange(1, 65).reshape(8, 8)

# Write the array to the worksheet.
worksheet.write_array('A1', data)

# Close the workbook.
workbook.close()

This code will create an Excel file named 'arrays.xlsx' with the NumPy array written to it.

The code consists of the following parts:

  1. Importing the xlsxwriter and numpy libraries.
  2. Creating a workbook and worksheet.
  3. Creating an array of numbers using the numpy library.
  4. Writing the array to the worksheet.
  5. Closing the workbook.

Helpful links

Edit this code on GitHub