Read Workbook Range : End of Central Directory record could not be found

Help Studio
, ,
1

Hi Community,

I’m trying to merge 3 excel files A, B ,C into one single Excel file with 3 sheets A, B, C
But I’m getting bellow error.
image

Steps I followed:

  1. Read workbook range for Excel A
  2. Read workbook range for Excel B
  3. Read workbook range for Excel C
  4. Excel Application Scope {
    Write Range A
    Write Range B
    Write Range C
    }

Kindly suggest if I’m doing correctly or not.

2

Hey @Vaishnav_Tej

In which read range of the mentioned does the error come ?

Thanks
#nK

3

workbook range

4

No I can see you have three read range activities used as mentioned above, So just asking which one causing the error.

5

In First one itself

6

HI @Vaishnav_Tej

You can also try with Power query to merge the excel file?

Regards
Gokul

7

I have no idea about power query.

8

Okay @Vaishnav_Tej , No worries. can you share the screenshot of your XAML file.

If possible share the sample excel file?

Regards
Gokul

9

image

10

Can you provide this if possible? @Vaishnav_Tej

11

Hi,

I found Solution from YouTube

But, I do not have MS Office 2010 or newer version So, error fetching the data.

image

12

Hey @Vaishnav_Tej

Could you please try using the Classic Excel activities for the same ?

Thanks
#nK

13

HI @Vaishnav_Tej

Just type the expression in the Range

Excel. Sheet("Sheet Name")

image

Regards
Gokul

14

Can you send sample xaml file?

1 Like
15

Sure tomorrow! :+1::slightly_smiling_face:

16

HI @Vaishnav_Tej

Check out the XAML file with Modern and classic activity

Classic activity

image

Modern activity

image

Check out the XAML file

ReadExcel.xaml (10.1 KB)

Regards
Gokul