About read excel to web application blogger.com

Help Community
1

Hi All,

I am new to UiPath. I need a help to my project are read excel data, then post to blogger.com with select date
I have already create a uipath file to create the excel data(let me know if you need the uipath file or excel file)
the post date I guess I should create a other excel, let me know if Im wrong.
Each excel sheet contain 1 post content
The question is how to post that excel content to blogger.com with select date
each sheet for 1 post only post title name would be the sheet name
Thanks you so much

2

First question is where are the selected dates stored etc for you to publish?

For the automation itself, you could

Use Excel Activities: (https://docs.uipath.com/activities/docs/about-the-excel-activities-pack)

You can loop through the worksheets on your excel file and grab the sheet name for title.

You would then add the details i.e. title and content into the queue items as specific data.

The steps on blogger.com would be the same as you would do manually -

  • Open Blogger.com and login
  • Click NewPost button
  • Enter in relevant details to body
  • Add any labels
  • Click Publish
  • Close window