自动化加载步骤。用Python在Excel中创建csv文件

我将这样做。添加 UTF-8 with BOM 文件开头将自动指示excel在 file origin 下拉列表:

import codecs
import pyautogui

from pywinauto.application import Application
from pywinauto.keyboard import SendKeys

from time import sleep

filename = r'C:\path\excel_automation\data1.txt'
global content

def add_utf8_bom(filename):
    with codecs.open(filename, 'r', 'utf-8') as f:
        content = f.read()
    with codecs.open(filename, 'w', 'utf-8') as f2:
        f2.write('\ufeff')
        f2.write(content)

add_utf8_bom(filename)
app = Application().start(r'C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE')
sleep(1)
#SendKeys('^n') #uncomment for excel 2016 or higher
sleep(1)
pyautogui.press('alt')
pyautogui.press('a')
pyautogui.press('f')
pyautogui.press('t')
pyautogui.typewrite(filename)
pyautogui.press('enter')

信用证: https://stackoverflow.com/a/29900075/4551984