Question

Build a bot to create a excel file with records

  • 11 April 2024
  • 2 replies
  • 34 views

Badge +1

I want to build a bot that will create a excel file with records. How can I do that? What is the package I will use?


2 replies

Badge +6

Use Excel advance Package.

  1.  Use create file option to create Excel file eg; Sample.xlsx
  2. then Open that Excel file  using Open Excel command option
  3. loop the records to assign to excel file 
  4. use counter variable to to auto increment 
 
Badge +1

How do I loop the records to assign to excel and use counter variable to auto increment?

Reply