Just wanted to check what you are referring to when mentioning the classic versus modern mode. The workbook activities are expected to perform in the same way between the two modes, are you seeing differences between the two?
We are expecting some differences in performance between the workbook activities and the scoped ones as we are handling the data differently. How large is the table / sheet for it to take 15-20 minutes? And would it be possible to share a sample file with us where you are repro-ing this?
안녕하세요
샘플 파일은 공유를 하고싶지만 보안 이슈로 공유가 어렵습니다.
엑셀의 시트의 수는 1개 입니다.
시트 1개의 데이터는 20만 셀 입니다.
사양이 같은 PC 2대로 확인 결과 같은 증상을 보였습니다.
PC1 : 클래식 read range 사용 결과 읽기 빠름 , 모던 read range 사용 결과 읽기 느림
PC2 : 클래식 read range 사용 결과 읽기 빠름 , 모던 read range 사용 결과 읽기 느림
Thank you for more context. Any chance you could share a sample text schema of the file that you are using? (to add to the 200000 rows)
number of columns
are there many formulas, or is it just raw data
do some of the columns have long strings
any other things that might be “special” about your file
In other words - if you create a dummy Excel file with the same amount of columns and you fill it with 200000 rows of dummy data (short strings/small numbers), do you see the same results in slow reading?
We’re expecting to see some differences between the two as the Classic Excel is actually handling the data in the file without opening it. That’s why you can use the activities without having Excel installed locally on your machine. What magnitude of the difference are you seeing between the two modes?
