Independentsoft
- any library, any programming language
Home
Purchase
Support
Company
Contact
JSpreadsheet
>
Tutorial
> Set Print Area
The following example shows you how to set print area.
import com.independentsoft.office.spreadsheet.DefinedName; import com.independentsoft.office.spreadsheet.SheetView; import com.independentsoft.office.spreadsheet.Workbook; import com.independentsoft.office.spreadsheet.Worksheet; public class Example { public static void main(String[] args) { try { Worksheet sheet1 = new Worksheet(); sheet1.setID(1); sheet1.setName("TestSheet1"); SheetView view1 = new SheetView(); view1.setWorksheetTabSelected(true); view1.setIndex(0); sheet1.getViews().add(view1); DefinedName range1 = new DefinedName("_xlnm.Print_Area"); range1.setLocalSheetID(0); range1.setBody("TestSheet1!$A$1:$B$20"); //print area Workbook book = new Workbook(); book.getSheets().add(sheet1); book.getDefinedNames().add(range1); book.save("c:\\test\\output.xlsx", true); } catch (Exception e) { System.out.println(e.getMessage()); e.printStackTrace(); } } }
Need help? Ask our developers:
Name*
Email*
Message*