I've got 2 workbooks (Excel 97-2003) that I modify with a script:
Workbook1 = 30162 rows by 3 columns
Workbook2 = 51329 rows by 3 columns
The script output is this:
Workbook1 = 25015 rows by 5 columns
Workbook2 = 34382 rows by 5 columns
The smaller workbook takes about 5 minutes to process. The bigger one takes about 10 minutes to process.
Would it make a difference if I converted the workbooks to the .xlsx (Excel 2007) format? One thing I've noticed is that in the .xlsx format, the size of each file is drastically reduced:
Workbook1 - 3.15MB > 980KB
Workbook2 - 6.21MB > 1.75MB
I was hoping that a smaller file size would mean a faster processing time, but that doesn't appear to be the case with my script like it is. I was wondering if there is a different way to access an .xlsx file that might yield a quicker processing time.
Workbook1 = 30162 rows by 3 columns
Workbook2 = 51329 rows by 3 columns
The script output is this:
Workbook1 = 25015 rows by 5 columns
Workbook2 = 34382 rows by 5 columns
The smaller workbook takes about 5 minutes to process. The bigger one takes about 10 minutes to process.
Would it make a difference if I converted the workbooks to the .xlsx (Excel 2007) format? One thing I've noticed is that in the .xlsx format, the size of each file is drastically reduced:
Workbook1 - 3.15MB > 980KB
Workbook2 - 6.21MB > 1.75MB
I was hoping that a smaller file size would mean a faster processing time, but that doesn't appear to be the case with my script like it is. I was wondering if there is a different way to access an .xlsx file that might yield a quicker processing time.