Print Area Range String

[waldomirmarkgraf]

hi

i'm trying to set my printing area to fit all rows and columns that contain values, but ws.PageSetup.PrintArea only takes ranges in a string format aka "A1:E8". i don't want to write a helper method that converts ws.Range[1,1,ws.LastRow, ws.LastColumn] to a string range. is there a more convenient way to do this? i simply want to set the printing area to included all data on the sheet.

[Gary.zhang]

Hello,

Thanks for your inquiry.
Please refer to the following method.

Code: Select all

string s = ws.Range[1,1,ws.LastRow, ws.LastColumn].RangeAddressLocal;
sheet.PageSetup.PrintArea = s;


If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team

[Gary.zhang]

Hello,

Have you tested the method? Does it fulfill your need? Could you please give us some feedback if convenience?

If there are any questions, welcome to get it back to us.

Thanks,
Gary
E-iceblue support team

[waldomirmarkgraf]

the code seems to work only that it doesn't do anything. the printing area stays the same. one cell before the last in the columns. even when setting the area manually, PrintArea doesn't seem to be doing anything.

[Gary.zhang]

Hello,

Thanks for your feedback.
Sorry that we don't quite understand what you mean. I have tested the method with Spire.xls7.3, it works fine and it also set the PrintArea, please see the screenshot. The test file is in the attachment. Could you please provide us the following information if the issue persists?
1.Project can reproduce the issue
All code about this problem, a simple project which can reproduce this problem will be better.
2. Test Document or Test data

Code: Select all

 
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"..\..\EditSheetSample.xls");
Worksheet sheet = workbook.Worksheets[0];
string s = sheet.Range[1, 1, sheet.LastRow, sheet.LastColumn].RangeAddressLocal;
sheet.PageSetup.PrintArea = s;
workbook.SaveToFile(@"..\..\result.xls", ExcelVersion.Version97to2003);
System.Diagnostics.Process.Start(@"..\..\result.xls");


Sincerely,
Gary
E-iceblue support team