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