How to remove green format in excel

How to remove those green formats in the below pic.

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

Hope it helps you!

1 Like

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

@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

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

for all related columns?

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!!!

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.

Yes @sathish_Kumar6 ,

Yes, That expression will perform only for a single column