Couldn't Read range error1

Help Activities
, ,
1

Hi all,

I strucked while reading a excel I am getting an error like “Could not read range”.
Even after the excel is correct which is the output after converting text file to excel.
I dont know what’s wrong, cScreenshot (77)
an someone please help on this??

2

Hi @HeartCatcher

Did we try with work book activities instead of excel
And make sure the sheet name is correct

Cheers

3

@Palaniyappan,

Thanks for your reply I tried as you suggested using work book read activity even after I am the same error.

Screenshot (78)
Screenshot (78)1366×768 83.6 KB

4

@HeartCatcher

Just for analysis purpose:

  • check excel on columns which do represent a date
  • reformat the excel columns with a different cellformat
  • test again
6

At least when:

  • reformatting the date columns to short date
  • reformating first, second, Related_Account to numbers

we can read in.

Cell reformattings can be done with Balareva Package

7

Can you explain a bit more??
How can I achieve that.

8

you can manually reformat the cells in Excel

grafik
grafik612×723 59.5 KB

Once it is working you can automate it with:

grafik

grafik
grafik744×256 49.3 KB

9

What could I mention inside Cell format??

Screenshot (81)
Screenshot (81)1366×768 79.2 KB

10

the format that you have prototyped manually in excel when configuring advanced / custom formats

11

Screenshot (82)
Screenshot (82)1366×768 83.5 KB

Its done as you suggested even after I am getting the same error

12

I would state If I got it run and it is failing on your end then experiment with formats and try different ones.

try a DD.MM.YYYY format or short date. As the formats string are locals dependend so my german format TT.MM.JJJJ will not help you. Explore by your own.

But as mentioned, first format it manually and got it run. Then automate it later with Balareva

1 Like