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.
Please try excel vba for this using invoke VBA or execute macro activites
Below is the reference
Thank @prasath_S I will definitely try this.
you can do it via UI Interaction. Open CSV with Excel and Save it is as an Excel.
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.
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.
no need package. Firstly open Csv file. And File > Export > Change file type > Xlsx > save