This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Input tool of workflow is connected to SQL Server Database where a query is executed to produce data every month end . Amount of data increases every month. Normal data will contain 2 million rows which will increase every month , like next month it will become 2.5 million and so on.
We need to output that data in excel but excel has a constrain that can accommodate 9,99,999 rows only .
Thus , we want to make it automated so that first 9,99,999 rows saves in first excel and then next 9,99,999 rows in second excel and so on .......
and output excel file name update accordingly like Data-Part1.xlsx , Data-Part2.xlsx and so on