Convert csv to pdf

how to convert csv file to pdf fie and what of extension manager pakages

1 Like

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

Hi @vishnumurthy,

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

Regards
Balamurugan.S

I am no knowledge for c++ language and .net…please tell uipath tools extension files and example

RemoteException wrapping System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC
at BalaReva.CamiCat.CsvExcel.20AAA()
at BalaReva.CamiCat.CsvExcel.00AAA()
at BalaReva.CamiCat.CsvExcel.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance,
ActivityExecutor executor,
BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor,
BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor,
BookmarkManager bookmarkManager,
Location resultLocation)

1 Like

Hi @vishnumurthy,
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)

Note :

I have done activity to convert the excel to pdf. I have uploaded the activity in UiPath Go. Waiting for the publishment.

Regards
Balamurugan.S

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)
Regards
Balamurugan.S

Thanks to sir for positive response my quires…

1 Like

Dear Sir,

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.

Email Body:

S.No PASS TYPE TOTAL COUNT
1 Person 2359
2 Vehicle 336
3 Equipment (1 & 2) 465
Total 3160

Thanks.PERMIT ISSUED REPORT FROM 20 OCT 6AM TO 21 OCT 6AM.zip (221.6 KB)

1 Like

Hey :slight_smile:

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.

import openpyxl
import os
eg = ‘c:\users\igor\desktop’
os.chdir(eg)
wb = openpyxl.load_workbook(‘YOUR SPREADSHEET NAME.xlsx’)
sheet = wb.get_sheet_by_name(‘sheet1’)
x = sheet.max_pow
return x

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…

Hi @vishnumurthy,

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)

image

Regards
Balamurugan.S

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.