|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_integration/requirement/application/ecomplain/xls_class/ |
Upload File : |
ࡱ > L N K q` TB bjbjqPqP 4N : : ? ~ ~ ~ ~ ~ ~ ~ d > V l l l l G G G } $ 4 h > ~ G G G G G ~ ~ l l < 1 1 1 G N ~ l ~ l } 1 G } 1 1 ~ ~ 1 l J ` N 1 Y $ R 0 1
1 ~ 1 ( G G 1 G G G G G '
G G G G G G G 6 6 ~ ~ ~ ~ ~ ~ @#7H-!7-*3+#12#*#I2D %L E x c e l 1 . P H P W r i t e E x c e l C l a s s *3+#1*#I2D %L E x c e l 2'LB+%DI2 H Y P E R L I N K " h t t p : / / w w w . b e t t i n a - a t t a c k . d e / j o n n y / v i e w . p h p / p r o j e c t s / p h p _ w r i t e e x c e l " h t t p : / / w w w . b e t t i n a - a t t a c k . d e / j o n n y / v i e w . p h p / p r o j e c t s / p h p _ w r i t e e x c e l '452#@5"C+I P H P *2!2# E x p o r t --!2@G E x c e l 1 . @!7H-2'LB+%D %L P H P W r i t e E x c e l C l a s s !2A%I'G32#A% D i r e c t o r y D+GDI0#1"1'-"H2@
H / h o m e / p h p e x c e l 2 . C D i r e c t o r y / h o m e / p h p e x c e l C+I@-2AHD %L5H!5
7H-6III'" c l a s s . * !2-1I%DDI@%"#1 3 . CD %L c l a s s . w r i t e e x c e l _ w o r k s h e e t . i n c . p h p C+ID+23'H2 $ f h = f o p e n ( $ t h i s - > _ t m p f i l e n a m e , " w + b " ) ; -@-A%I' C o m m e n t I'" # I2+I2*8-##1@%"#1 4 . CD %L c l a s s . w r i t e e x c e l _ w o r k s h e e t . i n c . p h p C+I+23'H2 $ t h i s - > _ p r i n t _ g r i d l i n e s = 1 ; C+IAI@G $ t h i s - > _ p r i n t _ g r i d l i n e s = 0 ; 5 . '452#@5"B#A#!C+I E x p o r t --!2@G E x c e l "1!5H-#1%4-H2H-DI@%"#1
r e q u i r e _ o n c e " / h o m e / p h p e x c e l / c l a s s . w r i t e e x c e l _ w o r k b o o k . i n c . p h p " ; require_once "/home/phpexcel/class.writeexcel_worksheet.inc.php"; $token = md5(uniqid(rand(), true)); $fname= "../tmp/$token.xls"; $workbook =& new writeexcel_workbook($fname); $worksheet =& $workbook->addworksheet(" I-!9%1(6)25H%0@5"" ) ; $ w o r k s h e e t - > s e t _ m a r g i n _ r i g h t ( 0 . 5 0 ) ; $ w o r k s h e e t - > s e t _ m a r g i n _ b o t t o m ( 1 . 1 0 ) ; # # S e t F o r m a t # # $ x l s c e l l d e s c _ h e a d e r = & $ w o r k b o o k - > a d d f o r m a t ( ) ; $ x l s c e l l d e s c _ h e a d e r - > s e t _ f o nt('Angsana New'); $xlscelldesc_header->set_size(18); $xlscelldesc_header->set_color('black'); $xlscelldesc_header->set_bold(1); $xlscelldesc_header->set_text_v_align(1); $xlscelldesc_header->set_merge(1); $xlsCellDesc =& $workbook->addformat(); $xlsCellDesc->set_font('Angsana New'); $xlsCellDesc->set_size(14); $xlsCellDesc->set_color('black'); $xlsCellDesc->set_bold(1); $xlsCe l l D e s c - > s e t _ a l i g n ( ' l e f t ' ) ; $ x l s C e l l D e s c - > s e t _ t e x t _ v _ a l i g n ( 1 ) ; # # E n d o f S e t F o r m a t # # # # S e t C o l u m n W i d t h & H e i g h t 3+'2!'I2- C e l l $ w o r k s h e e t - > s e t _ c o l u m n ( ' A : B ' , 2 ) ; $ w o r k s h e e t - > s e t _ c o l u m n('B:C', 4); $worksheet->set_column('C:D', 11.29); $worksheet->set_column('D:E', 21); $worksheet->set_column('E:F', 15); $worksheet->set_column('F:G', 32); $celldesc_h = 16.50; ## Writing Data @ 4H!I-!9%%C C e l l $ w o r k s h e e t - > w r i t e _ b l a n k ( A 1 , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e ( B 1 , " I-!9%1(6)25H%0@5" 2@#5"5H $ s e m e s t e r 52#(6)2 $ y e a r " , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e _ b l a n k ( C 1 , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e _ b l a n k ( D 1 , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e _ b l a n k ( E 1 , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e _ b l a n k ( F 1 , $ x l s c e l l d e s c _ h e a d e r ) ; # 3+'2!*9- C e l l $ : F
2
:
H
V
h
t
L x ~ 2 D P R ҽyҽd )h[ h[ B*CJ OJ QJ ^J aJ ph %h[ h[ B*CJ OJ QJ ^J phW 2j h[ h[ B*CJ OJ QJ U^J aJ ph ,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph +h[ h[ 5B*CJ OJ QJ \^J ph .h[ h[ 5B*CJ OJ QJ \^J ph & N A A RB TB d8 K gd[ N kd $$If ^)
)6 3 4 `
a p
d8 $If gd[ d8 gd[ TB
8
B
F
|
0 F Z \ J P f վվվվթվՔվվ|gR )h[ h[ B* CJ OJ QJ ^J aJ ph w )h[ h[ B* CJ OJ QJ ^J aJ ph .h[ h[ 5B*CJ OJ QJ \^J ph )h[ h[ B* CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph ,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph
@ N U W Z [ a b f j n 6 T h l T | Ք )h[ h[ B*CJ OJ QJ ^J aJ ph ,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph w )h[ h[ B*CJ OJ QJ ^J aJ ph : 2 4 < = ? N a c l m t $ ' 0 2 ; K W Y a b o ~ $ & 2 P h l )h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph w )h[ h[ B* CJ OJ QJ ^J aJ ph H 4 X z
# % / 0 5 7 < K U W a b g i k z ( 꾩 )h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph w )h[ h[ B* CJ OJ QJ ^J aJ ph ,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph :( * D X \ r t x z 8 L ` n r 0 D H ^ ` d f $ 8 Կ~~ ,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph w )h[ h[ B* CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph ,h[ h[ B*CJ OJ QJ ^J aJ ph 18 < R T X Z 0 0 0 $0 &0 (0 ,0 B0 b0 v0 z0 0 0 0 0 0 0 0 0 0 0 0 0 1 &1 :1 >1 L1 N1 P1 T1 j1 1 1 1 1 1 1 1 1 2 2 2 &2 (2 ,2 02 է U,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph w :w o r k s h e e t - > s e t _ r o w ( 1 , $ c e l l d e s c _ h ) ; $ w o r k s h e e t - > s e t _ r o w ( 2 , $ c e l l d e s c _ h ) ; $ w o r k s h e e t - > s e t _ r o w ( 3 , $ c e l l d e s c _ h ) ; $ w o r k s h e e t - > s e t _ r o w ( 4 , $ c e l l d e s c _ h ) ; $ w o r k s h e e t - > s e t _ r o w ( 5 , $ c e l l d e s c _ h ) ; $ w o r k s h e e t - > w r i t e ( B 4 , " #+1*'4
2 : " , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e ( D 4 , " $ c o u r s e n o " , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e ( B 6 , " 5H" , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e ( C 6 , " #+1*1(6)2" , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e ( D 6 , "
7H- - 2!*8%" , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e _ b l a n k ( E 6 , $ x l s c e l l d e s c _ h e a d e r ) ; $ w o r k s h e e t - > w r i t e ( F 6 , " " , $ x l s c e l l d e s c _ h e a d e r ) ; $ x l s R o w = 7 ; # #5I7-6I-!9%2 m y s q l !2C*HC C e l l w h i l e ( l i s t ( $ i d , $ p r e n a m e , $ n a m e , $ s n a m e ) = m y s q l _ f e t c h _ r o w ( $ r e s u l t ) ) { + + $ i ; $ w o r k s h e e t - > s e t _ r o w ( $ x l s R o w , 1 9 . 8 0 ) ; $ w o r k s h e e t - > w r i t e ( " B $ x l s R o w " , " $ i " , $ x l s C e l l D e s c ) ; $ w o r k s h e e t - > w r i t e ( " C $ x l s R o w " , " $ i d " , $ x l s C e l l D e s c ) ; $ w o r k s h e e t - > w r i t e ( " D $ x l s R o w " , " $ p r e n a m e $ n a m e " , $ x l s C e l l D e s c ) ; $ w o r k s h e e t - > w r i t e ( " E $ x l s R o w " , " $ s n a m e " , $ x l s C e l l D e s c ) ; $ w o r k s h e e t - > w r i t e ( " F $ x l s R o w " , " . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . " , $ x l s C e l l D e s c ) ; $ x l s R o w + + ; } # @*#GA%I'G*HD %LD"1 B r o w s e r #1AH5IG@*#GA%I' $ w o r k b o o k - > c l o s e ( ) ; h e a d e r ( " P r a g m a : p u b l i c " ) ; h e a d e r ( " E x p i r e s : 0 " ) ; h e a d e r ( " C a c h e - C o n t r o l : m u s t - r e v a l i d a t e , p o s t - c h e c k = 0 , p r e - c h e c k = 0 " ) ; h e a d e r ( " C o n t e n t - T y p e : a p p l i c a t i o n / f o r c e - d o w n l o a d " ) ; h e a d e r ( " C o n t e n t - T y p e : a p p l i c a t i o n / o c t e t - s t r e a m " ) ; h e a d e r ( " C o n t e n t - T y p e : a p p l i c a t i o n / d o w n l o a d " ) ; h e a d e r ( " C o n t e n t - D i s p o s i t i o n : a t t a c h m e n t ; f i l e n a m e = " . b a s e n a m e ( "
7H-D %L. x l s " ) . " ; " ) ; h e a d e r ( " C o n t e n t - T r a n s f e r - E n c o d i n g : b i n a r y " ) ; h e a d e r ( " C o n t e n t - L e n g t h : " . f i l e s i z e ( $ f n a m e ) ) ; r e a d f i l e ( $ f n a m e ) ; u n l i n k ( $ f n a m e ) ; e x i t ( ) ; 6 . @ 5"@H25IH2G*2!2#3 R e p o r t 5H P r i n t --!2*'"+#9A!"1@-2DC
I3'DII'" E x c e l
02 62 L2 P2 v2 2 2 2 2 2 2 2 2 2 3 (3 <3 @3 J3 L3 P3 R3 T3 \3 `3 3 3 3 3 3 3 3 3 3 3 3 4 44 H4 L4 V4 X4 \4 ^4 `4 l4 n4 ~4 4 4 4 4 4 4 4 4 4 "5 @5 T5 X5 b5 d5 h5 j5 p5 t5 Ӿ꾩ӾӾӾ )h[ h[ B* CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph w ,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph Bt5 5 5 5 5 5 5 5 6 (6 86 b6 x6 ~6 6 6 6 6 6 6 6 6 6 6 7 7 J7 ^7 b7 p7 r7 7 7 7 7 7 7 7 7 7 8 8 8 $8 Z8 n8 r8 |8 ~8 8 8 8 8 8 8 9 9 9 9 ՔՔՔՔ )h[ h[ B*CJ OJ QJ ^J aJ ph ,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph w )h[ h[ B* CJ OJ QJ ^J aJ ph :9 ,9 09 N9 R9 j9 9 9 9 9 9 9 9 9 9 : >: R: V: `: b: v: z:
; ; &; N; \; ; ; ; ; < *< << @< J< r< ~< < < < < < < = = = = = = = > F> R> T> > > > ի ,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph w )h[ h[ B*CJ OJ QJ ^J aJ ph :> > ? F? R? T? ? ? ? ? ? ? ? ? ? @ @ @ b@ @ @ @ @ @ @ @ @ A A A A HA TA VA bA A A A A A A A A թꔃll ,h[ h[ B*CJ OJ QJ ^J aJ ph h[ h[ CJ OJ QJ ^J aJ )h[ h[ B*CJ OJ QJ ^J aJ ph ,h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph )h[ h[ B*CJ OJ QJ ^J aJ ph )h[ h[ B* CJ OJ QJ ^J aJ ph w *A DB RB TB hR )h[ h[ B*CJ OJ QJ ^J aJ ph ,h[ h[ B*CJ OJ QJ ^J aJ ph 2 1h:p[ . A!"#$% $$If !v h5 )#v ):V
)6 , 5 3 4 `
p
L @ L N o r m a l $ CJ OJ QJ ^J _H aJ mH sH tH D A@ D D e f a u l t P a r a g r a p h F o n t R i@ R T a b l e N o r m a l 4
l 4 a ( k@ ( N o L i s t B U` B [ H y p e r l i n k 57>* S*Y( \phW \ ^` \ [ N o r m a l ( W e b ) d8 K B*CJ OJ QJ ^J aJ ph * W` * [ S t r o n g 5\ ? N > A @ 0 X I 0 @ 0 @ 0 X 0 > A K 0 I 0 0 @ 0 0 0> ( 8 02 t5 9 > A TB " # $ % & TB TB o ? X 8 @ 0 (
B
S ? / 9 @ P V e $ + 4 C V Z d k ~ " ( ) K L X Z \ ] b k v y | # - 6 E S j q { ? [ a
$ @ P p * < > F Y k m v " - < E V a c k m t 3 > @ P / 9 a k
%
)
*
C
N
9 D v ' , 6 R Y ^ h 0
9
>
P
z
E K L S W i
# ( ) 1 R j l {
' U ] h s
G O V \ s { } 7 A + B C V ! " ( ) K S j W [ A 3 3 3 3 3 3 A A R [ A @
=
? @ @
@ @ @ @ @ @ ( @ @ @ 0 @ @ @ @ 0 U n k n o w n G z T i m e s N e w R o m a n 5 S y m b o l 3& z A r i a l 5& z a T a h o m a ? A n g s a n a N e w C& B r o w a l l i a N e w A& B r o w a l l i a U P C " q h M&N& +
& +
& ! 24 5 5 2 HX ( ? j [ 2 o w n e r o w n e r Oh +'0 X
, 8 @ H P j owner Normal.dot owner 2 Microsoft Office Word @ F# @ ^N@ N + ՜. +,D ՜. +,4 h p
j Microsoft &
5 Title 8 @ _PID_HLINKS j A a D h t t p : / / w w w . b e t t i n a - a t t a c k . d e / j o n n y / v i e w . p h p / p r o j e c t s / p h p _ w r i t e e x c e l M
! " # $ % & ' ) * + , - . / 1 2 3 4 5 6 7 8 9 : < = > ? @ A B D E F G H I J M R o o t E n t r y F @NO D a t a
( 1 T a b l e 0 W o r d D o c u m e n t 4N S u m m a r y I n f o r m a t i o n ( ; D o c u m e n t S u m m a r y I n f o r m a t i o n 8 C C o m p O b j q
F Microsoft Office Word Document
MSWordDoc Word.Document.8 9q