Power Automate Desktop : Module 3 : Excel Automation - 1 (Launch Excel, Read from Excel,Close Excel)

[@thebhaskarjoshi]

I really appreciate your efforts towards teaching new technology

[@LearningTechnologies]

Thank you bhaskar

[@karma40mok]

Thank you for your lectures of power automate. According to these things, I could use RPA easily.

[@LearningTechnologies]

Thank you

[@kancharlasan]

Sir, the explanation was crisp and clear. Really worth learning from you

[@LearningTechnologies]

Thank you sanar

[@sciences-sci]

great video really good, good teaching thank you

[@LearningTechnologies]

Thank you

[@MelwynRodrigues]

Nice explanation! Thank u Ameer, Thank u LT!

[@LearningTechnologies]

Thank you Melwyn

[@FayezEneim]

Great session

[@LearningTechnologies]

Thank you Fayez

[@steadyballer]

Thanks for the tutorial, most helpful. Would like to ask if PAD can also read content from Word document? Can't find this action in PAD. Thanks for the advice.

[@nomoreospf]

Very good. Thank you

[@LearningTechnologies]

Thank you

[@vmohakrish]

Thanks for video . Do you know how to get last row of a column

[@triflemonster]

Thanks for much. Is there a way to open the most recently modified excel file in a folder ? I.e the most recent? Thanks in advance

[@soumibandyopadhyay2110]

I have a csv file, which I use to separate the data into columns and then save it as the same name as csv file, but in .xlsx format. I use the Close Excel function and then Save the document as with Document Format .xlsx and the path , I want it the name of the csv without the extension. Could you suggest how to do it? Thanks in advance,

[@lisam8986]

In step #2 you chose range, can a table be used? If so would that be the third option “from selection”?

[@ambrosedenny]

Clearly Explained, Can you please create a video on Excel file consolidation to a master file.

[@LearningTechnologies]

Thank you. keep learning and keep watching

[@vigneshg9648]

How to filter an excel data and work on the filtered data instead of original data?

[@ariehashimie]

Hi Sir. Good video learning you post for sure. Im new into power automate and with your video gave lot of information especially handling the desktop version of power automate. And perhaps sir will it be possible for you to post on how to handle empty row in excel file. There is no video that close to how to handle it in power automate dekstop. Most of it focus more on web version. Thank you in advance sir.

[@LearningTechnologies]

Thank you

[@rohittembhare6412]

Hello Sir, can we enter a "count of not empty rows" in the property of read from excel action at end row. if yes then please explain how we can "count the not empty rows" in excel and csv both

[@ievaraj6961]

Sir can you are explain hot to log in outlook and download attachments please

[@niranjanbharambe4546]

Hello Sir, Thank you for making it easy for us by your videos. could you pls help me i am stuck in one scenario, i have to read multiple xls file and save it to xlsx..which am abke to do it for a single file by launch excel and close excel . But when i do it for multiple file i used foreach loop to read all the xls and that variable i.e "currentItem" i passed it to close excel document path. the issue is file gets launch, but did not get save it in xlsx format .could you pls advice

[@LearningTechnologies]

Welcome

[@tariqraza5405]

Fantastic Bro, can we play power automate with power query as well..?

[@LearningTechnologies]

Sure let's try

[@analyticsadda6080]

How to make rows and columns dynamic

[@dafysiby6469]

But I have latest version for Power Automate. Where I can get the "Launch Excel" from the "Excel expand"?

[@LearningTechnologies]

its power automate desktop not power automate online

[@lasaventurasdesharonagudel9745]

Hi Learning Technologies, Thanks so much for the video, is very valuable information. Could you please guide me about, How to open different excel files in a folder? For example: I have 5 files in a folder and I need to open one at a time and read de information. I know that i need a loop, but, how to go directly to each file. Thanks

[@LearningTechnologies]

There is one action where you can get the information of files in folder i.e get files in folder. By using that you can get the information kzbin.info/www/bejne/q6isdKqForaCgJY

[@lasaventurasdesharonagudel9745]

@@LearningTechnologies Thanks so much

[@LearningTechnologies]

Welcome Jonathan

[@christophedecrouy3822]

hello, can we connect for a paid consultation, I have issue in my flow with Excel? Thanks

[@twangt]

Hello! Great video! :) Is it possible to maybe make an example of how to use the OCR action, to extract text from an image and output it with searchable text. Could be very useful! :) Thanks

[@LearningTechnologies]

Sure Alexander

[@twangt]

@@LearningTechnologies Great!

[@abeybrams2366]

Hellow Sir Where can we get the excel data?

[@kraken8701]

Here if i modify data in excel after run flow there is not get that data in text file , what to do for this query??

[@avinashsingh6691]

How to make data range dynamic?

[@shashankgaikwad5825]

Any clue?

[@Wardlaw777]

How do i set it to read from a specific sheet with a workbook with multiple sheets?

[@sempaxbolong6259]

Use action set active excel worksheet

[@varungupta7024]

there is also problem with signing in account after clicling on flow

[@varungupta7024]

how to create flow with no triggers option

[@analyticsadda6080]

How can we achieve this in power automate not using power automate desktop

[@LearningTechnologies]

There is connectors for excel online

[@withnuri6388]

Clear

[@OnlyIasReader76]

Can you make all excel activity

[@LearningTechnologies]

Sure

[@OnlyIasReader76]

Could you solve me ,one problem sir

[@OnlyIasReader76]

Please solve it

[@OnlyIasReader76]

Sir, how to convert flow into zip

[@ugochukwunwabu3956]

what if you dont know the last row in the excel and you want it to read everything in the excel?

[@poojalalwani1226]

Can we not use google sheets instead?

[@LearningTechnologies]

Yes. You cannuse pooja

[@anilyadav-rt4sr]

Thanks

[@LearningTechnologies]

Welcome