Can't Open Excel file generated from SAP

Hi all

I’m currently extracting a table from SAP using “List, Export, Spreadsheet” in the SAP GUI and saving the file as this format


the problem is when I try to use a read range I always get this error

“Read Range: Row number must be between 1 and 1048576”

I’ve checked already and I only have like 10,000 rows. Is there a problem with SAP excel files or has anybody got a solution for this? Thanks

@kahoyim Have you Checked this Post, This may Solve it :

@kahoyim Hi! You managed to solve this? I could not understand what the VB Script code would be like to solve this

I had the exactly same problem. Use read range inside Excel Application Scope activity and check for duplicates in column names (if they exist, change it by using write range activity before read range)