I read the .xlsx file in a folder using each curr_File in Folder and Workbook Read Range.
the output dataTable name for each curr_file I want to keep as string var = “DT_”+count.ToString, where count in an incremental variable.
Can someone help me with this?
How can I do this?
Better use a dictionary type variable…as even if you store variable as string you cannot use as variable
You can create a variable of type dictionary(string,datatable)…
And then store the dattable as below
Dict("dt" + count.ToString) = extracteddtvaraible
Later you can access the datatable using dict("dt1")
Cheers
If you’re asking if we can create a DataTable variable on the go,
For eg if you have 3 Excel files, you need the bot to create 3 DataTable variables in runtime.
Afraid, That won’t be possible.
If you need something of that sort,
please create a dictionary of type string, datatable
That way you would be able to maintain and manage it.
Thanks
ashokkarale