How to add all border to the Excel cells

Help
2

@sandhyak9

The possible solutions(to be used based on business scenario) that i could think of are-

  1. Using Template file
  • Create an excel file as template and add all the formatting you want.
  • Add steps in BOT to create a new excel file in the required location as a copy of the template file specified above.
  • Use write range activity to enter data into the file. Write range will write only the data into the files and do not change the original format.
  1. Formatting Excel
  • Open excel file.
  • Do ctrl+a.
  • Got to Home tab and then click the Border > All Borders . See screen shot below
  • Save the file and close
    Capture

Hope this is helpful!
If this resolves your issue, please mark it as solution so that people facing similar issues can directly navigated to answer.