Excel 操作 写入资料

Power Automate和其他的RPA软件做比较最大的优势就是和微软的全家桶比较好融合，如果你和我一样未使用过RPA软件那么可以尝试从Power Automate开始

操作教程

复用脚本

Display.InputDialog Title: $'''输入值''' Message: $'''请输入值''' DefaultValue: $'''测试''' InputType: Display.InputType.SingleLine IsTopMost: False UserInput=> UserInput ButtonPressed=> ButtonPressed
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''D:\\测试文档\\测试excel.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: UserInput Column: 1 Row: 1
Excel.SaveExcel.Save Instance: ExcelInstance
Excel.CloseExcel.Close Instance: ExcelInstance
Display.ShowMessageDialog.ShowMessage Title: $'''输入excel成功''' Message: UserInput Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed2

# [ControlRepository][PowerAutomateDesktop]

{
  "ControlRepositorySymbols": [],
  "ImageRepositorySymbol": {
    "Name": "imgrepo",
    "ImportMetadata": {},
    "Repository": "{\r\n  \"Folders\": [],\r\n  \"Images\": [],\r\n  \"Version\": 1\r\n}"
  }
}