Count columns and copy from another excel

[markosc]

Hi, i have an excel file with data and I don’t know how many columns. i need to count columns and copy column data from another excel to the first one.

[prasath_S]

Hi @markosc .

For counting columns we can use

dtTable.columns.count

And for copying if you can you explain little more with sample files.

Thanks

[markosc]

Table with black borders I have to count, and with red borders are newly added columns from another Excel file

[prasath_S]

@markosc

Please try this steps and let me know,

1. Read the excel data using read range (the red bordered from excel file) and store it in datatable - dtTable1 (variable name)

2. Read the 2nd Excel using another read range and store it in datatable - dtTable2 (variable name)

3. Use the component given in below link to convert number to excel letter.

Activity name - Get column name

Convert Column index to column letter

Hey everyone, I have a pretty simple question but couldnt find a way to do. I get the column index as “columnIndex” variable, it could be 0 which is ‘A’ or could be 3 which is ‘D’ etc. ı need something to change this to letter for example if the column index is 0 I want to save it as A or if its 1 I want to save it as B. Any suggestions?

Input will be dtTable2.columns.count
(Output of the activity colname)

3. Use write range and give sheet name and range as colname + “1” and pass datatable as dtTable1

Thanks