Convert CSV file to text format when importing into Excel

Help Studio
1

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. Please help me!!!plzplz
It’s hard to search because I’m not good at English
I’ve been trying to succeed on my own for too long…I used a translator for this

2

Hi @sahyunid1 ,

Could you also let us know what were the Activities used to perform the Write Operation ?

If you are already using the Modern Activities, then you could try using Format Cells Activity to change the Format of the Column to Number.

image
image729×468 20.7 KB

Let us know if this doesn’t work or not able to use the Modern Activities.

3

I’m use not Modern ToT

Is there any other way?? Help…

4

You can give a try with Invoke VBA activity - How to convert a Column format from general to number format with 2 decimal places - #5 by nikhil.girish

1 Like
5

Is it possible to import the csv of the sample file into Excel in text format via VBA?
I’ve never used VBA before…

Only a few lines of sample, but over 80,000 original CSVs

may be more from time to time

7

We can do this by performing the following steps -

  1. Build a datatable with appropriate numbers of columns with datatype as string
  2. Read the csv file using Read CSV into the above datatable
  3. Write the datatable to an excel file using Write Range activity
8

I thought of that way.
Create an empty text excel file

  1. Copy and rename the file
  2. Save under another name
    I’m confused because I don’t know either way.
    This is because when the CSV file downloaded every day is processed with Excel, it must be automatically created so that the date of the day is included in the file name.
9

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

10

thank you. I accidentally changed the file name while using the copy activity. I solved the problem by renaming the copy. ^^

copy file - start - folder file
end - folder\ + “change name”

The file name has been changed. :slight_smile:

11

I was able to set the desired Excel value by accidently copying the file and finding the rename. If there is any other solution, please recommend.

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.