For each sheet I am using excel process scope> Excel application scope to write to a cell.
I want to keep the starting column static e.g. H10 but increase the row count(counter) in every sheet to populate the data. This is what I am using : $“H”+Index.Tostring .How do I make the index start at 10th row for all the sheets. It moves incrementally in each sheet.
I tried various variations of Cint but the same error. It gets compiled but during execution gives an error (Write Cell: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.)
However, “Double” is working but with the same result as earlier. Counter does increase but as it changes the sheets in the workbook it does not start with H10 row. it takes the last counter eg H15 or H18.
“H”+CDbl(10+IndexName).ToString
Logic :
Check each sheet name in workbook
compare each sheet name with data table
if Sheet = required sheet name
start from H10 row and fill data
I need to fill multiple sheets but all starting from row H10 .