Merging Datatables in excel

[mukeshkala]

hi @j.murphy,

Apologies for late Response , I missed the post Notification.

So here - If we want the Data to be Pasted side by Side, We will go by the same approach only thing that will change is the Starting cell for the DataTable while pasting.

okay - we paste the first DataTable DT1 from cell A1 - Assuming the excel was blank at begging. So now Lets say if DT1 has 5 Columns - THe New DataTable has to be pasted from E1 .

to Evaluate this E1 - we will read the sheet again and get the COLUMNS Count - This will give us 5 - For 5- we will get the alphabet E and append 1 to make it E1.

Now lets say DT2 was having 2 columns - The Data will Be pasted from E1 to G Column .

Now DT3 should be pasted from G1 - Again we Read the entire Data and get the columns count - Now column count will be 7 (5+2) - We get a alphabet G for 7 , append 1 to it - we get G1. and So on…

Now How do we get alphabet wrt to the Number ?

Below are the threads to refer.

Excel Column Integer to Alphabet

Hi Team, I have a scenario where I need to write a datatable to the left of existing data in excel sheet. The existing data in excel is dynamic. My code should find the existing data in excel and wite the datatable. Please let me know who this can be achived, Since write activity takes Alphabet for column like “A1” or “D3”

Conversion from integer to Excel Column (Base 26) A-Z/AA/AAA etc

Hi, how do I design a workflow to find boundaries of an Excel sheet (top left, top right, bottom left, bottom right)? Here is my current workflow, currently I am using Ascii increment but this only works until column Z. How do I modify this so that it works for column AA, BA, AAA etc? Thanks FindBoundariesBasic.xaml (25.9 KB)

–
Mukesh