data=importdata('data.txt');
xlswrite('data.xls',data);

import numpy as np
import pandas as pd
def getData(path):
 with open(path, 'r') as file:
  data = []
  for line in file.readlines():
   # strip()方法用于移除字符串頭尾指定的字符（默認為空格或換行符）或字符序列
   # split()函數(shù)默認可以按空格分割，并且把結果中的空字符串刪除掉，留下有用信息
   rowline = line.strip().split()
   data.append(rowline)
   #將列表轉為numpy數(shù)組
   temp=np.array(data)
 return temp
def printExcel(data):
 #numpy數(shù)組轉為pandas的DataFrame數(shù)據(jù)
 data_pd=pd.DataFrame(data)
 writer=pd.ExcelWriter('data.xlsx')
 data_pd.to_excel(writer)
 writer.save()
printExcel(getData('data.txt'))

pip install xlrd
pip Install xlwt

import numpy as np
import pandas as pd
import xlrd,xlwt
def getData(path):
 with open(path, 'r') as file:
  data = []
  for line in file.readlines():
   # strip()方法用于移除字符串頭尾指定的字符（默認為空格或換行符）或字符序列
   # split()函數(shù)默認可以按空格分割，并且把結果中的空字符串刪除掉，留下有用信息
   rowline = line.strip().split()
   data.append(rowline)
   #將列表轉為numpy數(shù)組
   temp=np.array(data)
 return temp
def printExcel(data):
 f=xlwt.Workbook() #創(chuàng)建工作簿
 sheet=f.add_sheet('sheet1')
 for i in range(len(data)):
  for j in range(len(data[i])):
   sheet.write(i,j,data[i][j])
 f.save('data1.xls')
printExcel(getData('data.txt'))