Hi i am converting excel to .csv before converting i need to delete off a column name in .csv before it saves to new file.how it can be achieved?
sameple images are shown below
Need to delete column1 before saving it to .csv
output should be
Need to delete column1 before saving it to .csv
output should be
After reading the data table , you can loop through for each activity, please find the below sequence for reference.
Sequence3.xaml (8.9 KB)
Note: you can use above sequence after you reading the data table.
Hope it helps!!!
1 Like
i am not able to use this for a folder of .csv file
Hi Vignesh,
Please try this.
Can reading the Excel sheet without headers.
Then Assign Datatable.rows(0).item(0) = “” since you need to remove first column name alone
Then write CSV without headers. Column name of first column will not appear in the CSV.
1 Like
possible to send me a sample ?
Hi Vignesh,
Read the Excel without header and then Assign very first value of the table to “”. Then write the CSV without headers.
1 Like
Hi value at A2 column is being Deleted. i need Column at A1 should be deleted.
Hi Vignesh,
In read range activity, Uncheck the Add headers property.
Then your excel headers will become index 0 in the datatable.
Regards,
Harish
1 Like
its working with XLS. not working with.csv format
@HarishGnanakumar i need the headers for rest of the columns. If i uncheck all the headers goes off
how about from folder of .csv?
@lrtetala tired it but all the columns become blank.I do require a sample like this below.
Would help to send a sample code.
A1 should be blank in .csv
If your folder having multiple files and having different sheet names then try like below
Sequence22.xaml (17.1 KB)
Regards,
ok sure let me try it out.
Great working.thanks
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.