Create new worksheet name for every data table row

Help
,
1

Hi,

I’m trying to create new excel worksheets for each row in my datatable.

The datatable contains 5 rows with different customer numbers in the first column i.e.:

CusNumber | fname | lName
123 | John | Smith
456 | Jane | Doe
…
…
…

Is there a way to capture the first customer number & create a new excel worksheet called i.e. 123, then the second worksheet name 456, etc all within the same workbook?

I’ve tried a 'for each row in DT > write range however, i just receive an error advising that the range doesn’t exist.

Any ideas?

2

This is one way to achieve since CusNumber is unique

image
image750×432 14.7 KB

3

Thanks @vvaidya for your quick solution however, i’m receiving the following error when I try to run it:

Write Range : Syntax error: Missing operand after ‘123’ operator.

Any ideas?
Thanks

4

Can you share the screenshot of that part of your code?

5

Ok

error msg

This section falls with an Excel to scope activity, so i just used the shorter write cell activity.

The error received is:

syntaxError

6

Looks good to me. Try removing quotes

dt.Select("[cusNumber"] ="+row(0).ToString).CopyToDataTable

3 Likes
7

Thank you!