Spreadsheet additional sheets

From NOA Documentation Wiki

Jump to: navigation, search

Additional sheets in spread sheet documents can be inserted with the insertNewByName(sheetname, index) function of XSpreadsheets. Afterwards, the XSpreadSheet Object can be retained as usual by using the


XSpreadsheets spreadsheets =  myISpreadsheetDocument.getSpreadsheetDocument().getSheets();
// three tables are there by default, add a fourth one
String sheet4name="Test";
			
short newIndex=(short)(spreadsheets.getElementNames().length+1);
			
spreadsheets.insertNewByName(sheet4name, newIndex); 
XSpreadsheet spreadsheet4 = 	(XSpreadsheet)UnoRuntime.queryInterface(XSpreadsheet.class,spreadsheets.getByName(sheet4name));

Personal tools