PHPExcel 질문입니다. 채택완료

RINIX 10년 전 조회 9,465

</p><p>$objPHPExcel->getActiveSheet()->setCellValue('A'.$i,  '01');// NOT NULL 일반전자세금계산서는 '01', 영세율전자세금계산서는 '02'를 입력.
$objPHPExcel->getActiveSheet()->setCellValue('BG'.$i,  '01');// NOT NULL 01(영수), 02(청구)만 입력 가능합니다.</p><p>

엑셀파일을 열면 "01" 이아닌 "1" 수자로 인식합니다.

셀서식을 텍스트로 바꾸는 방법좀 알려주세요.^^

#php

댓글을 작성하려면 로그인이 필요합니다.

답변 3개

정렬:

채택된 답변

+20 포인트

카츠

10년 전

setCellValue('A'.$i, '01');

concatenate 엑셀 문자열병합 함수로 집어넣어 보세요.

PHPExcel 에서 지원하는지는 해당 라이브러리를 안봐서 모르겠으나

그누에 기본 포함된 라이브러리인 php_writeexcel 에서는 무리없던 방법입니다.

setCellValue('A'.$i, '=CONCATENATE("0", "1")');

로그인 후 평가할 수 있습니다

답변에 대한 댓글 2개

RINIX

10년 전

아주 잘 됍니다..^^
감사합니다..^^

홈텍스에서도 잘 받아 들이네요..^^

정말 감사합니다.. ^^

�

카츠

10년 전

네~ 잘 해결되신모양이네요. ^^

댓글을 작성하려면 로그인이 필요합니다.

미니어스

10년 전

아래 붉은색처럼 추가하셔도 됩니다.

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, '\'01');// NOT NULL 일반전자세금계산서는 '01', 영세율전자세금계산서는 '02'를 입력.

ps. 댓글기능에 버그가있네요 CSS extention이 먹는거면 XSS 버그일텐데..;;;

로그인 후 평가할 수 있습니다

댓글을 작성하려면 로그인이 필요합니다.

미니어스

10년 전


                
                </code></p><p><code class="variable" style="line-height: 23.5440006256104px; font-size: 13.0799999237061px; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; color: rgb(170, 119, 0) !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(255, 255, 255); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">$objPHPExcel</code><code class="plain" style="line-height: 23.5440006256104px; font-size: 13.0799999237061px; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(255, 255, 255); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">->getActiveSheet()->setCellValue(</code><code class="string" style="line-height: 23.5440006256104px; font-size: 13.0799999237061px; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; color: blue !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(255, 255, 255); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">'A'</code><code class="plain" style="line-height: 23.5440006256104px; font-size: 13.0799999237061px; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(255, 255, 255); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">.</code><code class="variable" style="line-height: 23.5440006256104px; font-size: 13.0799999237061px; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; color: rgb(170, 119, 0) !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(255, 255, 255); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">$i</code><code class="plain" style="line-height: 23.5440006256104px; font-size: 13.0799999237061px; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(255, 255, 255); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">,  </code><code class="string" style="line-height: 23.5440006256104px; font-size: 13.0799999237061px; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; color: blue !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(255, 255, 255); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">'\'01'</code><code class="plain" style="line-height: 23.5440006256104px; font-size: 13.0799999237061px; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(255, 255, 255); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">);</code><code class="comments" style="line-height: 23.5440006256104px; font-size: 13.0799999237061px; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; color: rgb(0, 130, 0) !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(255, 255, 255); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">// NOT NULL 일반전자세금계산서는 '01', 영세율전자세금계산서는 '02'를 입력.</code><span style="font-size: 10pt; line-height: 1.5;"></span></p><p><span style="font-size: 10pt; line-height: 1.5;">



                                    
                                    
                                        
                                                                                            
                                                    로그인 후 평가할 수 있습니다



                                
                                
                                    
                                        
                                        
                                        
                                
                                                                
                                                                
                                
                                                                    
                                        
                                            댓글을 작성하려면 로그인이 필요합니다.


            
            
            
            
            
                            
                    답변을 작성하려면 로그인이 필요합니다.
                    
                        로그인



        
        

    
    
        
            
            지금 질문하기
        
    

    
    
        
            
                질문하는방법
            
        
        
            
                모든질문
                129,277
            
            
                답변없는질문
                1
            
            
                미채택된질문
                18,375
            
            
                채택된질문
                101,681
            
        
        모든답변
        
            
                5
                그누보드5
                62,905
            
            
                영카트5
                17,535
            
        
        
            
                태그전체보기
            
        
        
                    
    

    
    
        관심태그
        
                                                        
                    #영카트5
                
                                            
                    #그누보드4
                
                                            
                    #영카트4
                
                                            
                    #정규식
                
                                            
                    #테마
                
                                            
                    #그누보드5
                
                                            
                    #네이버페이
                
                                            
                    #그누커머스
                
                                            
                    #php
                
                                            
                    #그누보드6
                
                    
    

    
    
        인기태그
        
                                                        
                    #그누보드5
                                            (62,905)
                                    
                                            
                    #영카트5
                                            (17,535)
                                    
                                            
                    #php
                                            (15,830)
                                    
                                            
                    #그누보드4
                                            (10,649)
                                    
                                            
                    #게시판
                                            (3,273)
                                    
                                            
                    #javascript
                                            (2,678)
                                    
                                            
                    #그누보드
                                            (2,463)
                                    
                                            
                    #css
                                            (2,129)
                                    
                                            
                    #mysql
                                            (1,556)
                                    
                                            
                    #영카트
                                            (1,295)
                                    
                                            
                    #모바일
                                            (1,293)
                                    
                                            
                    #그누커머스
                                            (1,178)
                                    
                                            
                    #html
                                            (1,133)
                                    
                                            
                    #jquery
                                            (1,027)
                                    
                                            
                    #최신글
                                            (970)
                                    
                                            
                    #자바스크립트
                                            (953)
                                    
                                            
                    #DB
                                            (850)
                                    
                                            
                    #로그인
                                            (821)
                                    
                                            
                    #이미지
                                            (785)
                                    
                                            
                    #여분필드
                                            (784)





    
        
            
                공유하기
                
            
            
                
                    
                
                
                    
                
                
            
        
    




    이 게시물을 신고 하시겠습니까?
신고사유를 선택해주세요.
    
        
            
            광고성 게시물
        
        
            
            음란성 게시물
        
        
            
            상대방 비방 및 혐오
        
        
            
            기타
            
                기타 신고사유