Excel.Application is a library for controlling an Excel application.
Note. Library works only Windows platform.
Examples
Robot Framework
*** Settings ***
Library RPA.Excel.Application
Task Setup Open Application
Task Teardown Quit Application
*** Tasks ***
Manipulate Excel application
Open Workbook workbook.xlsx
Set Active Worksheet sheetname=new stuff
Write To Cells row=1
... column=1
... value=my data
Save Excel
Run Excel Macro
Open Workbook orders_with_macro.xlsm
Run Macro Sheet1.CommandButton1_Click
Export Workbook as PDF
Open Workbook workbook.xlsx
Export as PDF workbook.pdf
Python
from RPA.Excel.Application import Application
app = Application()
app.open_application()
app.open_workbook('workbook.xlsx')
app.set_active_worksheet(sheetname='new stuff')
app.write_to_cells(row=1, column=1, value='new data')
app.save_excel()
app.quit_application()
Importing
Initialize self. See help(type(self)) for accurate signature.