Category Archives: 工具軟體

[Java] Write xls files

Posted on 2015 年 11 月 02 日 by cowman.chiang

public String createFile(Object object) { try { Excel excel = (Excel) object; HSSFWorkbook hssfWorkbook = new HSSFWorkbook(); for (SheetContent sheetContent:excel.getSheets()) { HSSFSheet sheet = hssfWorkbook.createSheet(sheetContent.getName()); List<HSSFCellStyle> formats = new ArrayList<>(); /** format */ for (String format:sheetContent.getFormats()) { HSSFCellStyle cs = … Continue reading →

Posted in Excel, Java | Leave a comment

[Intellij] Can’t start git

Posted on 2015 年 09 月 21 日 by cowman.chiang

After Mac OS X upgrading, something happen in the Intellij. screenshot Then we should enable the Xcode license again. sudo xcodebuild -license Ref. OSX Mavericks and Git Error

Posted in Intellij, Mac | Tagged , | Leave a comment

[Vim] Turn on/off line numbers

Posted on 2015 年 08 月 12 日 by cowman.chiang

Ref. stackoverflow: how to take off line numbers in vi turn on :set nu turn off :set nu!

Posted in Vim | Tagged | Leave a comment

[.Net] OLEDB in Windows x64 error.

Posted on 2015 年 06 月 26 日 by cowman.chiang

Ref. 解決64位元主機上IIS無法跑32位元的元件:Jet OLEDB 4

Posted in Visual Studio | Leave a comment

Install Windows 10 preview in virtualbox

Posted on 2015 年 05 月 12 日 by cowman.chiang

Ref: http://www.sysprobs.com/install-windows-10-on-virtualbox-and-its-guest-additions

Posted in Virtualbox, Windows | Leave a comment

[Cloudera HBase] Install Cloudera HBase in Ubuntu 14.04 x64

Posted on 2015 年 03 月 22 日 by cowman.chiang

Install Oracle Sun Java 1.7. Add Repository. sudo add-apt-repository ppa:webupd8team/java Repository update. sudo apt-get update Install Java 1.7. sudo apt-get install oracle-java7-installer Install Java Environment Variable. sudo apt-get install oracle-java7-set-default Cloudera HBase Ref 1. – Installing the Latest CDH 5 … Continue reading →

Posted in Cloudera, HBase | Leave a comment

[Java] Eclipse IDE.

Posted on 2015 年 03 月 13 日 by cowman.chiang

Download and install JDK. Edit Windows Environment setting. (Advanced system settings => Advance => Environment variables => Choose Path and click edited => Add the location of the bin folder of the JDK installation.) Ex: “C:Program Files (x86)Javajre1.8.0_31bin” Check the … Continue reading →

Posted in Eclipse, Java | Leave a comment

[Excel] Find the latest value

Posted on 2015 年 03 月 04 日 by cowman.chiang

If we want use excel to get the value F. F = A * B * C * D * E The common method is using the upper mathematical formulas. But if we adjust the columns, we may get the … Continue reading →

Posted in Excel | Leave a comment

[Sublime Text] Enable BIG5 support

Posted on 2015 年 02 月 11 日 by cowman.chiang

In default, sublime text editor does not support BIG5 character, so you must install “ConvertToUTF8” package.

Posted in Sublime Text 2 | Leave a comment

[Splunk] Get the quota exceeded count

Posted on 2015 年 02 月 03 日 by cowman.chiang

When we want to find some way to get the count of the quota exceed event, we might find this page “Splunk > Wiki : Community:TroubleshootingIndexedDataVolume Troubleshooting Indexed Data Volume”. Then we could use the following to get the count. … Continue reading →

Posted in Splunk | Leave a comment