How to restrict the number of rows that are exported to excel from a table?

[Anonymous]

Hi

I need to restrict the number of rows while exporting the table into an excel sheet. Is there a function or document setting that will help me achieve? appreciate your assistance on it.

[MindaugasBacius]

How do you exporting data to excel via macro function or by just Send to excel functionality?

Please come up with more detailed description.

[Anonymous]

I am using Send to Excel functionality

[MindaugasBacius]

Well than you need just to prepare the straight or pivot table whatever you're exporting to that you wish to see in excel.

[ajsjoshua]

Hi,

check this Can I apply Excel formatting to my Excel reports?

[Anonymous]

where does the 'Keep Source Format' box appear after i right click on the properties of the table box in QV?

[MindaugasBacius]

[Anonymous]

By Converting it to Straight table i can maintain a limit of only 100 rows but I need to export around 1000 rows only

[ajsjoshua]

Hi,

Select View -> View-Grid View  ->  right click your straight table select -> Custom Format Cell

and format as per your requirement

[settu_periasamy]

May be you can try with 'calculated Conditon' in the Table Box -> General Tab..

like

=count(ID)<100

Then apply the error message 'More than 100 Lines'