Complicated Excel - Read and Create a new Excel

[Lahiru.Fernando]

Hi @1easy

Check out this sample workflow. This was something I created for someone else for the same scenario. You can check it out.

GetWorkBookSheets.xaml (8.9 KB)

For excel formatting, please refer the below thread

Merge Excel cells in Faster way

Hi, Currently, I am trying to merge excel cell using excel shortcuts but it’s taking a lot of time to perform each merge. The idea is to merge 6 cells together and perform the same activity 12 times horizontally and 15 times vertically. Below is just a sample of the merge: I would like to know if there is any faster way to perform the same? [image] Thanks, Anjali

If this works for you, please make sure to mark the answer as the solution so that it could help others who are seeking for the same

Let know how it goes