¾È³çÇϼ¼¿ä~ °£´ÜÇÑ ÆÁÇϳª ¾Ë·Áµå¸±²²¿ä~
ÀϹÝÀûÀ¸·Î ¿¢¼¿À» º¯È¯½Ã¿¡´Â ¾Æ·¡¿Í °°ÀÌ »ç¿ëÇϴµ¥¿ä~
xls := CreateOleObject( 'Excel.Application' ); wb := xls.workbooks.add; lineNumber := 1;
for i:=1 to stringgrid1.rowcount-1 do begin for j:=0 to stringgrid1.ColCount-1 do begin wb.Cells.Item[i+lineNumber,j+1] := stringgrid1.Cells[j,i]; end; end;
´ë¿ë·®ÀÇ µ¥ÀÌÅ͸¦ ¿¢¼¿·Î º¯È¯½Ã¿¡´Â »ó´çÇÑ ½Ã°£ÀÌ ¼Ò¿äµÇ´õ¶ó±¸¿ä~
±×·¡¼ MSDN¸¦ ã¾Æº¸´Ï±ñ ¹è¿·Î ÀúÀåÇÑ ´ÙÀ½¿¡ Range¿¡´Ù Çѹø¿¡ ³ÖÀ¸¶ó°í ³ª¿ÍÀÖ´õ±º¿ä~
±×·¡¼ ¾Æ·¡¿Í °°ÀÌ Àû¿ëÇغ¸´Ï±ñ ºü¸£°Ô º¯È¯ÀÌ µÇ´õ±º¿ä~ (¼ÓµµÃøÁ¤±îÁö´Â ¾ÈÇغÃÁö¸¸-_-a)
var xls, wb, Range: OLEVariant; arrData: Variant; RowCount, ColCount, i, j: Integer; begin RowCount := StringGrid1.RowCount; ColCount := StringGrid1.ColCount arrData := VarArrayCreate([1, RowCount, 1, ColCount], varVariant);
for i := 1 to RowCount do for j := 1 to ColCount do arrData[i, j] := StringGrid1.Cells[j-1, i-1];
xls := CreateOLEObject('Excel.Application'); wb := xls.Workbooks.Add; Range := wb.WorkSheets[1].Range[wb.WorkSheets[1].Cells[1, 1], wb.WorkSheets[1].Cells[RowCount, ColCount]];
Range.Value := arrData;
xls.Visible := True; end;
½ºÅ¸Àϵµ Range´ÜÀ§·Î Àû¿ëÇÏ¸é µÇ´Âµ¥¿ä~ ´Ü, Á¦°¡ Å×½ºÆ®ÇßÀ»¶§´Â Font °ü·ÃµÈ ½ºÅ¸ÀÏÀ» Àû¿ë½Ã¿¡´Â º¯È¯ÀÌ ¿À·¡°É¸®´õ¶ó°í¿ä~ (ÀÌÀ¯´Â Àß ¸ð¸£°Ú³×¿ä -_-;)
Range.Borders.LineStyle := 1; Range.Borders.Weight := 2; Range.Borders.ColorIndex := 16;
ÀÌ·±½ÄÀ¸·Î Àû¿ëÇϸé ÇÑ°á ºü¸¥ ¼Óµµ·Î º¯È¯ÀÌ µÇ´õ±º¿ä. ±×¿Ü ½ºÅ¸ÀÏÀ» ÀüºÎ´Ù Àû¿ë¾ÈÇغÃÁö¸¸
°¢ÀÚ Å×½ºÆ®Çغ¸½Ã¸é µÇ½Çµí ÇÕ´Ï´Ù.^^
¿Ã ÇÑÇØ µ¨¸¶´ç ¼ö°íÇß¾î¿ä~ ³»³â¿¡´Â ´õ¿í´õ ÈÀÌÆà ÇÏÀÚ°í¿ä^^
|