import pandas as pd
a = "/Users/abhijitchavan/Desktop/yes/SearchResult1.xls"
tables = pd.read_html(a)
table = tables[0]
print(table)
table.to_excel('/Users/abhijitchavan/Desktop/yes/dd.xlsx')
THE ABOVE CODE WORKES PERFECT, BUT IT CONVERTS ONLY ONE FILE AT A TIME, HOW CAN I INPUT MULTIPLE FILES AND CONVERT THEM AT SAME TIME
(FILE EXTENSION IS .XLS BUT THOSE FILE ARE HTML FILES)
上面的代碼完美運行，但一次只能轉換一個檔案，我如何輸入多個檔案并同時轉換它們
（檔案擴展名為 .XLS，但這些檔案是 HTML 檔案）
uj5u.com熱心網友回復：
import pandas as pd
files = ["/Users/abhijitchavan/Desktop/yes/SearchResult1.xls","/Users/abhijitchavan/Desktop/yes/SearchResult2.xls"]
for i in range(0,len(files)):
a=files[i]
tables = pd.read_html(a)
table = tables[0]
print(table)
table.to_excel('/Users/abhijitchavan/Desktop/yes/dd" str(i) ".xlsx')
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/524477.html