Hi all, I have an activity to extract data and write to an excel file. The data is around 120K rows, however, excel always applies the format and formula for all rows up until 50002. From 50003 and after, there are no format, formula, or headers. Any suggestion would be apprecated.

Excel formula and format are not applied for 50003 rows and above

rahulsharma (Rahul Sharma) October 8, 2021, 6:13pm 2

This thread has the answer

Topic		Replies	Views
Write Range activity doesn't write all the data back to Excel Help	1	1061	May 14, 2020
Excel write range datatype in column Activities excel	15	841	October 27, 2022
Write range activities : need to keep number and format after write data to new sheet Help excel , activities , question	5	5387	December 10, 2019
Big Excel File Activities excel	7	665	December 2, 2022
I have 18000 record in excel Help datatable , excel , activities , question	13	3519	August 21, 2023