Number issue /

May I ask how I can cope with this issue:

If I do the follwing:

Can anyone help me to fix it? Many thankssss…

Just Read the sheet again and then for each row just write the correct number.

FA Sorting ver…xaml (32.7 KB)

@Happydayyy

After the delete row…use write cell and write the first cell value as 1…then use auto fill range which will fill the remaining numbers as needed

Hope this helps

Cheers


I can’t open your workflow, can you send me the complete flow picture to me? Many thanks!

Why there is an error here?

Workflow:
FA Sorting ver.2.1.xaml (25.5 KB)

The Expression should be

Excel.Sheet("FA controlC__ (robot)").Cell("A"+(rollNo+1).ToString)

Not
Excel.Sheet.(“FA controlC__ (robot)”).Cell(“A”+(No+1).ToString)

seem you add . after sheet

this the project file
Number.zip (5.2 KB)

Thank you so much, the problem fixed.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.