I am struggling currently with a piece of automation - namely, I have downloaded package ExcelToPdfConversionActivities 1.1.7 and used the Excel to PDF activity on my .csv files. However, my preferred viewing of the .csv files is automatically text-to-columned, rather than comma-separated in one column. The problem with that is that columns are fixed width, and pdf that is generated shows some values as “#####”. I already tried automating steps with Auto-fit, made a macro for that, nothing helps - seems like .csv cannot remember the formatting and every time it gives me the same-width columns in generated pdf. Any idea how to fix that?
@Palaniyappan after saving it as xlsx (write csv/save workbook activities, etc… with extension changed from csv to xlsx) it goes smoothly, but the file is unopenable after the process.
@sandeep13 the goal is that for audit reason, the file needs to remain untouched manually - every transition until the pdf format must be within automation scope
Hi
May I know how is the data read after converting to excel from csv
Once after converting we can read that data from excel with read range activity and get the datatable which can be written first to a word document and then convert that to a pdf
For that install UiPath.word package and then use word application scope and Insert table activity
As you see, both options are not ideal.
Ideally, we would like to have the format of the first report, just showing values (those values are dates, they wouldn’t stretch the width of the report document to unfittable sizes - the #### are just showing because of the fixed width setting when opening each excel document on)
Thanks for help so far, can you give me any further suggestions as to how to fix this problem?