I want to set page when print. I used:
sheet1.PrintSetup.FooterMargin = 0;
sheet1.PrintSetup.HeaderMargin = 0;
sheet1.PrintSetup.Scale = 100;
sheet1.PrintSetup.FitHeight = 1;
sheet1.PrintSetup.FitWidth = 1;
But I view print view, Margin top and bottom very large. I want to it is small.
And I want to set cell padding and word wrap, Please give me how to?