1. °³¹ß/½ÇÇà Ç÷§Æû (1) OS : À©µµ¿ì7 (2) °³¹ßÅø : µ¨ÆÄÀÌ7 (3) »ç¿ë Database : firebird 2.1
2. °³¹ß ÁßÀÎ ÇÁ·Î±×·¥
3. Áú¹® ³»¿ë
¾È³çÇϼ¼¿ä? ±âÁ¸ ¿¢¼¿·Î º¯È¯Çß´ø ÀڷḦ ÇѼ¿·Îµµ º¯È¯ÇØ¾ß Çϴµ¥ ÀÚ·áµµ ¾ø°í, Àß¾ÈµÇ¾î µµ¿òÀ» ¿äûµå¸³´Ï´Ù.
¾Æ·¡ ÄÚµå´Â ¿¢¼¿º¯È¯ÄÚµåÀ̱¸¿ä, ÇѼ¿·Î ¹Ù²Ù±â À§ÇØ CreateOLEObject('hcell.Application')ó·³ Çߴµ¥ ¾Æ·¡ ¿¢¼¿º¯È¯ÄÚµåµéÀº ¾î¶»°Ô ¹Ù²Ù¾î¾ß ÇÒÁö.. Á¶±×¸¸ ÈùÆ®³ª µµ¿òÀ» ºÎŹµå¸³´Ï´Ù.
Try XL:=CreateOLEObject('hcell.Application'); //ÇѼ¿º¯È¯ //XL:=CreateOLEObject('Excel.Application'); //¿¢¼¿º¯È¯ Except ShowMessage('ÇѼ¿ÀÌ ¼³Ä¡µÇ¾î ÀÖÁö ¾Ê½À´Ï´Ù.'); Exit; End;
Try XL.WorkBooks.Add; XL.ActiveSheet.Name:='Â÷·® Á¤ºñ ÇöȲ'; //¿¢¼¿ SheetName
//ŸÀÌƲ Á¤ÀÇ XL.Columns[1].Select; XL.Selection.NumberFormatLocal:='@'; //ÀÏ¹Ý ¹®ÀÚ Ã³¸® XL.Cells.Item[3, 1]:='Â÷·®¹øÈ£';
XL.Columns[2].Select; XL.Selection.NumberFormatLocal:='@'; //ÀÏ¹Ý ¹®ÀÚ Ã³¸® XL.Cells.Item[3, 2]:='¼ö¸® ³»¿ë';
XL.Columns[3].Select; XL.Selection.NumberFormatLocal:='#,##0'; //ÅëÈ Ã³¸® XL.Cells.Item[3, 3]:='¼ö¸®ºñ';
ARow:=4; // ÀÚ·á óÀ½ Ãâ·Â À§Ä¡
//Çʵå ÀÚ·á¼ö : 3 XArr:= VarArrayCreate([1, 3], VarVariant);
While Not QyTemp.Eof Do Begin With QyTemp Do Begin XArr[1]:=FieldByName('CarNo').AsString; //Â÷·®¹øÈ£ XArr[2]:=Trim(FieldByName('Fix').AsString); //¼ö¸®³»¿ë XArr[3]:=FormatFloat('#,0', FieldByName('FixMoney').AsCurrency); //¼ö¸®ºñ End;
XL.Range[XL.Cells[ARow, 1],XL.Cells[ARow, 3]].Value := XArr; //ÀÚ·á »Ñ·ÁÁÖ±â.
QyTemp.Next;
Inc(ARow); End;
XL.Columns.AutoFit; //¿¢¼¿ Ä÷³ ÀÚµ¿ Å©±â »çÀÌÁî XL.Visible:=True; XArr:=UnAssigned; XL:=UnAssigned; Except XArr:=UnAssigned; XL:=UnAssigned; XL.Quit; //¿¢¼¿ Á¾·áÇϱâ. ShowMessage('ÀڷḦ ¿¢¼¿·Î º¯È¯ Áß ¿À·ù°¡ ¹ß»ýÇÏ¿´½À´Ï´Ù.'); End;
|