Create Table Activities

[yushinchan]

Hi there,

I was about to create a table in an excel sheet from time to time. But I can’t directly indicate the range of the table to be formed. This is due to the table range might be change from time to time, that’s why I can’t specify it with a specific range. So how am I going to fill in the range column?

[KannanSuresh]

Use copy range activity, you just need to provide the starting range. Not the entire range.
For example if you want the data to start from cell “A1”, provide range as “A1”.

[Lou_Kristopher_Milan]

Hi - You refer to this link. Hope this helps.

Excel Create Table Activity - "Range"

Hi, for create table activity, how do I efficiently select a range of data if I only know the top left cell? I.e. I do not know where the bottom right cell is

[yushinchan]

Hi @KannanSuresh

But I’m having two tables in an excel sheet. And the data are existed just that I need to create it into table form.

Thanks and best regards.

[yushinchan]

Hi there,

Here are the sample,

Previously I have two data table like this.

I was about to use create table activities to create two tables like below.

How am I going to specify the range if I only know the top cell which is “A1” and “G1”, instead of knowing the last column to be?

Thanks and best regards.