This example enables the top border of the range(A1:E5).
import com.ibm.symphony.javaapi.Application; import com.ibm.symphony.javaapi.Border; import com.ibm.symphony.javaapi.Constant; import com.ibm.symphony.javaapi.spreadsheet.Range; import com.ibm.symphony.javaapi.spreadsheet.Sheet; import com.ibm.symphony.javaapi.spreadsheet.Spreadsheet; import com.ibm.symphony.javaapi.spreadsheet.Spreadsheets; public class BorderExample { public void example() { try { Application application = Application.getInstance(); Spreadsheets spreadsheets = application.getSpreadsheets(); Spreadsheet spreadsheet = spreadsheets.openSpreadsheet( "D:\\test.ods", true); Sheet sheet = spreadsheet.getActiveSheet(); Range range = sheet.range("A1:E5"); Border border = range.borders(Constant.SYMPHONY_BORDER_TOP); border.setBorder(true); border.setColor(application.RGB(255, 0, 0)); border.setInnerLineWidth(100); border.setInnerOuterDistance(100); border.setOuterLineWidth(100); } catch (Exception e) { e.printStackTrace(); } } }
Related information