I am converting excel to PDF . I want 8 columns in a page .I am using below code to achieve this.
Ex:- When noOfColumns=199 then setNoOfPages=25 so report should be generated in 25 pages each should have 8 columns and last one should b 7 columns . But in the report it is generating randomly please find the attached report and also I want the data should be visible properly with out adjusting the zoom.
Please suggest me.