Converting HTML file to excel

Help
1

Hi Guys…

I am currently trying to copy content html file and paste it in particular excel sheet …
after workflow gets run the html file will be open, then I have to copy content to excel sheet…

Can anyone guide in this!

2

Try this logic

Main.xaml (11.2 KB)

3

Thenks @farhan94 , its useful …but regarding the excel I need to open existing excel file can I also use Open Excel Scope activity?? cuz I am getting error and isnt open the file

could you help?

4

yes sure. what’s the error?

5

Excel file it opens for 1 sec and closed…
see below the workflow

1
1946×610 16.7 KB

I have after opened file, select sheet 1, paste it then saved

2
21343×458 21.6 KB

6

after opening the excel file, you can add “attach window” to make sure the values are pasted in the excel sheets.

File will be closed immediately after the processs inside excel scope are completed. You can check “autosave” property in properties or pass ctrl+s hotkey to save before closing

1 Like
7

You have to first select the range for pasting. use select range activity before send hot key(ctrl+v)

2 Likes
8

Thanks all its working fine!

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.