Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Excel to PDF automation

NeetuBhatia
Level 2

‎09-06-20 05:57 PM

​Hi, I want to automate Excel file conversion to PDF format, without using any coding.
Can someone please advise on how to do this?

------------------------------
Neetu Bhatia
------------------------------
0 Likes
3 REPLIES 3

Yeswa_Vaibhav_1
Level 6

‎10-06-20 05:58 AM

Hi Neetu,

Just for understanding, Are you asking how to save the Excel file you already had, into PDF format using Blue prism?  OR  Need to save to PDF format first and later trying to do some operations? Could you please elaborate your query.

Regards,

------------------------------
Yeswa Vaibhav Alwar Nerella
Associate Consultant
Capgemini
Asia/Kolkata
------------------------------
0 Likes

NeetuBhatia
Level 2
In response to Yeswa_Vaibhav_1

‎10-06-20 01:20 PM

​Thanks for your time Yeswa.

We have excel workbook, and each sheet within that workbook needs to be re-saved as a PDF file.
The PDF file name should be workbook name + sheet name.

I managed to spy excel spreadsheet options like File-Save As-Browse-C drive-temp folder etc. I thought, so basically how a user will save a file into PDF, I can write a process for a Robot to do it.

But now I wonder how can Robot give file name in the way like workbook name + sheet name for each sheet that it converts. Also when triggering Global Click Centre for each of the above spyed elements, what should be input?

Any thoughts that you can share?

Regards,

------------------------------
Neetu Bhatia
------------------------------
0 Likes

Yeswa_Vaibhav_1
Level 6
In response to NeetuBhatia

‎10-06-20 02:26 PM

Hi Neetu,

You are welcome 

1. You can use 'Get Worksheet Names' Action under MSExcel VBO, to get the the Excel Sheet names to collection. 
    BOT already had the workbook name and now it got sheet names to collection, so it can append it by using Loop stage, so that it can repeat until all sheet names in      Excel got completed. Refer Screenshot.

27556.png
27557.png


2. While you use 'Global click Center' option after spying the Save-As window, no need to pass any input values for them in navigate stage. 

You can ask me in case of any query. This will work.

Regards,

------------------------------
Yeswa Vaibhav Alwar Nerella
Associate Consultant
Capgemini
Asia/Kolkata
------------------------------
0 Likes