Type into with Simulate doesn't work

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 :slight_smile:

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 :slight_smile:

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? :slight_smile:

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

:clap::clap::clap::clap::clap:

I would need Csv to Excel :slight_smile:
thank you @balupad14 :tada:

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)

image

Note :
Configure the package in local. Test it.

Regards
Balamurugan.S

2 Likes

Thank you so much @balupad14.
I’ll try and let you know as soon as possible.
Thank you pfor your precious help.
Camilla. :blush::blush:

1 Like

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.

Arricchimento_2018_07_06_101551.xlsx (15.2 KB)

The original csv file is in this format.


Is this possible?
It would be essential for my purpose.
Thank you so much,
Camilla.

1 Like

Hi @CamiCat,

I will change it and get back to you.

Thank you
Balamurugan.S

1 Like

Thank you so much @balupad14.
I’ll wait for your kind and precious help.
Thank you,
Camilla :slight_smile:

1 Like

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,

Here is the solution.

Regards
Balamurugan.S

2 Likes

Thank you so much @balupad14.
Which output do you obtain?
Thank you :slight_smile:

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

1 Like

Thank you so much @balupad14.
Can you please explain me the meaning of this message?


Thank you so much for your precious help,
Camilla :slight_smile:

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

1 Like

Thank you @balupad14.
Do you think there is a problem with version 1803?
Camilla :slight_smile: