엑셀로 다운받기 할 때, 셀 너비 조정 문의입니다.
본문
엑셀 출력할 때, 셀의 너비를 조정하고 싶은데 적용이 안되어 문의드립니다.
검색을 해봤을 때, 하단 명령어로 된다고 하는데 입력하면 엑셀 출력이 되지 않습니다. ㅠㅠ
어떻게 넣어야 할까요 사용하는 코드도 같이 넣었습니다.
$objPHPExcel->getActiveSheet()->getColumnDimension()->setWidth('숫자')
<?php
include_once('./_common.php');
echo '<meta charset="utf-8">';
header("Content-Type: application/vnd.ms-excel");
header("Content-Type: application/x-msexcel");
header("Content-Disposition: attachment; filename=member.xls");
header("Content-Description: PHP4 Generated Data" );
//header("Content-charset=utf-8");
$sql="select * from g5_write_test";
$is_print=sql_fetch($sql);
?>
<html>
<body bgcolor="#FFFFFF">
<table style="table-layout:fixed;">
<table cellspacing="1" >
<thead>
<tr>
<th colspan="5" scope="row" style="border:#333 1px solid;">등록일</th>
<th colspan="12" >--------------</th>
<th colspan="5" >결과</th>
<th colspan="11" >--------------</th>
</tr>
</thead>
</table>
<table cellspacing="1">
<tbody >
<tr>
<td class="qmanse_y" colspan="5" rowspan="7">사진 이미지</td>
<td colspan="3" class="qmanse_td">한글이름</td>
<td colspan="25">------------</td>
</tr>
<tr>
<td colspan="3" class="qmanse_td">영문이름</td>
<td colspan="25">------------</td>
</tr>
<tr>
<td colspan="3" class="qmanse_td">성별</td>
<td colspan="25">------------</td>
</tr>
<tr>
<td colspan="3" class="qmanse_td">생년월일</td>
<td colspan="25">------------</td>
</tr>
<tr>
<td colspan="3" class="qmanse_td">지원부문</td>
<td colspan="25">------------</td>
</tr>
<tr>
<td colspan="3" class="qmanse_td">희망연봉</td>
<td colspan="25">------------</td>
</tr>
<tr>
<td colspan="3" class="qmanse_td">입사가능일</td>
<td colspan="9">------------</td>
<td colspan="5" class="qmanse_td">지원경로</td>
<td colspan="11">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td colspan="5" class="qmanse_td">현근무회사</td>
<td colspan="12" >------------</td>
<td colspan="5" class="qmanse_td">직위</td>
<td colspan="11" >------------</td>
</tr>
<tr>
<td colspan="5" class="qmanse_td">전화번호</td>
<td colspan="12">------------</td>
<td colspan="5" class="qmanse_td">휴대폰번호</td>
<td colspan="11" >------------</td>
</tr>
<tr>
<td colspan="5" class="qmanse_td">이메일</td>
<td colspan="12">------------</td>
<td colspan="5" class="qmanse_td">홈페이지</td>
<td colspan="11">------------</td>
</tr>
<tr>
<td colspan="5" class="qmanse_td">주소</td>
<td colspan="12">------------</td>
<td colspan="5" class="qmanse_td">추천인</td>
<td colspan="11">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="1" rowspan="3">학력사항</td>
<td colspan="16">------------</td>
<td colspan="5">------------</td>
<td colspan="5">------------</td>
<td colspan="6">------------</td>
</tr>
<tr>
<td colspan="16">------------</td>
<td colspan="5">------------</td>
<td colspan="5">------------</td>
<td colspan="6">------------</td>
</tr>
<tr>
<td colspan="16">------------</td>
<td colspan="5">------------</td>
<td colspan="5">------------</td>
<td colspan="6">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="1" rowspan="4">경력사항</td>
<td class="qmanse_y" colspan="6">근무처</td>
<td class="qmanse_y" colspan="3">입사월</td>
<td class="qmanse_y" colspan="3">퇴사월</td>
<td class="qmanse_y" colspan="3">재직여부</td>
<td class="qmanse_y" colspan="3">재직기간</td>
<td class="qmanse_y" colspan="3">부서명</td>
<td class="qmanse_y" colspan="4">담당업무</td>
<td class="qmanse_y" colspan="3">고용형태</td>
<td class="qmanse_y" colspan="4">직위</td>
</tr>
<tr>
<td colspan="6">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="4">------------</td>
<td colspan="3">------------</td>
<td colspan="4">------------</td>
</tr>
<tr>
<td colspan="6">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="4">------------</td>
<td colspan="3">------------</td>
<td colspan="4">------------</td>
</tr>
<tr>
<td colspan="6">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="3">------------</td>
<td colspan="4">------------</td>
<td colspan="3">------------</td>
<td colspan="4">------------</td>
</tr>
</tbody>
</table>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="1" rowspan="4">자격면허</td>
<td class="qmanse_y" colspan="12">자격종류</td>
<td class="qmanse_y" colspan="6">등급</td>
<td class="qmanse_y" colspan="7">취득일</td>
<td class="qmanse_y" colspan="7">발행처</td>
</tr>
<tr>
<td colspan="12">------------</td>
<td colspan="6">------------</td>
<td colspan="7">------------</td>
<td colspan="7">------------</td>
</tr>
<tr>
<td colspan="12">------------</td>
<td colspan="6">------------</td>
<td colspan="7">------------</td>
<td colspan="7">------------</td>
</tr>
<tr>
<td colspan="12">------------</td>
<td colspan="6">------------</td>
<td colspan="7">------------</td>
<td colspan="7">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="1" rowspan="3">외국어</td>
<td class="qmanse_y" colspan="12">시험명</td>
<td class="qmanse_y" colspan="6">시험점수</td>
<td class="qmanse_y" colspan="7">시험일자</td>
<td class="qmanse_y" colspan="7">시험기관</td>
</tr>
<tr>
<td colspan="12">------------</td>
<td colspan="6">------------</td>
<td colspan="7">------------</td>
<td colspan="7">------------</td>
</tr>
<tr>
<td colspan="12">------------</td>
<td colspan="6">------------</td>
<td colspan="7">------------</td>
<td colspan="7">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="1" rowspan="5">가족사항</td>
<td class="qmanse_y" colspan="6">관계</td>
<td class="qmanse_y" colspan="6">성명</td>
<td class="qmanse_y" colspan="6">생년월일</td>
<td class="qmanse_y" colspan="7">직장</td>
<td class="qmanse_y" colspan="7">직위</td>
</tr>
<tr>
<td colspan="6">------------</td>
<td colspan="6">------------</td>
<td colspan="6">------------</td>
<td colspan="7">------------</td>
<td colspan="7">------------</td>
</tr>
<tr>
<td colspan="6">------------</td>
<td colspan="6">------------</td>
<td colspan="6">------------</td>
<td colspan="7">------------</td>
<td colspan="7">------------</td>
</tr>
<tr>
<td colspan="6">------------</td>
<td colspan="6">------------</td>
<td colspan="6">------------</td>
<td colspan="7">------------</td>
<td colspan="7">------------</td>
</tr>
<tr>
<td colspan="6">------------</td>
<td colspan="6">------------</td>
<td colspan="6">------------</td>
<td colspan="7">------------</td>
<td colspan="7">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="1" rowspan="3">장애사항</td>
<td colspan="8">장애종류</td>
<td colspan="9">------------</td>
<td class="qmanse_y" colspan="1" rowspan="3">국가보훈</td>
<td colspan="6">보훈여부</td>
<td colspan="8">------------</td>
</tr>
<tr>
<td colspan="8">장애급수</td>
<td colspan="9">------------</td>
<td colspan="6">보훈번호</td>
<td colspan="8">------------</td>
</tr>
<tr>
<td colspan="8">신체건강상 특이점</td>
<td colspan="9">------------</td>
<td colspan="6">관계</td>
<td colspan="8">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="1" rowspan="3">병력사항</td>
<td class="qmanse_y" colspan="5">군별</td>
<td class="qmanse_y" colspan="5">병과</td>
<td class="qmanse_y" colspan="5">계급</td>
<td class="qmanse_y" colspan="13">복무기간</td>
<td class="qmanse_y" colspan="4">제대구분</td>
</tr>
<tr>
<td colspan="5">------------</td>
<td colspan="5">------------</td>
<td colspan="5">------------</td>
<td colspan="13">------------</td>
<td colspan="4">------------</td>
</tr>
<tr>
<td colspan="5">------------</td>
<td colspan="5">------------</td>
<td colspan="5">------------</td>
<td colspan="13">------------</td>
<td colspan="4">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="1" rowspan="2">인적</td>
<td class="qmanse_y" colspan="4">신장</td>
<td class="qmanse_y" colspan="4">체중</td>
<td class="qmanse_y" colspan="4">혈액형</td>
<td class="qmanse_y" colspan="6">시력</td>
<td class="qmanse_y" colspan="4">종교</td>
<td class="qmanse_y" colspan="5">취미</td>
<td class="qmanse_y" colspan="5">특기</td>
</tr>
<tr>
<td colspan="4">------------</td>
<td colspan="4">------------</td>
<td colspan="4">------------</td>
<td colspan="6">------------</td>
<td colspan="4">------------</td>
<td colspan="5">------------</td>
<td colspan="5">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="33">기술경력서</td>
</tr>
<tr style="height:250px;">
<td colspan="33">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="33">지원동기</td>
</tr>
<tr style="height:250px;" >
<td colspan="33">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="33">역량 및 경험</td>
</tr>
<tr style="height:250px;">
<td colspan="33">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="33">성과경험</td>
</tr>
<tr style="height:250px;">
<td colspan="33">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y colspan="33">성격의 장단점</td>
</tr>
<tr style="height:250px;">
<td colspan="33">------------</td>
</tr>
</tbody>
</table>
<table style="width:100%; margin-top:10px;" cellspacing="1">
<tbody>
<tr>
<td class="qmanse_y" colspan="33">첨부파일</td>
</tr>
<tr>
<td colspan="33">첨부파일 1</td>
</tr>
</tbody>
</table>
</table>
</body>
</html>
답변 1
td나 table에 width값을 px로 넣어보세요. 조정됩니다.
말씀주신대로 적용해봤는데, colspan으로 합쳐서 그런지 너비가 적용되지 않습니다.
그냥 모든 셀의 너비를 30px로 하고 싶은데, 그런 방법은 없을까요?
<?php
include_once('./_common.php');
echo '<meta charset="utf-8">';
$sql_common = " from {$g5['g5_write_test']} ";
header("Content-Type: application/vnd.ms-excel");
header("Content-Type: application/x-msexcel");
header("Content-Disposition: attachment; filename=member.xls");
header("Content-Description: PHP4 Generated Data" );
//header("Content-charset=utf-8");
?>
<html>
<body style="text-align:center;">
<table style="width:790px; text-align:center;">
<tr>
<td width="150px" colspan="5" scope="row" style="border:#333 1px solid;">등록일</td>
<td width="360px" colspan="12" >--------------</td>
<td width="150px" colspan="5" >결과</td>
<td width="130px" colspan="11" >--------------</td>
</tr>
<tr>
<td class="qmanse_y" width="150px" colspan="5" rowspan="7">사진 이미지</td>
<td width="90px" colspan="3" class="qmanse_td">한글이름</td>
<td width="750px" colspan="25">------------</td>
</tr>
<tr>
<td width="90px" colspan="3" class="qmanse_td">영문이름</td>
<td width="750px" colspan="25">------------</td>
</tr>
<tr>
<td width="90px" colspan="3" class="qmanse_td">성별</td>
<td width="750px" colspan="25">------------</td>
</tr>
<tr>
<td width="90px" colspan="3" class="qmanse_td">생년월일</td>
<td width="750px" colspan="25">------------</td>
</tr>
<tr>
<td width="90px" colspan="3" class="qmanse_td">지원부문</td>
<td width="750px" colspan="25">------------</td>
</tr>
<tr>
<td width="90px" colspan="3" class="qmanse_td">희망연봉</td>
<td width="750px" colspan="25">------------</td>
</tr>
<tr>
<td width="90px" colspan="3" class="qmanse_td">입사가능일</td>
<td width="270px" colspan="9">------------</td>
<td width="150px" colspan="5" class="qmanse_td">지원경로</td>
<td width="330px" colspan="11">------------</td>
</tr>
</table>
</body>
</html>
답변을 작성하시기 전에 로그인 해주세요.
