Copy pandas dataframe to excel using openpyxl

by

openpyxl 2.4 comes with a utility for converting Pandas Dataframes into something that openpyxl can work with directly. Code would look a bit like this:

from openpyxl.utils.dataframe import dataframe_to_rows
rows = dataframe_to_rows(df)

for r_idx, row in enumerate(rows, 1):
    for c_idx, value in enumerate(row, 1):
         ws.cell(row=r_idx, column=c_idx, value=value)

You can adjust the start of the enumeration to place the cells where you need them.

See openpyxl documentation for more information.

More Related Contents:

  1. Copying MultiIndex dataframes with pd.read_clipboard?
  2. How are iloc and loc different?
  3. Splitting dataframe into multiple dataframes
  4. Efficient way to unnest (explode) multiple list columns in a pandas DataFrame
  5. How to convert a dataframe to a dictionary
  6. Pandas new column from groupby averages
  7. Pandas: replace substring in string
  8. extract column value based on another column pandas dataframe
  9. Coalesce values from 2 columns into a single column in a pandas dataframe
  10. Finding non-numeric rows in dataframe in pandas?
  11. Pandas: Looking up the list of sheets in an excel file
  12. Factorize a column of strings in pandas
  13. ‘DataFrame’ object has no attribute ‘sort’
  14. How to get the last N rows of a pandas DataFrame?
  15. python pandas – creating a column which keeps a running count of consecutive values
  16. Turn Pandas Multi-Index into column
  17. Normalizing pandas DataFrame rows by their sums
  18. How to merge multiple dataframes
  19. How can I get a value from a cell of a dataframe?
  20. Extract int from string in Pandas
  21. How to add header row to a pandas DataFrame
  22. Plot a bar plot from a Pandas DataFrame
  23. How to drop column according to NAN percentage for dataframe?
  24. Returning multiple values from pandas apply on a DataFrame
  25. Read data (.dat file) with Pandas
  26. Sum columns by level in a pandas MultiIndex DataFrame
  27. Comparing 2 columns of two Python Pandas dataframes and getting the common rows
  28. Python: How to drop a row whose particular column is empty/NaN?
  29. DataFrame object has no attribute append
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment