Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Execute Insert Query on Excel File as DB
- Execute insert query on an Excel file. - Insert data into an Excel file without open it.
Top Benefits
- Speed up
- Reduce costs
- Fast
Tasks
- Insert data into excel file without open it.
this bot can:
- Execute insert query on an excel file.
- Insert data into an excel file without opening it.
Requirements & Inputs:
v_ExcelFilePath:
- Provide file path
- E.g. C:UserDesktopFile1.xlsx
v_Query:
- Insert Query.
- insert into [Sheet1$] (ID,Fname,Lname) values('4','Magdi','Ramadan')
v_Output:
- Result of insert query output “Success”.