How to convert each cell of an excel into proper case

[Ishan_Shelke]

I have an input file Like this

I want to convert the third column i.e Partner Description column into proper case

Expected Output

Any Ideas On this ?

[jack.chan]

read excel as dt
loop each row, assign
CurrentRow("Partner Description") = strconv(CurrentRow("Partner Description").ToString, vbProperCase)

[rlgandu (Rajyalakshmi Gandu)]

Hi,
I hope this will help you

1. Drag and drop an “Excel Application Scope” activity onto the workflow canvas.
2. Within the Excel Application Scope activity, use the “Read Range” activity to read the data from the Excel file and store it in a DataTable variable. Specify the range you want to read, such as “A1:A10” to read data from cells A1 to A10.
3. Add a “For Each Row” activity below the “Read Range” activity to loop through each row in the DataTable variable.
4. Within the “For Each Row” activity, add an “Assign” activity to convert the cell value to proper case. Use the following expression:
   row(“ColumnName”) = StrConv(row(“ColumnName”).ToString, VbStrConv.ProperCase)
   Replace “ColumnName” with the actual name or index of the column you want to convert to proper case.
   After the “Assign” activity, add an “Excel Write Range” activity to write the modified DataTable back to the Excel file.
   Configure the “Excel Write Range” activity by specifying the range where you want to write the data, such as “A1” to start writing from cell A1.
   Specify the DataTable variable that contains the modified data as the input for the “Excel Write Range” activity.
   Finally, save and run the workflow to convert each cell of the Excel spreadsheet into proper case.
   Thank you.