#PandasでEXCELのシートをまるごと読みだし、各行ごとに各列で成るリストを生成
import pandas as pd
path_xlsx_read="C:/Users/shienkikou11/Desktop/読込test用.xlsx"
df_read = pd.read_excel(path_xlsx_read, sheet_name='企業名版')
len_df_read = len(df_read)
#print(len_df_read)
df_form=df_read.loc[:, '企業情報表示フォーム']
for i in range(0,len_df_read):
list_str_row = list(map(str, df_read.iloc[i].to_list()))
list_row=[s.replace("\n","。").replace("\r","/").replace("\u2003","").replace(" ","").replace("\u3000","") for s in list_str_row]
print(list_row)
#for j in range(0,len(list_row)):
#print(list_row[j])