MarketplaceStudioSnippetMerge Content of Multiple Excel Files

Create your first automation in just a few minutes.Try Studio Web

Merge Content of Multiple Excel Files

Merge Content of Multiple Excel Files

by Boundaryless Group

Star

5

Snippet

Downloads

604

Jhana Horacio
Posted 4 years ago

Is possible to merge the content of the cells on the same column (only one excel file) that are equals?

Lahiru Fernando
Posted 4 years ago ago

Hi Jhana,

If I understood your question correctly...

What you want to do is, to merge the content of the same column if they are equal.

So are you looking for something more of a data row merge if the cell values are similar?

If so, it is possible. But it is not a feature of this component. But you can easily write a simple logic on the datatable to merge the content

Naasson Fuka Lubanziladio
Posted 5 years ago

Hi Lahiru,

I have two workbooks. The first one contains 9 sheets and the second one only one sheet. My output file only capture data of the last sheet on the first workbook + the content of the second workbook, which only contains one sheet. Can you please help me to figure out the reason why the 8 remaining sheets (1 to 8) are not being processed? Thanks.

Lahiru Fernando
Posted 5 years ago ago

Hi Naasson

Hmm.. this is weird.. In the template, it should capture all the sheets of a particular file without a problem. In your workflow, does it still have the Assign actvity which I have named as Get Sheets? What this activity do is, it will get the list of sheets of the excel file and use a for each activity below to process each sheet.. 

May I know whether you still have it or?

Lakshman Ganta
Posted 5 years ago

Hi Lahiru,

If column names are different then will it merge Horizantally or Vertically ?

Lahiru Fernando
Posted 5 years ago ago

Hi bro,

Column names can be different.. However, the structure of the datatable should be the same for this template to work. However, if you can include a small column check logic, we can make the structure dynamic too easily

Publisher

Boundaryless Group

Visit publisher's page

Trusted Source

License & Privacy

MIT

Privacy Terms

Technical

Version

2.0.0

Updated

November 12, 2020

Works with

Studio: 19.5 - 22.10

Certification

Gold Certified

Application

Microsoft Excel

Support

Email: lahiru@boundaryless.com

Mon-Fri 8 AM to 9 PM IST; Response time: 1 business day; Resolution time: 10 days