영카트 엑셀 출력시 한글깨짐 채택완료

그누보드5는 php_writeexcel http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/">http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/

을 사용합니다.

엑셀 다운 파일을 보면....

_excel.php 가 붙어있을 거구요.

한 예를 드리자면...

include_once('./_common.php');

$sql = " SELECT * FROM {$g5['테이블명']} ORDER BY idx desc ";

$result = sql_query($sql);

include_once(G5_LIB_PATH.'/Excel/php_writeexcel/class.writeexcel_workbook.inc.php'); include_once(G5_LIB_PATH.'/Excel/php_writeexcel/class.writeexcel_worksheet.inc.php'); 

$fname = tempnam(G5_DATA_PATH, "tmp-attention-list".date("ymdhis", time()).".xls"); $workbook = new writeexcel_workbook($fname); $worksheet = $workbook->addworksheet();

// Put Excel data $data1 = array('번호', '성명', '주소', '우편번호', '핸드폰', '핸드폰수신여부', '이메일', '이메일수신여부', '선호타입', '등록일시', '수정일시'); $data1 = array_map('iconv_euckr', $data1);

$worksheet->set_column(0, 0, 10); $worksheet->set_column(1, 1, 20); $worksheet->set_column(2, 2, 80); $worksheet->set_column(3, 11, 30);

$col = 0; $heading_help =& $workbook->addformat(array('align' => 'center', 'bold' => 1, 'fg_color' => 'yellow', 'border' => 1, 'font'=>'돋음')); foreach($data1 as $cell) {     $worksheet->write(0, $col++, $cell, $heading_help); }

$center  =& $workbook->addformat(array('align' => 'center', 'font'=>'돋음')); for($i=1; $row=sql_fetch_array($result); $i++) {

    $row = array_map('iconv_euckr', $row);

    $worksheet->write($i, 0, $i, $center);     $worksheet->write($i, 1, $row['name'], $center);      $worksheet->write($i, 2, $row['address1']." ".$row['address2']." ".$row['address3'], $center);     $worksheet->write($i, 3, $row['post_new'], $center);

 $worksheet->write($i, 4, $row['hp1']."-".$row['hp2']."-".$row['hp3'], $center);     $worksheet->write($i, 5, $row['hp_agree'], $center);     $worksheet->write($i, 6, $row['email'], $center);     $worksheet->write($i, 7, $row['email_agree'], $center);

    $worksheet->write($i, 8, $row['suntype'], $center);

    $worksheet->write($i, 9, $row['regdate'], $center);     $worksheet->write($i, 10, $row['moddate'], $center); }

$workbook->close();

header("Content-Type: application/x-msexcel; name=\"attention_custom_".date("ymdhis", time()).".xls\""); header("Content-Disposition: inline; filename=\"attention_custom_".date("ymdhis", time()).".xls\""); $fh=fopen($fname, "rb"); fpassthru($fh); unlink($fname); ?>

파일은 UTF-8 이구요.​