how to convert csv file to pdf fie and what of extension manager pakages
for this you need to use dotnet code there is no build in uipath activits for this.
check this link : https://www.syncfusion.com/kb/9618/how-to-convert-csv-to-pdf-table-using-c-and-vb-net
Here below I have mentioned 2 activities. First will convert the csv to Excel . Next one you can easily convert to the excel to pdf.
Convert the csv to Excel
Excel to Pdf
RemoteException wrapping System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC
at BalaReva.CamiCat.CsvExcel.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance,
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor,
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor,
I saw you csv file . It has delimiter as comma you have change it as below.
Here I have attached 2 workflows. 1st is simple conversion. 2nd one did the conversion after removed the double quotes.
Vishnumurthy.zip (28.5 KB)
I have done activity to convert the excel to pdf. I have uploaded the activity in UiPath Go. Waiting for the publishment.
Sorry for the delay msg man. Today the UiPath Go published the component. you can get it. now
here is the sample : Vishnumurthy.zip (63.8 KB)
Thanks to sir for positive response my quires…
You are supporting lot to complete my job.
Request:How to count rows/columns in Excel file and the count will reflect in Email body and file attached for reference.
S.No PASS TYPE TOTAL COUNT
1 Person 2359
2 Vehicle 336
3 Equipment (1 & 2) 465
Thanks.PERMIT ISSUED REPORT FROM 20 OCT 6AM TO 21 OCT 6AM.zip (221.6 KB)
to help you with the count rows/columns in a excel spreadsheet,
I usually use python, the"openpyxl" library is very useful.
Download the python methods.
eg = ‘c:\users\igor\desktop’
wb = openpyxl.load_workbook(‘YOUR SPREADSHEET NAME.xlsx’)
sheet = wb.get_sheet_by_name(‘sheet1’)
x = sheet.max_pow
save the return and manipulate the way you need to input in your email body
I don’t no python language sir .please send sample exam and already i will send file previous message…
Sorry for my late reply. Here is the solution . I just rename column name “S.No.” to “Sno”. I have used the BalaReva.Datatable.Activities.
Vishnumurthy.zip (288.7 KB)
Follow the guidelines discussed in this article to export CSV file contacts into PDF file format within a few simple clicks. Just download the tool and add the CSV files and export all CSV contacts to PDF in a single go even without any data loss.