VFP ·R¥ÎªÌªÀ°Ï ­º­¶ VFP ·R¥ÎªÌªÀ°Ï
¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
 
 ±`¨£°ÝÃD±`¨£°ÝÃD   ·j´M·j´M   ·|­û¦Cªí·|­û¦Cªí   ·|­û¸s²Õ·|­û¸s²Õ   ·|­ûµù¥U·|­ûµù¥U 
 ­Ó¤H¸ê®Æ­Ó¤H¸ê®Æ   µn¤JÀˬd±zªº¨p¤H°T®§µn¤JÀˬd±zªº¨p¤H°T®§   µn¤Jµn¤J

VFP§Þ¥©¤§1

 
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> VFP °Q½×°Ï
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD  
µoªí¤H ¤º®e
Ruey



µù¥U®É¶¡: 2003-03-12
¤å³¹: 1698
¨Ó¦Û: tunglo

²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤T¤ë 21, 2003 11:05 am    ¤å³¹¥DÃD: VFP§Þ¥©¤§1 ¤Þ¨¥¦^ÂÐ

¦bVFP¤¤¥þ­±±±¨îExcel
( §@ªÌ: µJÃÙ±d )


¡@ VFP©MExcel³£¥i¥H¥Î¨Ó¶i¦æ³B²z¸ê®Æ®wªí®æ¡A¦pªG¥©§®¦a±N¤GªÌªºÀuÂIµ²¦X°_¨Ó¡A±N·|¤j¤j¤è«K§Ú­Ìªº¤u§@¡C¤ñ¦p§Ú­Ì¥i¥H§Q¥ÎVFP¶i¦æ³B²z¸ê®Æ¡A¦Ó§Q¥ÎExcelªº¹wÄý¦C¦L¥\¯à¶i¦æ³øªí¦C¦L¡C³o´N»Ý­n§Ú­Ì¦bVFP¤¤ª½±µ¨Ó±±¨îExcel¡C¤U­±´N¦b¶}µoVFPÀ³¥Î±M®×®É¹ïExcelªº±±¨î§@¤@¤U¤¶²Ð¡G
¡@¡@1¡D³Ð«ØExcelª«¥ó
¡@¡@eole=CREATEOBJECT(¡¬Excel.application¡¬)
¡@¡@2¡D²K¥[·s¤u§@ï
¡@¡@eole.Workbooks.add
¡@¡@3¡D³]¸m²Ä3­Ó¤u§@ªí爲±Ò°Ê¤u§@ªí
¡@¡@eole.Worksheets(″sheet3″).Activate
¡@¡@4¡D¥´¶}«ü©w¤u§@ï
¡@¡@eole.Workbooks.Open(″c:\temp\ll.xls″)
¡@¡@5¡DÅã¥ÜExcelµøµ¡
¡@¡@eole.visible=.t.
¡@¡@6¡D§ó§ïExcel¼ÐÃDÄæ
¡@¡@eole.Caption=″VFPÀ³¥Îµ{¦¡½Õ¥ÎMicrosoft Excel″
¡@¡@7¡Dµ¹³æ®æ½á­È
¡@¡@eole.cells(1,4).value=XM(XM爲¸ê®Æ®wÄæ¦ì¦W)
¡@¡@8¡D³]¸m«ü©w¦Cªº¼e«×(³æ¦ì¡G¦r¤¸­Ó¼Æ)
¡@¡@eole.ActiveSheet.Columns(1).ColumnWidth=5
¡@¡@9¡D³]¸m«ü©w¦æªº°ª«×(³æ¦ì¡G½S)
¡@¡@eole.ActiveSheet.Rows(1).RowHeight=1/0.035
¡@¡@(³]©w¦æ°ª爲1Âç¦Ì¡A1½S=0.035Âç¦Ì)
¡@¡@10¡D¦b²Ä18¦æ¤§«e´¡¤J¤À­¶²Å
¡@¡@eole.Worksheets(″Sheet1″).Rows(1Cool.PageBreak=1
¡@¡@11¡D¦b²Ä4¦C¤§«e§R°£¤À­¶²Å
¡@¡@eole.ActiveSheet.Columns(4).PageBreak=0
¡@¡@12¡D«ü©wÃä®Ø½u¼e«×(Borders°Ñ¼Æ¦p¤U)
¡@¡@ole.ActiveSheet.Range(″b3:d3″).Borders(2).Weight=3
¡@¡@13¡D³]¸m¥|­ÓÃä®Ø½u±øªºÃþ«¬
¡@¡@eole.ActiveSheet.Range(″b3:d3″).Borders(2).LineStyle=1
¡@¡@(¨ä¤¤Borders°Ñ¼Æ¡G1¡Ð¥ª¡B2¡Ð¥k¡B3¡Ð³»¡B4¡Ð©³¡B5¡Ð±×¡B6¡Ð±×/¡FLineStyle­È¡G1»P7¡Ð²Ó¹ê¡B2¡Ð²Óµê¡B4¡ÐÂIµê¡B9¡ÐÂù²Ó¹ê½u)
¡@¡@14¡D³]¸m­¶¬Ü
¡@¡@eole.ActiveSheet.PageSetup.CenterHeader=″³øªí1″
¡@¡@15¡D³]¸m­¶¸}
¡@¡@eole.ActiveSheet.PageSetup.CenterFooter=″²Ä¡®P­¶″
¡@¡@16¡D³]¸m­¶¬Ü¨ì³»ºÝÃä¶Z爲2Âç¦Ì
¡@¡@eole.ActiveSheet.PageSetup.HeaderMargin=2/0.035
¡@¡@17¡D³]¸m­¶¸}¨ì©³Ãä¶Z爲3Âç¦Ì
¡@¡@eole.ActiveSheet.PageSetup.FooterMargin=3/0.035
¡@¡@18¡D³]¸m³»Ãä¶Z爲2Âç¦Ì
¡@¡@eole.ActiveSheet.PageSetup.TopMargin=2/0.035
¡@¡@19¡D³]¸m©³Ãä¶Z爲4Âç¦Ì
¡@¡@eole.ActiveSheet.PageSetup.BottomMargin=4/0.035
¡@¡@20¡D³]¸m¥ªÃä¶Z爲2Âç¦Ì
¡@¡@veole.ActiveSheet.PageSetup.LeftMargin=2/0.035
¡@¡@21¡D³]¸m¥kÃä¶Z爲2Âç¦Ì
¡@¡@eole.ActiveSheet.PageSetup.RightMargin=2/0.035
¡@¡@22¡D³]¸m­¶­±¤ô¥­©~¤¤
¡@¡@eole.ActiveSheet.PageSetup.CenterHorizontally=.t.
¡@¡@23¡D³]¸m­¶­±««ª½©~¤¤
¡@¡@eole.ActiveSheet.PageSetup.CenterVertically=.t.
¡@¡@24¡D³]¸m­¶­±¯È±i¤j¤p(1¡Ð¯¶¦æ8úP5úR11 39¡Ð¼e¦æ14úR11)
¡@¡@eole.ActiveSheet.PageSetup.PaperSize=1
¡@¡@25¡D¦C¦L³æ®æºô½u
¡@¡@eole.ActiveSheet.PageSetup.PrintGridlines=.t.
¡@¡@26¡D«þ¨©¾ã­Ó¤u§@ªí
¡@¡@eole.ActiveSheet.UsedRange.Copy
¡@¡@27¡D«þ¨©«ü©w°Ï°ì
¡@¡@eole.ActiveSheet.Range(″A1:E2″).Copy
¡@¡@28¡DÖ߶K
¡@¡@eole.WorkSheet(″Sheet2″).Range(″A1″).PasteSpecial
¡@¡@29¡D¦b²Ä2¦æ¤§«e´¡¤J¤@¦æ
¡@¡@eole.ActiveSheet.Rows(2).Insert
¡@¡@30¡D¦b²Ä2¦C¤§«e´¡¤J¤@¦C
¡@¡@eole.ActiveSheet.Columns(2).Insert
¡@¡@31¡D³]¸m¦rÅé
¡@¡@eole.ActiveSheet.Cells(2,1).Font.Name=″¶ÂÅé″
¡@¡@32¡D³]¸m¦rÅé¤j¤p
¡@¡@eole.ActiveSheet.Cells(1,1).Font.Size=25
¡@¡@33¡D³]¸m¦rÅé爲±×Åé
¡@¡@eole.ActiveSheet.Cells(1,1).Font.Italic=.t.
¡@¡@34¡D³]¸m¾ã¦C¦rÅé爲²ÊÅé
¡@¡@eole.ActiveSheet.Columns(1).Font.Bold=.t.
¡@¡@35¡D²M°£³æ®æ¤½¦¡
¡@¡@eole.ActiveSheet.Cells(1,4).ClearContents
¡@¡@36¡D¦C¦L¹wÄý¤u§@ªí
¡@¡@eole.ActiveSheet.PrintPreview
¡@¡@37¡D¦C¦L¿é¥X¤u§@ªí
¡@¡@eole.ActiveSheet.PrintOut
¡@¡@38¡D¤u§@ªí¥t爲
¡@¡@eole.ActiveWorkbook.SaveAs(″c:\temp\22.xls″)
¡@¡@39¡D©ñ±ó¦sÀÉ
¡@¡@eole.ActiveWorkbook.saved=.t.
¡@¡@40¡DÃö³¬¤u§@ï
¡@¡@eole.Workbooks.close
¡@¡@41¡D°h¥XExcel
¡@¡@eole.quit
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
¿c©ú¶Q



µù¥U®É¶¡: 2003-04-08
¤å³¹: 5
¨Ó¦Û: ¥xÆW

²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤G ¥|¤ë 08, 2003 3:23 pm    ¤å³¹¥DÃD: ³øªí,Excel¼Ï¯Ã¤ÀªR ¤Þ¨¥¦^ÂÐ

¥N½X:

***³o¬O§Ú·¥¤O±ÀÂ˪º°ª¤ô·Ç³øªí,Excel¼Ï¯Ã¤ÀªR...¿c©ú¶Q
***¶}±Ò°O¾ÐÅé¼È¦s¸ê®Æªí
create cursor temp00 («È¤áÃþ§O c(10),¨ì´Á¦~¤ë c(7),¨ì´Á¤é i,¼Æ¶q i)
*¶ñ¤J­È
insert into temp00 values ('¤@¯ë¤á','2002-07',1,1)
insert into temp00 values ('¤@¯ë¤á','2002-08',1,1)
insert into temp00 values ('¤@¯ë¤á','2002-08',14,1)
insert into temp00 values ('¤@¯ë¤á','2002-08',15,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',1,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',2,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',5,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',10,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',12,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',15,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',16,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',17,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',18,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',20,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',21,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',22,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',23,1)
insert into temp00 values ('¤@¯ë¤á','2002-09',30,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',1,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',2,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',4,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',5,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',6,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',7,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',8,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',9,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',10,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',11,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',12,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',13,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',14,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',15,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',16,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',17,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',18,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',19,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',20,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',21,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',22,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',23,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',24,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',25,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',26,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',27,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',30,1)
insert into temp00 values ('¤@¯ë¤á','2002-10',31,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',1,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',2,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',3,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',4,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',5,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',6,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',7,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',8,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',9,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',10,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',11,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',12,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',13,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',14,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',15,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',16,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',17,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',18,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',19,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',20,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',21,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',22,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',23,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',24,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',25,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',26,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',27,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',28,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',29,1)
insert into temp00 values ('¤@¯ë¤á','2002-11',30,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',1,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',2,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',3,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',4,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',5,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',6,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',7,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',8,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',9,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',10,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',11,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',12,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',13,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',14,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',15,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',16,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',17,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',18,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',19,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',20,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',21,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',22,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',23,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',24,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',25,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',26,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',27,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',28,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',29,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',30,1)
insert into temp00 values ('¤@¯ë¤á','2002-12',31,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',18,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',22,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',28,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',29,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',30,1)
insert into temp00 values ('¤@¯ë¤á','2003-01',31,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',18,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',22,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-02',28,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',18,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',22,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',28,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',29,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',30,1)
insert into temp00 values ('¤@¯ë¤á','2003-03',31,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',18,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',22,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',28,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',29,1)
insert into temp00 values ('¤@¯ë¤á','2003-04',30,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',18,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',22,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',29,1)
insert into temp00 values ('¤@¯ë¤á','2003-05',31,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',18,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',22,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',28,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',29,1)
insert into temp00 values ('¤@¯ë¤á','2003-06',30,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',18,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',22,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',28,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',29,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',30,1)
insert into temp00 values ('¤@¯ë¤á','2003-07',31,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',18,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',22,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',29,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',30,1)
insert into temp00 values ('¤@¯ë¤á','2003-08',31,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',22,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',28,1)
insert into temp00 values ('¤@¯ë¤á','2003-09',29,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',3,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',12,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',14,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',20,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',21,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',28,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',29,1)
insert into temp00 values ('¤@¯ë¤á','2003-10',31,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',4,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',5,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',6,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',7,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',8,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',9,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',10,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',11,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',13,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',15,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',16,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',17,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',18,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',19,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',23,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',24,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',25,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',26,1)
insert into temp00 values ('¤@¯ë¤á','2003-11',27,1)
insert into temp00 values ('¤@¯ë¤á','2003-12',1,1)
insert into temp00 values ('¤@¯ë¤á','2003-12',2,1)
insert into temp00 values ('¤@¯ë¤á','2003-12',18,1)
insert into temp00 values ('¤j¼Ó¤á','2002-08',1,1)
insert into temp00 values ('¤j¼Ó¤á','2002-09',1,1)
insert into temp00 values ('¤j¼Ó¤á','2002-09',13,1)
insert into temp00 values ('¤j¼Ó¤á','2002-09',19,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',1,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',4,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',6,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',11,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',13,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',14,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',15,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',17,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',18,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',21,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',22,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',23,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',24,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',25,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',28,1)
insert into temp00 values ('¤j¼Ó¤á','2002-10',31,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',1,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',2,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',3,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',4,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',5,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',6,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',7,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',8,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',9,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',10,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',11,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',12,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',13,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',14,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',15,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',16,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',17,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',18,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',19,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',20,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',21,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',22,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',23,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',24,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',25,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',26,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',27,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',28,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',29,1)
insert into temp00 values ('¤j¼Ó¤á','2002-11',30,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',1,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',2,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',3,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',4,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',5,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',6,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',7,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',8,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',9,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',10,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',11,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',12,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',13,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',14,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',15,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',16,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',17,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',18,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',19,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',20,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',21,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',22,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',23,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',24,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',25,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',26,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',27,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',28,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',29,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',30,1)
insert into temp00 values ('¤j¼Ó¤á','2002-12',31,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',2,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',3,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',4,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',5,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',6,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',7,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',8,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',9,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',10,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',12,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',13,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',14,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',15,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',16,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',17,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',18,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',19,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',20,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',21,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',22,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',23,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',24,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',25,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',26,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',27,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',28,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',29,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',30,1)
insert into temp00 values ('¤j¼Ó¤á','2003-01',31,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',2,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',3,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',4,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',5,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',6,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',7,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',8,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',9,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',10,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',12,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',13,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',14,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',15,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',16,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',17,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',18,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',19,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',20,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',21,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',22,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',23,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',24,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',25,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',26,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',27,1)
insert into temp00 values ('¤j¼Ó¤á','2003-02',28,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',2,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',3,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',4,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',5,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',6,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',7,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',8,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',9,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',10,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',12,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',13,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',14,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',15,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',16,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',17,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',18,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',19,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',20,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',21,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',22,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',23,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',24,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',25,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',26,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',27,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',28,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',29,1)
insert into temp00 values ('¤j¼Ó¤á','2003-03',31,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',2,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',3,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',4,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',5,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',6,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',7,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',8,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',9,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',10,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',12,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',13,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',14,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',15,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',16,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',17,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',18,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',19,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',20,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',21,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',22,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',23,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',24,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',25,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',26,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',27,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',28,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',29,1)
insert into temp00 values ('¤j¼Ó¤á','2003-04',30,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',2,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',3,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',4,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',5,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',6,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',7,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',8,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',9,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',10,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',12,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',13,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',14,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',15,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',16,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',17,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',18,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',19,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',20,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',21,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',23,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',24,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',25,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',26,1)
insert into temp00 values ('¤j¼Ó¤á','2003-05',27,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',4,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',5,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',6,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',7,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',9,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',10,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',13,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',14,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',17,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',18,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',19,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',22,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',24,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',25,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',26,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',28,1)
insert into temp00 values ('¤j¼Ó¤á','2003-06',29,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',2,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',3,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',6,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',9,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',10,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',12,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',17,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',18,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',20,1)
insert into temp00 values ('¤j¼Ó¤á','2003-07',24,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',2,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',3,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',5,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',6,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',7,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',13,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',14,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',17,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',19,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',20,1)
insert into temp00 values ('¤j¼Ó¤á','2003-08',30,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',5,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',7,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',15,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',16,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',19,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',20,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',21,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',24,1)
insert into temp00 values ('¤j¼Ó¤á','2003-09',30,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',2,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',4,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',5,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',8,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',9,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',14,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',15,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',16,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',23,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',25,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',29,1)
insert into temp00 values ('¤j¼Ó¤á','2003-10',31,1)
insert into temp00 values ('¤j¼Ó¤á','2003-11',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-11',6,1)
insert into temp00 values ('¤j¼Ó¤á','2003-11',10,1)
insert into temp00 values ('¤j¼Ó¤á','2003-11',11,1)
insert into temp00 values ('¤j¼Ó¤á','2003-11',20,1)
insert into temp00 values ('¤j¼Ó¤á','2003-11',30,1)
insert into temp00 values ('¤j¼Ó¤á','2003-12',1,1)
insert into temp00 values ('¤j¼Ó¤á','2003-12',3,1)
insert into temp00 values ('¤À¾÷²Î¦¬','2002-12',1,1)
insert into temp00 values ('¤À¾÷²Î¦¬','2003-01',10,1)
insert into temp00 values ('¦a¤è¤½Ãö','2002-12',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2002-12',18,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-01',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-01',31,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-02',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-02',8,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-02',18,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-02',19,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-02',22,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-02',23,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-03',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-03',4,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-03',5,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-03',20,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-05',17,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-05',26,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-06',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-06',7,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-06',10,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-06',14,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-06',21,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-07',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-07',24,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-07',29,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-08',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-08',4,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-08',8,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-08',20,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-09',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-09',13,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-10',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-10',2,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-11',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-12',1,1)
insert into temp00 values ('¦a¤è¤½Ãö','2003-12',31,1)
insert into temp00 values ('¨Ñ¹q¤½Ãö','2002-12',1,1)
insert into temp00 values ('¨Ñ¹q¤½Ãö','2003-03',15,1)
insert into temp00 values ('¨Ñ¹q¤½Ãö','2003-03',17,1)
insert into temp00 values ('¨Ñ¹q¤½Ãö','2003-06',1,1)
insert into temp00 values ('¨Ñ¹q¤½Ãö','2003-07',26,1)
insert into temp00 values ('¨Ñ¹q¤½Ãö','2003-09',1,1)
insert into temp00 values ('¨Ñ¹q¤½Ãö','2003-11',1,1)
insert into temp00 values ('©e­û','2002-12',1,1)
insert into temp00 values ('©e­û','2003-01',1,1)
insert into temp00 values ('©e­û','2003-02',1,1)
insert into temp00 values ('ªþ±¾','2002-12',1,1)
insert into temp00 values ('ªþ±¾','2003-01',1,1)
insert into temp00 values ('ªþ±¾','2003-04',1,1)
insert into temp00 values ('ªþ±¾','2003-06',1,1)
insert into temp00 values ('ªþ±¾','2003-09',3,1)
insert into temp00 values ('ªþ±¾','2003-09',12,1)
insert into temp00 values ('·~°È¤½Ãö','2002-11',16,1)
insert into temp00 values ('·~°È¤½Ãö','2002-12',1,1)
insert into temp00 values ('·~°È¤½Ãö','2003-01',1,1)
insert into temp00 values ('·~°È¤½Ãö','2003-01',20,1)
insert into temp00 values ('·~°È¤½Ãö','2003-01',21,1)
insert into temp00 values ('·~°È¤½Ãö','2003-02',1,1)
insert into temp00 values ('·~°È¤½Ãö','2003-03',8,1)
insert into temp00 values ('·~°È¤½Ãö','2003-03',18,1)
insert into temp00 values ('·~°È¤½Ãö','2003-06',1,1)
insert into temp00 values ('·~°È¤½Ãö','2003-07',1,1)
insert into temp00 values ('·~°È¤½Ãö','2003-08',1,1)
insert into temp00 values ('·~°È¤½Ãö','2003-09',1,1)
insert into temp00 values ('·~°È¤½Ãö','2003-10',25,1)
insert into temp00 values ('·~°È¤½Ãö','2003-11',21,1)
insert into temp00 values ('ºÞ©e','2002-10',1,1)
insert into temp00 values ('ºÞ©e','2002-11',1,1)
insert into temp00 values ('ºÞ©e','2002-12',1,1)
insert into temp00 values ('ºÞ©e','2003-01',1,1)
insert into temp00 values ('ºÞ©e','2003-02',15,1)
insert into temp00 values ('¼s§i¤½Ãö','2002-11',30,1)
insert into temp00 values ('¼s§i¤½Ãö','2003-01',1,1)
insert into temp00 values ('¼s§i¤½Ãö','2003-02',1,1)
insert into temp00 values ('¼s§i¤½Ãö','2003-02',18,1)
insert into temp00 values ('¼s§i¤½Ãö','2003-05',1,1)
insert into temp00 values ('¼s§i¤½Ãö','2003-06',1,1)
insert into temp00 values ('¼s§i¤½Ãö','2003-07',1,1)
insert into temp00 values ('¼s§i¤½Ãö','2003-08',1,1)
insert into temp00 values ('¼s§i¤½Ãö','2003-08',15,1)
insert into temp00 values ('¼s§i¤½Ãö','2003-10',1,1)
insert into temp00 values ('Ãö¥ø­û¤u','2003-01',1,1)
insert into temp00 values ('Ãö¥ø­û¤u','2003-01',2,1)
insert into temp00 values ('Ãö¥ø­û¤u','2003-01',20,1)
insert into temp00 values ('Ãö¥ø­û¤u','2003-02',9,1)
insert into temp00 values ('Ãö¥ø­û¤u','2003-03',6,1)
insert into temp00 values ('Ãö¥ø­û¤u','2003-04',27,1)
insert into temp00 values ('Ãö¥ø­û¤u','2003-05',3,1)
insert into temp00 values ('Ãö¥ø­û¤u','2003-09',1,1)


copy to c:\«È¤á¨ì´Á¤À§G xl5
lo_Excel = CreateObject('Excel.Application')
lo_Excel.WorkBooks.Open('c:\«È¤á¨ì´Á¤À§G.xls')
With lo_Excel.Application                  &&   ¦¹¬°«ü¦V lo_Excel.Application ³o¤@¼h,¦p¦¹¥i¨Ï¤U¤@¦C lo_Excel.Application.Visible = .T. Åܦ¨¤ñ¸û²µu
   .Visible = .T.                     &&   À˵øExcel
   .Range("A1").Select                  &&   ÂI¿ï A1 Àx¦s®æ
   .Cells.Select                     &&   ¿ï¨ú¾ã­ÓExcel¤u§@ªí
   .ActiveWindow.Zoom=75               &&   Åã¥Ü¤ñ¨Ò 75%
   .Selection.Font.Name = '·s²Ó©úÅé'         &&   ³]©w¦r«¬
   .Selection.Font.Size = 12               &&   ³]©w¦rÅé¤j¤p
   .Selection.Columns.AutoFit            &&   ³Ì¾AÄæ¼e
   .Range(.Cells(1,1),.Cells(1,fcount())).Select   &&   ¿ï¨ú²Ä¤@¦C©Ò¦³Àx¦s®æ
   With .Selection
      .HorizontalAlignment = -4108         &&   Àx¦s®æ¸m¤¤Åã¥Ü
      .Borders(1).LineStyle = 1            &&   ¨C­Ó(¦U­Ó)Àx¦s®æ Left ®Ø½u¬°¹ê½u
      .Borders(2).LineStyle = 1            &&   ¨C­Ó(¦U­Ó)Àx¦s®æ Top ®Ø½u¬°¹ê½u
      .Borders(3).LineStyle = 1            &&   ¨C­Ó(¦U­Ó)Àx¦s®æ Bottom ®Ø½u¬°¹ê½u
      .Borders(4).LineStyle = 1            &&   ¨C­Ó(¦U­Ó)Àx¦s®æ Right ®Ø½u¬°¹ê½u
      .Borders(7).Weight = -4138         &&   ¿ï¨ú°Ï¶ôªº³Ì Left ®Ø½uªº¼e«×¬°xlMedium ©Î -4138,¹w³]­È¬° xlThin ©Î 2
      .Borders(8).Weight = -4138         &&   ¿ï¨ú°Ï¶ôªº³Ì Top ®Ø½uªº¼e«×¬°xlMedium ©Î -4138,¹w³]­È¬° xlThin ©Î 2
      .Borders(9).Weight = -4138         &&   ¿ï¨ú°Ï¶ôªº³Ì Bottom ®Ø½uªº¼e«×¬°xlMedium ©Î -4138,¹w³]­È¬° xlThin ©Î 2
      .Borders(10).Weight = -4138         &&   ¿ï¨ú°Ï¶ôªº³Ì Right ®Ø½uªº¼e«×¬°xlMedium ©Î -4138,¹w³]­È¬° xlThin ©Î 2
      .Interior.ColorIndex = 41            &&   ¶ñº¡Àx¦s®æÃC¦â¬°Ä_ÂŦâ
      .Font.ColorIndex = 2               &&   ¦r«¬ÃC¦â¬°¥Õ¦â
   EndWith
   .Range("A2").Select                  &&   ÂI¿ï A2 Àx¦s®æ
   .ActiveWindow.FreezePanes=.T.         &&   ­áµ²µ¡®æ
   *.Range(.Cells(2,1),.Cells(recc()+1,fcount())).Select   &&   ¿ï¨ú©Ò¦³Àx¦s®æ ,¥»¦C§ï¦¨¤U¨â¦C
   .ActiveCell.SpecialCells(11).Select         &&   ª½±µ¿ï¨ú³Ì«á¤@Äæ³Ì«á¤@¦CÀx¦s®æ
   .Range(.Selection, .Cells(1, 1)).Select      &&   ±q¥Ø«eÀx¦s®æ¿ï¨ú¨ì A1
   .Selection.NumberFormatLocal = '[=0]"""";G/³q¥Î®æ¦¡'      &&   ³]©wÀx¦s®æ®æ¦¡ ,0¤£Åã²{

   ****«Ø¥ß²Ä¤@­Ó¼Ï¯Ã¤ÀªRªí
   *­ì©l½X   lo_Excel.ActiveWorkbook.PivotCaches.Add(1,"ºD©Ê¤ÀªR³øªí!R1C1:R403C6").CreatePivotTable("","¼Ï¯Ã¤ÀªRªí")
   .ActiveWorkbook.PivotCaches.Add(1,"«È¤á¨ì´Á¤À§G!R1C1:R"+alltrim(str(recc()+1))+"C4").CreatePivotTable("","¼Ï¯Ã¤ÀªRªí")
   With .ActiveSheet
      .PivotTableWizard(,,lo_Excel.Sheets("Sheet1").Cells(3, 1))
      With .PivotTables("¼Ï¯Ã¤ÀªRªí")
         .SmallGrid = .F.
         .PivotFields("«È¤áÃþ§O").Orientation = 1
         .PivotFields("¨ì´Á¦~¤ë").Orientation = 2
         .PivotFields("¼Æ¶q").Orientation = 4
      EndWith
   EndWith
   .Sheets("Sheet1").Select                     &&   ¿ï¨ú¤u§@ªí Sheet1
   .Sheets("Sheet1").Name = "¼Ï¯ÃA"               &&   §ó§ï­¶ÅÒ
   .Cells.Select                           &&   ¿ï¨ú¾ã­ÓExcel¤u§@ªí
   .Selection.Columns.AutoFit                  &&   ³Ì¾AÄæ¼e
   .ActiveWindow.Zoom=75                     &&   Åã¥Ü¤ñ¨Ò 75%
   .Range("A4").Select                        &&   ÂI¿ï C4 Àx¦s®æ
   .Range(.Selection, .Selection.End(-4161)).Select      &&   ±q¥Ø«eÀx¦s®æ¿ï¨ú¨ì¸Ó¦C³Ì«á¤@Äæ
   With .Selection
      .Interior.ColorIndex = 41                  &&   ¶ñº¡Àx¦s®æÃC¦â¬°Ä_ÂŦâ
      .Font.ColorIndex = 2                     &&   ÅܧóÀx¦s®æ¦rÅéÃC¦â¬°¥Õ¦â
   EndWith
   .ActiveCell.SpecialCells(11).Select               &&   ª½±µ¿ï¨ú³Ì«á¤@Äæ³Ì«á¤@¦CÀx¦s®æ
   .Range(.Selection, .Cells(.ActiveCell.Row, 1)).Select      &&   ±q¥Ø«eÀx¦s®æ¿ï¨ú¨ì¸Ó¦C³Ì«e¤@Äæ
   .Selection.Interior.ColorIndex = 36               &&   ¶ñº¡Àx¦s®æÃC¦â¬°²H¶À¦â
   .CommandBars("PivotTable").Visible = .F.

   ****«Ø¥ß²Ä¤G­Ó¼Ï¯Ã¤ÀªRªí
   .Sheets("«È¤á¨ì´Á¤À§G").Select                  &&   ¿ï¨ú¤u§@ªí Sheet1
   .ActiveWorkbook.PivotCaches.Add(1,"«È¤á¨ì´Á¤À§G!R1C1:R"+alltrim(str(recc()+1))+"C4").CreatePivotTable("","¼Ï¯Ã¤ÀªRªí")
   With .ActiveSheet
      .PivotTableWizard(,,lo_Excel.Sheets("Sheet2").Cells(3, 1))
      With .PivotTables("¼Ï¯Ã¤ÀªRªí")
         .SmallGrid = .F.
         .PivotFields("¨ì´Á¦~¤ë").Orientation = 1
         .PivotFields("¨ì´Á¤é").Orientation = 2
         .PivotFields("¼Æ¶q").Orientation = 4
      EndWith
   EndWith
   .Sheets("Sheet2").Select                     &&   ¿ï¨ú¤u§@ªí Sheet1
   .Sheets("Sheet2").Name = "¼Ï¯ÃB"               &&   §ó§ï­¶ÅÒ
   .Cells.Select                           &&   ¿ï¨ú¾ã­ÓExcel¤u§@ªí
   .Selection.Columns.AutoFit                  &&   ³Ì¾AÄæ¼e
   .ActiveWindow.Zoom=75                     &&   Åã¥Ü¤ñ¨Ò 75%
   .Range("A4").Select                        &&   ÂI¿ï C4 Àx¦s®æ
   .Range(.Selection, .Selection.End(-4161)).Select      &&   ±q¥Ø«eÀx¦s®æ¿ï¨ú¨ì¸Ó¦C³Ì«á¤@Äæ
   With .Selection
      .Interior.ColorIndex = 41                  &&   ¶ñº¡Àx¦s®æÃC¦â¬°Ä_ÂŦâ
      .Font.ColorIndex = 2                     &&   ÅܧóÀx¦s®æ¦rÅéÃC¦â¬°¥Õ¦â
   EndWith
   .ActiveCell.SpecialCells(11).Select               &&   ª½±µ¿ï¨ú³Ì«á¤@Äæ³Ì«á¤@¦CÀx¦s®æ
   .Range(.Selection, .Cells(.ActiveCell.Row, 1)).Select      &&   ±q¥Ø«eÀx¦s®æ¿ï¨ú¨ì¸Ó¦C³Ì«e¤@Äæ
   .Selection.Interior.ColorIndex = 36               &&   ¶ñº¡Àx¦s®æÃC¦â¬°²H¶À¦â
   .CommandBars("PivotTable").Visible = .F.

   .Range("A1").Select                        &&   ÂI¿ï A1 Àx¦s®æ
   .ActiveWorkBook.Save()                     &&   Àx¦s
   *.ActiveWorkBook.Close()                     &&   Ãö³¬ ¤u§@ªí
   *.Quit()                              &&   µ²§ôExcel
EndWith
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó MSN Messenger
¿c©ú¶Q



µù¥U®É¶¡: 2003-04-08
¤å³¹: 5
¨Ó¦Û: ¥xÆW

²Ä 3 ¼Ó

µoªíµoªí©ó: ¬P´Á¤G ¥|¤ë 08, 2003 3:26 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

©êºp,½Ð¯¸ªøÀ°§Ú§â¼Ó¤Wªº¸ê®Æ¥h±¼ ¡Õpre¡Ö
©Ç©Çªº£®
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó MSN Messenger
±q¤§«eªº¤å³¹¶}©lÅã¥Ü:   
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> VFP °Q½×°Ï ©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
²Ä1­¶(¦@1­¶)

 
«e©¹:  
±z µLªk ¦b³o­Óª©­±µoªí¤å³¹
±z µLªk ¦b³o­Óª©­±¦^ÂФ峹
±z µLªk ¦b³o­Óª©­±½s¿è¤å³¹
±z µLªk ¦b³o­Óª©­±§R°£¤å³¹
±z µLªk ¦b³o­Óª©­±¶i¦æ§ë²¼
±z µLªk ¦b³o­Óª©­±ªþ¥[ÀÉ®×
±z µLªk ¦b³o­Óª©­±¤U¸üÀÉ®×


Powered by phpBB © 2001, 2005 phpBB Group
¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@