excel to list, list to excel

xlsxwriter_pandas_read.py--------------------

import openpyxl
filename = "pandas_simple.xlsx"
book = openpyxl.load_workbook(filename)
sheet=book.worksheets[0]
data = []
for row in sheet.rows:
    data.append([
                    row[0].value, #1열 데이터
                    # row[1].value, #2열 데이터
                    # row[2].value, #3열 데이터
                    # row[3].value, #4열 데이터
                    # row[4].value, #5열 데이터
                    # row[5].value  #6열 데이터
                ])
datas = []
for d in data:
    datas += d
friend_list = datas[1:]
print(friend_list)

====================

xlsxwriter_pandas_save.py--------------------

import pandas as pd
# Create a Pandas dataframe from the data.
# df = pd.DataFrame({'이름': ["밀", "헴", "스", "다"]})
fried_list = ["밀", "헴", "스", "다"]
columns_name = ['이름']
df = pd.DataFrame(fried_list, columns=columns_name)
# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')
# Convert the dataframe to an XlsxWriter Excel object.
df.to_excel(writer, sheet_name='Sheet1', index=False)
# Close the Pandas Excel writer and output the Excel file.
writer.save()

====================

pyexcelerate_read.py--------------------

import pandas as pd
# 엑셀파일을 list로 불러오기
df = pd.read_excel("pyexcelerate_excel.xlsx", header=None)
df_list = [l[0] for l in df.values]
print(df_list)

====================

pyexcelerate_save.py--------------------

from datetime import datetime
from pyexcelerate import Workbook
list = ['밀','헴','스','다']
# data = []
# for l in list:
#     data.append([l])
# data = [['밀'], ['헴'], ['스'], ['다']] # data is a 2D array
data = [[l] for l in list]
wb = Workbook()
wb.new_sheet("sheet name", data=data)
wb.save("pyexcelerate_excel.xlsx")