I have used build datatable activity. Columns are string and int32 type.
I have a chapter of text and I have used split and assign activities to store the values I want.
Some of them are text and some numbers.
What is the best way to move those to the datatable?
Currently I have created a variable system.string to first collect all the items together.
And then I have used Add data row activity.
But by doing this, all those variables that are numbers are converted to text.
How to first convert those to numbers when splitting the original text and then add those to the datatable as numbers as well.
How did you check it’s text?
If you checked it with excel, can you try to use not Workbook-WriteRange activity but WriteRange activity (with Excel Application Scope) or WriteRangeX activity (with UseExcelFile activity)?
I have a write range in excel application scope. That is working fine and excel regocnizes data types. Problmes come when I need to append more rows to the same file. Then those are shown in Excel as text.