小福利，Python入门技巧，读取Excel文件转存为TXT文件

小福利，Python入门技巧，读取Excel文件转存为TXT文件

#导入数据
import numpy as np
import pandas as pd

import smtplib
from email.mime.text import MIMEText
from email.header import Header

b=[]
c=" "
# df=pd.DataFrame(pd.read_csv('name.csv',header=1))
df=pd.DataFrame(pd.read_excel(r'D:\abc\123.xls'))
# print(df.head(10))
import pandas as pd
df=pd.DataFrame(pd.read_excel(r'D:\abc\123.xls'))
for i in range(12):
    for j in range(6):
        # print(df.iloc[i, 1])
        # print(df.iloc[i,
        a=df.iloc[i, j]
        b.append(str(a))
    b.append("\n")

    #     print(a)
    # print('这是第%s条数据'%(i+1))
    # print('  ')
c='\n'.join(b)
print(c)
f='2.txt'
with open(f,'x',encoding='utf-8') as file:
    file.write(c)
print(file)