How to do print setting through code while exporting excel using EPPLUS

Question

4.00/5 (1 vote)

See more:

I am exporting excel using EPPLUS. i want to do print setting throuhg code. I have tried it also but problem is that if there are so many columns on excel then print is not readable it looks to small. when i increase the excel cell font then only it is readable but i want normal font on excel and print make readable..is there any solution?
i have tried following:

C#

worksheet.Cells.Style.Font.Size = 14;
worksheet.Cells.Style.Font.Name = "Veranda";
worksheet.Cells.Style.WrapText = true;
worksheet.Row(1).Style.WrapText = true;
worksheet.PrinterSettings.PaperSize = ePaperSize.A4;
worksheet.PrinterSettings.FitToPage = true;
worksheet.PrinterSettings.FitToHeight = 150;
worksheet.PrinterSettings.Orientation = eOrientation.Landscape;

I have set font 14 to look print readable but actually i want font 10 and print will look readable.

Posted 2-Feb-15 18:21pm

Member 9579525

Add a Solution

Comments

Herman<T>.Instance 3-Feb-15 3:59am

remove:
worksheet.PrinterSettings.FitToPage = true;
worksheet.PrinterSettings.FitToHeight = 150;

they set it to 1 page

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

shani_759 · Answer 1 · 2016-01-01T01:17:00

Solution to your problem lies within your code. As you have set the paper size to A4 and set the FitToPage property to true, when no of columns increases this property tries to squeeze all the columns in A4 page which make the cell contents hard to read. You can try the following:
1. Remove the property FitToPage = true.
2. Change the paper size of sheet i.e. set paper size to A3 for example that will make cell contents more readable.