Type error

[Kuldeep_Pandey]

Pls tell me how to correct it

[Yoichi]

HI,

Can you try to use curly bracket as the following?

{Dt1.rows(0).item("Value").ToString}

Regards,

[THIRU_NANI (NaNi)]

Hi!

ArrayOfRow is the type of object->Object array

Your Expression should be like this:

{Dt1.Rows(0).item("Value").ToString}

Regards,
NaNi

[Kuldeep_Pandey]

I want to add more rows here how to add?

[Yoichi]

Hi,

Give it a try as the following.

{Dt1.rows(0).item("Value").ToString, "data2", "data3", varable2}

{Dt1.rows(0).item("Value").ToString, Dt1.rows(0).item("column2").ToString,Dt1.rows(0).item("column3").ToString}

Regards,

[Kuldeep_Pandey]

I am writing data into excel but its showing me this error
Error ERROR Validation Error Compiler error(s) encountered processing expression “DToutput”.
Value of type ‘System.Data.DataTable’ cannot be converted to ‘String’. Main.xaml

[Yoichi]

Hi,

If you need to write DataTable to worksheet, can you try to use WriteRange activity instead of WriteCell?

Regards,

[Kuldeep_Pandey]

And what is this

[Kuldeep_Pandey]

My code ss

[Yoichi]

HI,

There seems no match in your regex result. Can you check your pattern and/or input data?

Regards,

[Kuldeep_Pandey]

My property of matches

[Yoichi]

Hi,

Can you share content of input string and regex pattern string?

Regards,

[Tapan_Behera1 (Tapan Behera)]

Hi @Kuldeep_Pandey if you want to more rows then you can use a loop like:

[Kuldeep_Pandey]

row.item(“Regex”).tostring pattern

build data ss

[Yoichi]

Hi,

It’s necessary to set just regex pattern string in you Regex column, as the following, for example.

Regards,

[Kuldeep_Pandey]

System.Text.RegularExpressions.Regex.Matches(Pdfoutput,“\b\d{2}\W\S{3}\s\d{4}\b”).*
like this?

[Yoichi]

HI,

Either of the following.

OR

Regards,

[Kuldeep_Pandey]

Output of write range its not giving me value of regex exp

[Yoichi]

Hi,

How did you set DATE data of the datatable? If you use Assign, can you share its expression?

Regards,