6c0bc037-60ca-4084-be13-3f2d33269981.jpg

RPA Developer

This activity is very useful. Can we set properties to PDF pages. Eg. Footer, header ,font size etc. ??????

I don't really understand how to upload this package to my uipath studio project?

How to specific the sheet ranges that i want to convert ?

Is there a ways to use a sheet position instead of the name?

using workbook, I can use it like : fichierExcelEnCours.GetSheets(0)

but directly from the Excel, I don't know how to do this with this process.

I'm seeing some odd behavior with this in my use case. In my process, the worksheet has been copied from a template reference file, and then additional data populated in the worksheet by the RPA process. When I pass the file into this activity, the resulting PDF only displays the portions from the original template. However, if I break in debug and inspect the file immediately prior to running, I can confirm that the Excel file does indeed have all of the new info written to it, yet it is still missing from the exported PDF.

It's good work! Thank you for your activity!

I tried to use the latest package however it looks that runs but at the PDF is not being generated

DestinationPath: "c:\Users\myuser\Downloads"

ExcelSourcePath: "c:\Users\myuser\Downloads\Excelfile.xlsx"

Could you please let me know what could I being doing wrongly?

Thanks for the activity. This is working well in development/attended mode but I am getting following error in unattended mode. Could you help here, as we need to move this to production asap

Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.

My excel sheet uses Indirect formula, While using this activity, It is asking me to "Do you want to save the file?" even if I call "Save workbook" just before this activity.

Creo que estoy escribiendo todo bien, sin embargo cada vez que corro el programa, salta este error:

Excel to PDF: No se puede cargar el archivo o ensamblado 'Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' ni una de sus dependencias. El sistema no puede encontrar el archivo especificado.

I get this Error: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.

プロパティのoutputへの書式設定の方法


Excellent library, any idea to format the table, best regards.

Works smoothly and the RemovePageBreak option is cherry on the top...Thanks so much!!!

For example we have an excel file, that runs a macro while opening, it changes any cell.

So when you will gonna close it, the window "do you want to save the file" will appear.

Your activity doesn't deactivate such windows (DisplayAllerts). 

e9232baf-cc02-445d-8adb-4082e34e1268.nupkg

Input:DestinationPath - Type String - Optional :Specifies the absolute path of to store the PDF file. If unspecified, it takes in the path of the Source Excel file and stores the PDF file in that path.ExcelSourcePath - Type String - Mandatory :Specifies the absolute path of the Excel file to be converted.SheetName- Type String - Optional:Specifies the name of the particular sheet to be converted to PDF. If unspecified, the whole workbook is converted to a PDF Document.Output:result- Type boolean - Optional :Returns True if the operation has been carried out successfully, otherwise returns False.

Converts an Excel file to a PDF file by specifying the worksheet name. If the Worksheet name is not specified the whole Workbook is converted to PDF

42c817b7-abf2-49bf-888a-a3e2a99b4c4d.JPG

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Excel to PDF Conversion

Excel to PDF Conversion

Novigo Solutions - Remove PDF File Password…