|
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¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
Ruey
µù¥U®É¶¡: 2003-03-12 ¤å³¹: 1698 ¨Ó¦Û: tunglo
²Ä 1 ¼Ó
|
µ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(1.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 |
|
¦^³»ºÝ |
|
|
¿c©ú¶Q
µù¥U®É¶¡: 2003-04-08 ¤å³¹: 5 ¨Ó¦Û: ¥xÆW
²Ä 2 ¼Ó
|
µ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
|
|
|
¦^³»ºÝ |
|
|
¿c©ú¶Q
µù¥U®É¶¡: 2003-04-08 ¤å³¹: 5 ¨Ó¦Û: ¥xÆW
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¥|¤ë 08, 2003 3:26 pm ¤å³¹¥DÃD: |
|
|
©êºp,½Ð¯¸ªøÀ°§Ú§â¼Ó¤Wªº¸ê®Æ¥h±¼ ¡Õpre¡Ö
©Ç©Çªº£® |
|
¦^³»ºÝ |
|
|
|
|
±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§@
|