Import CSV file into Excel without read and write range

Can anyone help me on import CSV file into Excel without read csv and write into excel. It is causing error for my file, as there are formulas.

Hi @pari_patel

Please try excel vba for this using invoke VBA or execute macro activites

Below is the reference

Thanks

Thank @prasath_S I will definitely try this.

Hi,

you can do it via UI Interaction. Open CSV with Excel and Save it is as an Excel.

Easiest way.

Hey @prasath_S CSVPath is giving me syntax error.

You can also use Balareva.CSV.Activities to do this.

At first you need to create excel file with format table that you want and input excel file path to [CSV to Excel] activity.

This activity will get data in CSV file and input it to Excel file.

Please refer to the following

Giving me below error.
image

Have you tried you can do it via UI Interaction. Open CSV with Excel and Save it is as an Excel?

This tutorial will help you to use Balareva CSV activity. Follow these steps.

Hope this will work now.

@pari_patel have you changed the path from *c:\test* to your local folder path where your CSV file is present. Seems path is wrong.

Note : this will convert all the CSV files in the folder to the excel files.

Thanks

hi ,
no need package. Firstly open Csv file. And File > Export > Change file type > Xlsx > save

done :slight_smile: