Hi there, I need to read a csv, output it into a datatable and write range into an excel file. Problem: the format wont stay. Numbers become text. Can someone help? Thanks a lot!

@HuaiYe @Katarina you can use generate data table activity with CSV parsing and AutoDetectTypes Set to “True” to get the format correctly steps to do Read Csv with headers → dt_RawData output data table ->dt_RawData to txtdt Generate data table from txtdt with “CSV parsing” and “AutoDetectTy…

What about trying to use an “Invoke Code”?

@Katarina ,Oh,your separator is “;”, my file use “,” to separate.Ok,let me think Invoke code.

@Katarina [20220622155344] Look This.I use vba and success.Although it still reports an error,i comment out the vba it still show the format you want. ps:The columns name i made up.

Okay but I dont get the format I want. [image] I have a csv-file I read csv-File into a datatable I write range into a new xlsx-file In none of these steps I have the column formatted as numbers. But thats what I need.

@Katarina ,Can you give me your xaml file?Or screenshot your process and setting.

@Katarina ,you use studioX?Or you use modren design?It look different as mine.Okay,now you write range to excel and the format as you show before right? Look like we can change the excel setting.Check the column which you want to change the format,click the column,and then click “Data” and then cli…

I use Studio modern design. “Text to column” works one time but the next time its still the format i dont want to have.

@Katarina ,it strange.Let me think.Before I use VBA,I use other way but failed.Let me search some other ways.

@Katarina you can try this way.But @hemanth.bhat ,the data you show still become different than before yet?I tried your way,the format still change.Although my excel changed the setting before.

Formatting CSV / Excel File

Learning & Development Programs Automation Starter

hemanth.bhat (Hemanth Bhat) June 22, 2022, 1:18pm 30

@Katarina
for the decimal place representation you are using “,” separator
that is related to cultureinfo, I’m not sure how to resolve it
hope this article in the forum may help you

Topic		Replies	Views
Convert CSV file to text format when importing into Excel Studio studio	10	1629	January 8, 2023
Write column on csv to excel as number not a text Academy Feedback datatable , excel , csv	1	1028	January 27, 2020
Format date field using Generate Data Table activity Studio uiautomation	5	2627	March 16, 2022
.CSV to Excel considering format numbers Help	2	1672	November 5, 2018
Convert value in excel to correct format Studio datatable , excel , studio , question , activities_panel , format	16	936	June 19, 2022

Formatting CSV / Excel File

Related topics