How to read excel and enter the data into web forms.Help


For my Flow i want to Get date in Excel file.

ex.if to day is :09/27/2022 i want to get date next row in excel file (Output 09/28/2022)

  • if tomorrow 09/28/2022 i want to get date next row in excel file (Output 09/29/2022)

need more details. you want to read or write?

1 Like

Hello @punnipah

You can use the index to achieve this.

Dt.Rows.IndexOf(row) will give you the current index. use an if condition, IF it meets the requirement then use an Get Row item activity for the next index.


1 Like

Sorry i want to write date in to web forms.

i want to get Row item activity for the next index

Hello @punnipah ,

Please try this to get the row index:


Please try this to get the value from the next row:

1 Like

Compiler error

please try this one.
Next Day -

row(“YourColumnName”).AddDays(1).Tostring(“dd/MM/yyyy HH : mm : ss”)

merhaba bu sorunun cevabını bulursan bana da iletir misin?

Try this

DateTime.ParseExact(CurrentRow("Date").tostring.trim,"MM/dd/yyyy HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture).AddDays(1).tostring("MM/dd/yyyy")
1 Like

Hello @senolsen194 , Welcome to UiPath Community

Try this , it may help you

use row instead of current row

DateTime.ParseExact(Row("Due Bank Mobile & FBB").tostring.trim,"MM/dd/yyyy HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture).AddDays(1).tostring("MM/dd/yyyy")


Use Row(“YourColumn name”)

@prithivi_raj_shanmugam are you trying to convert date to next date?

no, I don’t have any issue, I was trying to provide solution

@prithivi_raj_shanmugam have you try my suggested solution?

no, I haven’t

@prithivi_raj_shanmugam wao, you can try, I think you have no trust on me :joy:

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