Hey there,
- I have a csv
- I read it into a datatable
- i output the datatable
- i generate a datatable
- i write range into a new xlsx file
Promlem: The Number has a comma as decimal.
Step1:
Step3:
Can someone help?
Thanks a lot!
Hey there,
Promlem: The Number has a comma as decimal.
Step1:
Step3:
Can someone help?
Thanks a lot!
Hello @Katarina,
After the step 2 you can write it to .xlsx file right, also instead of using read CSV activity, you can try to use Excel Scope to read the csv file.
I cannot use Excel Activities for CSV. So I need to read CSV and output it into a datatable. Once I put it into a datatable, I have the format problem.
But why your are using Generate data Table Activity?
Instead you can directly read csv file and Use Write range to Convert that into “.xlsx”.
Regards,
Saloni
Thanks!
I loop trough the datatable and replace “,” by “.” and replace “”“” by “”
But when I read csv, the output is a datatable.
I use Generate Datatable because before I was dealing with this issue:
Can you try it By Following.
Let me know if still any issue comes Up.
Regards,
Saloni