CREATION OF A BOT ‘FILE NAME EXTRACTOR TO EXCEL’ USING SAP BTP PROCESS AUTOMATION

The main objective of this Bot is to list and logs files into excel for recordkeeping.

So here are the steps to make this bot automation. 

In SAP Build lobby click on create option. 

After clicking create option, create object interface will open. We have to create automation, for this we have to select Automation Process and click Next.

Now we have to choose type, whether this automation is process type or automation type.

As you can see there are two options, that are, Process and automation.

Process: We have to choose Process when we need to build a business process to automate a workflow. Process is used in automation sales order, invoice management, approval flows.

Automation: We have to choose Automation when we need to automate any repetitive tasks across application. Automation is used in extracting data from documents, mass updates of data, local file management.

So, as per our bot we have to select Automation option.

           Name: Name Extractor to Excel
           Description: List and logs files into excel for record keeping purpose.
After filling this click on Review. 

Now click on Create

Now click on Create, then click on Automation.

Then we have to configure agent version.

Name: Name Extractor to Excel. Then click on Create.

Now click on setting icon, then click on Dependencies then add option.

Then click on add and then click on Add a Business Process Project Dependency. then add Excel SDK.

Now we will start building our automation by dragging activities from the pannel to the flow.
The activities we have to use for this automation are
                i) Get File Collection
               ii) Open Excel Instances
              iii) Add Workbook
              iv) Set Values (Cells)
               v) Save as Workbook

In get file collection activity, in folder path give the path of the folder which we have to show.
In set values (Cells) activity we have to define the cell ranges for excel sheet
   Values: Coll
In Save as Workbook activity, in file path give the path with the name of the excel sheet where we have to save the list of files in folder.

Save the flow.

Now test the automation.

Conclusion:
This bot will list out the files of a specified folder in an excel worksheet.  

Best Regards,
Smruti Rekha Pradhan

​ The main objective of this Bot is to list and logs files into excel for recordkeeping.So here are the steps to make this bot automation. In SAP Build lobby click on create option. After clicking create option, create object interface will open. We have to create automation, for this we have to select Automation Process and click Next.Now we have to choose type, whether this automation is process type or automation type.As you can see there are two options, that are, Process and automation.Process: We have to choose Process when we need to build a business process to automate a workflow. Process is used in automation sales order, invoice management, approval flows.Automation: We have to choose Automation when we need to automate any repetitive tasks across application. Automation is used in extracting data from documents, mass updates of data, local file management.So, as per our bot we have to select Automation option.            Name: Name Extractor to Excel           Description: List and logs files into excel for record keeping purpose.After filling this click on Review. Now click on CreateNow click on Create, then click on Automation.Then we have to configure agent version.Name: Name Extractor to Excel. Then click on Create.Now click on setting icon, then click on Dependencies then add option.Then click on add and then click on Add a Business Process Project Dependency. then add Excel SDK.Now we will start building our automation by dragging activities from the pannel to the flow.The activities we have to use for this automation are                i) Get File Collection               ii) Open Excel Instances              iii) Add Workbook              iv) Set Values (Cells)               v) Save as WorkbookIn get file collection activity, in folder path give the path of the folder which we have to show.In set values (Cells) activity we have to define the cell ranges for excel sheet   Values: CollIn Save as Workbook activity, in file path give the path with the name of the excel sheet where we have to save the list of files in folder.Save the flow.Now test the automation.Conclusion:This bot will list out the files of a specified folder in an excel worksheet.  Best Regards,Smruti Rekha Pradhan    Read More Technology Blog Posts by Members articles 

#SAP

#SAPTechnologyblog