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

[punnipah]

Hi,Everone

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)

[prithivi_raj_shanmugam]

need more details. you want to read or write?

[Rahul_Unnikrishnan]

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.

Thanks

[punnipah]

Sorry i want to write date in to web forms.

[punnipah]

@Rahul_Unnikrishnan

Get Row item activity for the next index

i want to get Row item activity for the next index

[Marius_Puscasu]

@punnipah

i want to get Row item activity for the next index

Hello @punnipah ,

Please try this to get the row index:

datatabel.Rows.IndexOf(Row)

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

datatabel(datatabel.Rows.IndexOf(Row))(yourColumnIndexOrColumnName).ToString

[punnipah]

@Marius_Puscasu

datatabel(datatabel.Rows.IndexOf(Row))(yourColumnIndexOrColumnName).ToString

Compiler error

[raja.arslankhan (Raja Muhammad Arslan khan)]

@punnipah
please try this one.
Next Day -

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

[senolsen194]

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

[Gokul_Jayakumar (Gokul Jai)]

@punnipah
Try this

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

[Gokul_Jayakumar (Gokul Jai)]

Hello @senolsen194 , Welcome to UiPath Community

@Gokul_Jayakumar

Try this

DateTime.ParseExact(CurrentRow("Date").tostring.trim,"MM/dd/yyyy HH:mm:ss",System.Globalization.CultureI

Try this , it may help you

[punnipah]

@Gokul_Jayakumar

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

[Gokul_Jayakumar (Gokul Jai)]

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")

[Gokul_Jayakumar (Gokul Jai)]

@punnipah

Use Row(“YourColumn name”)

[raja.arslankhan (Raja Muhammad Arslan khan)]

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

[prithivi_raj_shanmugam]

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

[raja.arslankhan (Raja Muhammad Arslan khan)]

@prithivi_raj_shanmugam have you try my suggested solution?

[prithivi_raj_shanmugam]

no, I haven’t

[raja.arslankhan (Raja Muhammad Arslan khan)]

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