GrapeCity Forums

Hi,

I have upgraded from Version 3 to Version 4 and it resolved many issues which i was facing previously.

Now i want to know how can i remove "Row Headers" and "Column Headers" when i  export file to PDF.

Currently when i am using method SavePdfToResponse that is working perectly correct but the output contains "Row and Column Headers" in the exported file.

I do not want row and column headers in exported output. How can i achieve that?

Jai

Hello Jai, 

The export to pdf uses the default flag of SaveAsViewed. Thus, before calling the SavePdfToResponse method, you may set the FpSpread1.ActiveSheetView.ColumnHeader.Rows[0].Visible = false; and set it to true after calling the SavePdfToResponse method. 

Regards, 

In addition, you may also use the PrintInfo class on every sheet and specify the settings to hide the Column and Row Headers. Below is the code snippet: 

        PrintInfo pi = new PrintInfo();

        pi.ShowColumnHeader = PrintHeader.Hide;

        pi.ShowRowHeader = PrintHeader.Hide;

        FpSpread1.Sheets[0].PrintInfo = pi;

        FpSpread1.SavePdf(0,@"c:\abc.pdf");

Regards, 

Hi Harish,

Thanks a lot for the code.

Both the codes work properly and as aspected.

Thanks for resolving the issue in mean time.

Regards,

Jai.