ooh and if someone knows how to define another type of view (page break preview for example) in excel I would appreciate it if you would share the way to do it.
Reading a range creates a datatable object. A datatable may be sorted (e.g. .net - Sorting a Data Table - Stack Overflow). Alternatively, use Excel to sort the range in advance.
The problem with the solution of the datatables is that the excel contains references and not real data, so it does not let me read them(send an error).
The solution through excel would be shortcuts or how?
If this doesn’t work, give the Read Range activity a shot (not the one that requires an Excel Scope). I believe this one yields values instead of formulas or refs, but I might be mistaken.