Thank you @balupad14.
Can you generate the csv file from this Excel file?
Arricchimento_2018_07_06_101551.xlsx (27.9 KB)
The file is the csv with the content of the Excel file.
Thank you.
Camilla
Thank you @balupad14.
Can you generate the csv file from this Excel file?
Arricchimento_2018_07_06_101551.xlsx (27.9 KB)
The file is the csv with the content of the Excel file.
Thank you.
Camilla
HI @CamiCat,
it is not suggestion. Have you tried to read the excel file into a Datatable . And save it as csv by using of Write CSV activity.
Regards
Balamurugan.S
Yes @balupad14.
The problem here is that I have to import data from csv file and save it, after manipulating the Column Data typa, to an Excel file.
I need necessarely to insert the name of the file I want tomimport
Ok @CamiCat,
I am going to develop a custom activity that to Convert the Excel file to CSV file . Is it ok .
Do u need any feature in it.
Regards
Balamurugan.S
I would need from csv to Excel with the data saved in Text format.
Is it possible?
Hi @CamiCat
To Save Textformat , only have to use the csv. In Excel , I think is not possible.
Which one you need ?
CSV to XL or
XL to CSV.
Regards
Balamurugan.S
Hi @CamiCat,
Here I have attached the custom activity that to Convert Csv to Excel .
File : BalaReva.Excel.Activities.18.0.0.zip (40.4 KB)
Note :
Configure the package in local. Test it.
Regards
Balamurugan.S
Thank you so much @balupad14.
I’ll try and let you know as soon as possible.
Thank you pfor your precious help.
Camilla.
It works.
can I ask you a modification?
I woul need to save all the data separated by a “;” in different comlumns not in a unique column.
The original csv file is in this format.
Hi @CamiCat,
I really sorry to say. I am confused with your purpose .
You said that you need to convert the csv to Excel. In that case , Why you are expecting the delimiters.
Because the delimiters are only in the csv format. to test my component I need the csv file. If you feel that it is a confidential . Please send it by message.
Regards
Balamurugan.S
Hi @CamiCat,
The sample is different from your csv. that i have attached it in package thread. I have sent the mail. Please check it.
Regards
Balamurugan.S
Thank you so much @balupad14.
Can you please explain me the meaning of this message?
Hi @CamiCat
When I test at my side , I am not getting any msg. May be the office version. I am using the 2007.
Thank you
Balamurugan.S