Excel ### while after doing Autofill range

Help Something Else
1

i did write cell for E3 and E4 as date-1 using this expression DateTime.Now.AddDays(-1).ToString(“yyyyMMdd”) then after autofill range for this specific range ( “E3:E”+(dtss.Rows.Count+1).ToString ) and im getting hash hash hash hash… like that in excel so not to see this hash then what should i do?

image

2

Hi @sathish_Kumar6

The “hash” values (#####) in Excel cells occur when the cell width is not wide enough to display the entire content. To resolve this issue, you can follow these steps in UiPath:

  1. After autofilling the date values in column E, select the “Write Range” activity that writes the data to Excel.
  2. In the properties panel of the “Write Range” activity, check the “AutoFit Range” option.
  3. Provide the range parameter as “E3:E” + (dtss.Rows.Count + 1).ToString.
  4. Save and run the workflow.

Hope it helps!!

3

Hi @sathish_Kumar6

If the cell is too narrow to display the value, then the hash marks are shown. Use Autofit Range activity to autofit the columns and shows the values present in the cells.

Hope it helps.