Team,

I have a requirement as below.

1) In My Excel file I have 40 sheets with Name (Summary Sheet, Sheet 1, Sheet 2...Sheet 40)
2) I want to export only the Summary Sheet to PDF format.
3) I can able to export using the below code.
4) In Summary sheet I have applied formula upto 300 rows, Sometime all rows will show data and sometimes it shows less than 300 rows data. It all depends on the Condition.
5) When I export to PDF, the output is showing all 300 rows even if we don't have data in those rows.

Basically I want to export the Summary Sheet to PDF which has data in those rows.

Please Login or Register  to view this content.
Thanks!
Kiran