Example: Border

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

Border