Breaking News: Grepper is joining You.com. Read the official announcement!

create excel file python

Intempestive Al Dente answered on July 23, 2021 Popularity 10/10 Helpfulness 4/10

answer create excel file python

related save excel python

create excel file python

Comment

#import openpyxl  # Must be as least installed, import is optional
import pandas as pd
import numpy as np
# Create dataframe with your data; 
df = pd.DataFrame(np.array([[23, 99, 78], [65, 95, 90], [90, 98, 96]]), columns=['Bob', 'Dilan', 'Live'])
df
   Bob  Dilan  Live
0   23     99    78
1   65     95    90
2   90     98    96
# Export the dataframe as Excel File
# sheet_name="Your Sheet Name" is optionnal
df.to_excel(r'C:\Users\Ron\Desktop\File_Name.xlsx', sheet_name="Your Sheet Name" ,index = False)

Popularity 10/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: excel file python

Link to this answer
Share Copy Link

Contributed on Jul 23 2021

Intempestive Al Dente

0 Answers Avg Quality 2/10

Closely Related Answers

save excel python

Comment

# Save single dataframe to a single sheet
df.to_excel(excel_writer= 'file_name.xls',sheet_name='sheet_1',
            startrow=1, startcol=1) # These are optional args

# Alternative approach : use context manager
# Save multiple dataframes in different sheets
df_list = [df1,df2,df3]
sheet_list = ['sheetA','sheetB','sheetC']

for df, sheet in zip(df_list,sheet_list):
	with pd.ExcelWriter('file_name.xlsx') as writer:
  		df.to_excel(excel_writer=writer, sheet_name=sheet)

Popularity 9/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Jan 24 2024

Innocent Iguana

0 Answers Avg Quality 2/10

create excel file python

Contents

More Related Answers

create excel file python

Closely Related Answers

save excel python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.