hi, I am creating data in excel If you are stuck in the process, ask for help. When an Excel sheet is loaded in text format and when it is loaded by UiPath, two phenomena are displayed. I want to read and write csv like “text” sheet sample.zip (35.3 KB) The zip file contains csv and excel files…

We can do this by performing the following steps - Build a datatable with appropriate numbers of columns with datatype as string Read the csv file using Read CSV into the above datatable Write the datatable to an excel file using Write Range activity

Convert CSV file to text format when importing into Excel

Help Studio

Balaji_Murugan (Balaji Murugan) January 7, 2023, 4:36pm 9

You could follow this link - How to convert CSV file into XLSX

Topic		Replies	Views
Import CSV files into Excel through VBA code Help	1	1442	November 12, 2018
Formatting CSV / Excel File Automation Starter	32	1691	June 26, 2022
Change text format to excel /csv format Studio excel , uiautomation , activities	2	879	February 19, 2020
How to change the format from .csv to .xls in automation Help excel , activities	8	8943	September 1, 2017
.CSV to Excel considering format numbers Help	2	1666	November 5, 2018

Convert CSV file to text format when importing into Excel

Related topics