Read formula field value but after the third row I get an empty value

[CodeNinjaGuy]

Read formula field value but after the third row I get an empty value

[CodeNinjaGuy]

i did some investigations and i found that only every 64. row will be readed.
Row: 1
Row: 2
Row: 66
Row: 130
Row: 194
Row: 258
Row: 322
Row: 386
Row: 450
Row: 514

[Abdulah-butt]

any update on this?

[FauconSpartiate]

@Abdulah-butt @CodeNinjaGuy Can you provide a sample excel file which cause the issue? This will help is debugging.

[liquiddrop]

Thanks for the code, I was able get this to work by changing the regular expression to this:

RegExp exp = RegExp(r'[A-Z]{1,3}[0-9]{1,3}');

The original RegExp was truncating cell headers so something like A12-B12 would look like A1-B1. My regex only covers three letters followed by three numbers which works in my case but is easy enough to change to be more.