Export Data Store Entity to Excel Smart Service

Hi Devarneni Shiva Prasad Rao ,

Limit for columns is 50.

Export To Excel , It Says in Documentation there is a limit in number of columns .Only 50 columns. And as for the rows , I don't think there is a certain number. But you need to make sure You don't get Time Out error .

The main concern is about row count, any idea on row limit? 

Oh ok

venkat Avuluri said:

But you need to make sure You don't get Time Out error .

Go though the link it holds few design considerations and best practices for the better performance of the smart service.

hi Devarneni Shiva Prasad Rao may I know how many number of rows you are trying to export

1. Present we had 10000 rows, not sure how many we will have in future, the row count will increase day by day 

10000 rows is a solid amount, are you exporting it from a table or view? May I know what the count of your columns to be exported is

Hi Devarneni Shiva Prasad Rao , 

You can query the data in batches and export the data while looping make sure are updating the data in the same document which is created at start and  Update the cell starting number each time hope it will solve the issue. 

JayaPrakash Ravipati said:

You can query the data in batches and export the data while looping

This node handles batching inherently.  There should be no need to do manual looping when using it.  That is one of the original reasons they even made it.