안드로이드 jxl.jar 엑셀 저장 (Excel save)

안드로이드 jxl.jar 엑셀 저장 (Excel save)

안드로이드에서 디비(sqllite etc)의 내용을 엑셀(xls)로 저장(save)을 하고자 할 때 사용하세요~

1) jxl.jar downlaod site
http://www.java2s.com/Code/Jar/j/jxl.htm

2) lib 폴더에 추가

3) 소스에 라이브러리 import

import jxl.Workbook;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;

4) 내용 작성 

/*

 * 엑셀로 저장하기 

 */ 

public synchronized void saveXls(CategoryItem hmUnit){

final CategoryItem cItem = hmUnit;

String sUnitFilePath = "";

File currentDB = null;

try {

File sd = new File(Environment.getExternalStorageDirectory(), "sampleData");

if (!sd.exists() && !sd.mkdirs()) {

 Log.w(TAG, "Couldn't make dir " + sd);

 return;

}else{

currentDB = new File(sd, hmUnit.getCtTitle()+".xls"); //저장폴더+저장파일(sample_save/sample_note_history.db)

sUnitFilePath = currentDB.getAbsolutePath();    

}

} catch (Exception e) {

Log.i(TAG, ">saveXls : error : " + e.toString());

return;

}

final String sUrl = sUnitFilePath;

final File cDb = currentDB;

new AlertDialog.Builder(actMain).setIcon(

android.R.drawable.ic_dialog_alert)

.setTitle("Notice")

.setMessage("Save xls?\n\nfile path("+sUrl+")") 

.setPositiveButton("Cancel", new DialogInterface.OnClickListener(){ 

public void onClick(DialogInterface dialog, int which){

;

}

}).setNegativeButton("Ok", new DialogInterface.OnClickListener(){

public void onClick(DialogInterface dialog, int which){

 try {

excelWrite(cDb, cItem);

 

Toast.makeText(actMain, "xls saved", Toast.LENGTH_SHORT).show();

 } catch (WriteException e) {

 e.printStackTrace();

 } catch (IOException e) {

 e.printStackTrace();

 }

}

}).show();

}

public void excelWrite(File file, CategoryItem parmItem) throws WriteException, IOException {

 // WorkBook 생성

 WritableWorkbook wb = Workbook.createWorkbook(file);

 // WorkSheet 생성

 WritableSheet sh = wb.createSheet("Folder contents", 0);

 // 열 넓이 설정(열 위치, 넓이)

 sh.setColumnView(0, 10);

 sh.setColumnView(1, 20);

 sh.setColumnView(2, 20);

 sh.setColumnView(3, 20);

 // 셀형식

 WritableCellFormat textFormat = new WritableCellFormat();

 // 생성

 //textFormat.setAlignment(Alignment.ALIGN_CENTER);

 // 테두리

 textFormat.setBorder(Border.ALL, BorderLineStyle.THIN);

 int row = 0;

 // 헤더

 Label label = new jxl.write.Label(0, row, "Enter Dt", textFormat);

 sh.addCell(label);

 label = new jxl.write.Label(1, row, "Update Dt", textFormat);

 sh.addCell(label);

 label = new jxl.write.Label(2, row, "Content", textFormat);

 sh.addCell(label);

 row++;

 

 List<HistoryItem> arDdayInfo = null;

 arDdayInfo = htManager.getHistoryItems(parmItem.getEnterTime(), "", "", "");

 

 for(int i=0; i<arDdayInfo.size(); i++){

 HistoryItem oneUnit = (HistoryItem)arDdayInfo.get(i);

 

  // 등록 일자

  label = new jxl.write.Label(0, row, (String) oneUnit.getDdayYmd(), textFormat);

  sh.addCell(label);

  // 업데이트 일자

  label = new jxl.write.Label(1, row, (String) oneUnit.getAddinfo2(), textFormat);

  sh.addCell(label);

  // 내용

  label = new jxl.write.Label(2, row, (String) oneUnit.getMemoCt(), textFormat);

  sh.addCell(label);

  

  row++;

 }

 

 

 // 워크시트 쓰기

 wb.write();

 // 워크시트 닫기

 wb.close();

 }

----- 

Have a nice day~