Date Format, Number Format, Data Table

[Parvathy (PS Parvathy)]

Hi @manikandan.murugan

I have a workflow for this:
=> Use below syntax in Assign activity:
Assign (DataType = System.String) -> "12/08/2023"
Assign (DataType = System.String) -> "1-3"
Assign (DataType = System.Int32) -> CInt(rowRange.Split("-"c)(0))
Assign (DataType = System.Int32) -> CInt(rowRange.Split("-"c)(1))

=> Use below code in Invoke Code:

dt = New DataTable()
dt.Columns.Add("SingleDate", GetType(String))
dt.Columns.Add("SingleDataRow", GetType(String))

' Generate rows using LINQ
Dim rows = Enumerable.Range(startRow, endRow - startRow + 1).
    Select(Function(row) New Object() {inputDate, row.ToString()})

' Add generated rows to the DataTable
For Each row In rows
    dt.Rows.Add(row)
Next

Invoked Arguments:

=> Write dt to excel using Write Range Workbook.

Sequence5.xaml (10.9 KB)

Hope it helps!!