Skip to main content

Basic Excel Actions in Power Automate - Part 1 | LazyBots

 


As we all know, excel is an amazing software for managing so many types of data in an organized way. and we can generate reports, filtered data, various data representation etc...

In this Post,

we are demonstrating how we can automate excel using Power automate. this contains the following operations

  • Create an excel
  • Launch excel
  • Read from excel
  • Write data to excel
  • Append data to excel
  • Create and Activate new sheets
  • Find first free column/row from the worksheet
  • Save and close excel

Labels:
Location: India

Comments

Post a Comment

Popular posts from this blog

Convert to PDF using API | Power Automate Desktop

  In this Power Automate Desktop learning series video, we are learning how to convert any kind of documents to PDF using Muhimbi API for document conversion. This video covers: ------------------------------------------------------ 00:00 - Introduction 03:00 - File to base64 string conversion using Powershell script 05:00 - Invoke web service (API call) 09:20 - Create file from Base64 string 10:30 - Output Actions used: Get files in folder Foreach Run Powershell script Trim Get File Path part Invoke web service Convert Json to custom object How to get Muhimbi API Key: Visit Muhimbi website Fill in your details You'll get the API key and other details in your email How to convert file to Base64 string: Visit official microsoft documentation on power shell script. Happy Automation.
Post a Comment
Read more

Captcha solving using Power Automate Desktop | LazyBots

  In this tutorial, we are learning Captcha solving using Power Automate Desktop. This video covers: 2Captcha API Invoke web service action for accessing API Run Powershell script action to convert Captcha image to Base64 string basic web automation actions To create an account on 2captcha, click here  https://2captcha.com?from=6396966 get the API key from the dashboard and start solving captchas. Happy Automation :)
Post a Comment
Read more

Advanced excel operations in Power Automate | LazyBots

  In this tutorial, we are covering advanced excel actions available in power automate desktop Actions covered are: Run Macro Add/delete worksheets Add/delete columns Add/delete rows Copy and paste cells Select cells in an excel The macro used in the is given below, Sub SetMessage() ' ' SetMessage Macro ' ' Keyboard Shortcut: Ctrl+Shift+M '     Range("D2").Select     ActiveCell.FormulaR1C1 = "Success"     Selection.AutoFill Destination:=Range("D2:D6")     Range("D2:D6").Select End Sub  
Post a Comment
Read more