Hendi Santika hendisantika

Basics

Creating a new PHPExcel Object.

    $this->PHPExcel = new PHPExcel();

Working with sheets

Creating a new sheet:

#Intro

Kotlin is a new programming language for the JVM. It produces Java bytecode, supports Android and generates JavaScript. The latest version of the language is Kotlin M5.3

Kotlin project website is at kotlin.jetbrains.org.

All the codes here can be copied and run on Kotlin online editor.

Let's get started.

Remove MySQL completely

Open the Terminal
Use mysqldump to backup your databases
Check for MySQL processes with: ps -ax | grep mysql
Stop and kill any MySQL processes
Analyze MySQL on HomeBrew:

brew remove mysql

Command Line Tools for Xcode

Command line tools comes bundle with Xcode prior to 4.3 version. After 4.3, you need to install a separated command line tools yourself.

First, go to this url and login using Apple Developer account (Free to register)

https://developer.apple.com/downloads/index.action

Common Options

-#, --progress-bar Make curl display a simple progress bar instead of the more informational standard meter.

-b, --cookie <name=data> Supply cookie with request. If no =, then specifies the cookie file to use (see -c).

-c, --cookie-jar <file name> File to save response cookies to.

Installing Oracle 11g on OS X 10.11 El Capitan

Download and install Vagrant
Download and install VirtualBox
Download and install Oracle SQL Developer
Download the Oracle 11g zip file for Linux x64. Always download the Linux x64 zip file, even if you are on Windows or Mac OSX.
Clone the vagrant-ubuntu-oracle-xe repository from GitHub

git clone git://github.com/hilverd/vagrant-ubuntu-oracle-xe

	import java.awt.EventQueue;
	import javax.swing.JFrame;
	import javax.swing.JPanel;
	import javax.swing.border.EmptyBorder;
	import javax.swing.border.MatteBorder;
	import java.awt.Color;
	import javax.swing.JCheckBox;
	import javax.swing.JButton;
	import javax.swing.ImageIcon;
	import java.awt.event.MouseAdapter;

	//Method Only

	@SuppressWarnings("rawtypes")
	@RequestMapping(value = "/cityGridView", method = RequestMethod.GET)
	public @ResponseBody
	Object[] showLineChart(Map<String, Object> map, HttpServletRequest request,
	HttpServletResponse response) {
	List<MapTable> list = contactService.fin();
	Object[] rows = new Object[list.size()];
	int i = 0;

	import java.io.FileInputStream;
	import java.io.FileOutputStream;
	import java.io.IOException;
	import java.io.InputStream;
	import java.util.Iterator;

	import org.apache.poi.hssf.usermodel.HSSFCell;
	import org.apache.poi.hssf.usermodel.HSSFRow;
	import org.apache.poi.hssf.usermodel.HSSFSheet;
	import org.apache.poi.hssf.usermodel.HSSFWorkbook;

	# request.xml
	<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wst="http://sensedia.com/repository/wstoolkit">
	<soapenv:Header>
	<wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
	<wsse:UsernameToken wsu:Id="UsernameToken-1">
	<wsse:Username>system</wsse:Username>
	<wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">manager</wsse:Password>
	<wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">DWk64SMfJ6RxHAKgPRGtPA==</wsse:Nonce>
	<wsu:Created>2013-04-17T18:36:54.013Z</wsu:Created>
	</wsse:UsernameToken>