Copy only headers from one excel to another

datatable
excel
headers

#1

Hi,

I wanted to simply copy just headers from one excel to another - I tried it with:

  1. Invoke method
  2. copying the whole table and then deleting every single row except of the headers (with Remove Data Row Activity and it does not seem to work. - always getting the empty excel sheet
  3. creating headers manually (with Build Datatable) and again when I want to put it inside the other excel sheet - I get the empty sheet (Just in A1 cell is written: “Column 1”)

Important: When I use Activity: Output datatable (just to print my datatable to see whether I have good values and whether my table is empty)-> I actually get the right values (my headers). But then again in excel - nothing…

I am desparate, does anyone have solution for this?


Copy header from one excel and create a new excel and paste in it
#2

@ajlakasic use clone method it may work. destinationdataTableName=SourceDatatableName.clone


#3

Hey, I tried .clone and .clear - both… but again the same result (“column1” in the A1 Cell)…


#4

@ajlakasic after building datatable with clone add data to that datatable and write to excel sheet atlast, it will work.


#5

@Manjuts90, can you please explain me detailed?
You mean - I should have something like this:

To assign headers to a variable headers (type: Datatable) and then to write it into excel?
(to mention also this: my target excel is empty at the beginning)


Thank you very much for your help!


#6

@ajlakasic before writing to excel add data to that datatable and then write to excel it will work


#7

I still don’t get it :frowning:
How do you mean to add data to the datatable? I do not have any datatable created… My excel is empty.
I defined datatable headers and assigned the sourcedt.Clone() to it… afterwards I wrote it in excel…

do you mean there is another way to add data to datatable?


#8

I feel like the other solutions, while valid, are overly complicated. Can you read range (“A1:Z2”) Z being the last column where there is a header) into a datatable, leave the add headers option checked, and write range into the new sheet in A1? Then write cell/value “” into cells (“A2:Z2”) to clear that second row of data, leaving only the headers. You might be able to just specify the row (“2:2”).


#10

@ajlakasic use below code it copy only headers, change the array to ur required size based on ur columns

copyOnlyHeaders.xaml (9.1 KB)


#11

Maybe you can write the empty datatable(only with the column titles ) into a csv file.
And then use [copy file ] utility to copy the [.csv] to [.xls] file.
That’s will show the column titles when you open the [.xls] file.


#12

@KEntwistle Thanks! It worked at the end :slight_smile: I had a way more rows than 2, but i adjusted it, and it works… thank you :slight_smile: