How to remove green format in excel

[sathish_Kumar6 (sathish Kumar)]

How to remove those green formats in the below pic.

[Vikas_M]

Hey @sathish_Kumar6 ,
Refer below link
Green Triangle in Excel: What it Means and How to Remove.

Hope it helps you!

[sathish_Kumar6 (sathish Kumar)]

May i know how to this UiPath? instead of manual intervention

[Vikas_M]

@sathish_Kumar6 ,
So u are getting that green mark because the numbers are stored as text in excel
So to clear that green mark

DT.Columns("YourColumn").DataType = GetType(System.Int16)

For reference refer below thread

How to resolve Excel error using Uipath

as per below screenshot I am getting error in excel as in green triangle in every cell I need those data in numbers format. Any help ? [Capture1]

[sathish_Kumar6 (sathish Kumar)]

@Vikas_M

DT.Columns(“YourColumn”).DataType = GetType(System.Int16)

Do i need to perform this expression DT.Columns("YourColumn").DataType = GetType(System.Int16)

for all related columns?

[Kartheek_Battu]

Hello @sathish_Kumar6

ExcelOptions Visible="True" ExcelApplicationScope.ExcelOptions "YourFilePath.xlsx" < Perform other Excel-related activities if needed -->

    <Clear Formats activity -->
    <ClearFormats Range="Sheet1!A1:D10" />

Thanks & Cheers!!!

[shreyash_shirbhate]

Hi @sathish_Kumar6,

you can simply create a Macro and then run it with the help of UiPath.

Please check below blog for the same.

https://www.linkedin.com/pulse/extracting-filtered-data-uipath-based-cell-color-excel-shirbhate%3FtrackingId=YFhy2LkNRQSDYsVcXgohTQ%253D%253D/?trackingId=YFhy2LkNRQSDYsVcXgohTQ%3D%3D

I have done it for extraction of data but same way you can do it for your stuff.

[Vikas_M]

Yes @sathish_Kumar6 ,

Yes, That expression will perform only for a single column