How to remove Single quote(apostrophe) from excel

Help Studio
1

Hi Team,

How to remove Single quote(apostrophe) from excel ,when i convert from CSV to Excel the below green color quotes are displaying.
image

To do my further validation ,I want to remove the single quotes from particular column.
Appreciate your help!!

2

@RajeshT Are you converting the CSV file to Excel by Reading CSV File getting the Datatable and writing that Datatable to Excel File using Write Range Activity?

If you are converting in that way, then After reading the Csv file, Change the Column Datatype to System.Double using the Change Column Datatype Activity.

Then Write that Datatable to Excel using Write Range, The Green Color Quotes should be removed.

1 Like
3

@supermanPunch
Thank you for your response.

I am reading CSV file from Excel application scope ,and writing in to datatable using write range activity .In this way i am getting green color quotes.

4

@RajeshT I think you can perform the Operation mentioned above even with those steps that you followed.
Can you give it a Try ?

1 Like
5

This works perfectly @supermanPunch .
Thank you so much man!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.