Å×½ºÆ®¸¦ ÇØ ºÃ´Âµ¥ ¹®Á¦°¡ ¾ø³×¿ä..
¹öÀüÀº ExcelIO: 3.14 AdvStringGrid: 8.4.7.0
÷ºÎÆÄÀÏÀ» ½ÇÇàÇØ º¸½Ã¸é.... (Ȥ½Ã ½ÇÇàÀÌ ¾ÈµÇ¸é °ü¸®ÀÚ±ÇÇÑÀ¸·Î...)
unit Unit3;
interface
uses
Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
Vcl.Controls, Vcl.Forms, Vcl.Dialogs, AdvUtil, Vcl.Grids, AdvObj, BaseGrid,
AdvGrid, Vcl.StdCtrls, tmsAdvGridExcel, tmsUFlxFormats;
type
TForm3 = class(TForm)
AdvStringGrid1: TAdvStringGrid;
Button1: TButton;
ExcelIO: TAdvGridExcelIO;
Edit1: TEdit;
procedure FormCreate(Sender: TObject);
procedure Button1Click(Sender: TObject);
procedure AdvGridExcelIO1ExportColumnFormat(Sender: TObject; GridCol,
GridRow, XlsCol, XlsRow: Integer; const Value: WideString;
var ExportCellAsString: Boolean);
procedure AdvGridExcelIO1CellFormat(Sender: TAdvStringGrid; const GridCol,
GridRow, XlsCol, XlsRow: Integer; const Value: WideString;
var Format: TFlxFormat);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form3: TForm3;
implementation
{$R *.dfm}
procedure TForm3.AdvGridExcelIO1CellFormat(Sender: TAdvStringGrid;
const GridCol, GridRow, XlsCol, XlsRow: Integer; const Value: WideString;
var Format: TFlxFormat);
begin
if GridCol = 1 then
Format.Format := '#,##0';
end;
procedure TForm3.AdvGridExcelIO1ExportColumnFormat(Sender: TObject; GridCol,
GridRow, XlsCol, XlsRow: Integer; const Value: WideString;
var ExportCellAsString: Boolean);
begin
if GridCol = 2 then
ExportCellAsString := True;
end;
procedure TForm3.Button1Click(Sender: TObject);
begin
ExcelIO.XLSExport(Edit1.Text);
end;
procedure TForm3.FormCreate(Sender: TObject);
var
I: Integer;
begin
AdvStringGrid1.Cells[0, 0] := 'NO';
AdvStringGrid1.Cells[1, 0] := '¼ýÀÚ';
AdvStringGrid1.Cells[2, 0] := '¹®ÀÚ';
for I := 1 to 9 do
AdvStringGrid1.Cells[0, i] := i.ToString;
// ¼ýÀÚ..
var Value := 100000;
for I := 1 to 9 do
AdvStringGrid1.Floats[1, i] := Value + i;
Value := 10;
// ¹®ÀÚ
for I := 1 to 9 do
AdvStringGrid1.Cells[2, i] := '000' + i.ToString;
end;
end.
>> 1. °³¹ß/½ÇÇà Ç÷§Æû
>> (1) OS : Windows ALL
>> (2) °³¹ßÅø : D2007
>>
>> 3. Áú¹® ³»¿ë
>> D2007¿¡ TMS Grid¸¦ »ç¿ëÇÏ°í ÀÖ½À´Ï´Ù.
>> ±×·±µ¥ °Å·¡Ã³¿¡¼ °¡²û ÄÄÇ÷¹ÀÎ ¿À´Â°ÍÁß Çϳª°¡ ¿¢¼¿Àüȯ ¹®Á¦ÀÔ´Ï´Ù.
>> ÀÌÀü¿¡´Â RealGrid¸¦ ½è´Âµ¥(°³ÀÎÀûÀ¸·Î ±×¸®µåÀÚü´Â RealGrid°¡ ¾²±â ÁÁ¾Ò¾î¿ä.. ´Ù¸¸ ¿¢¼¿ÀüȯÀº Á» ¾È½ÀÀ̱äÇѵ¥.. ³Ñ³ª ´À·Á¿ä) TMS°¡ Á» ÀÌ»µ¼ TMS·Î ÀüÇâÇß½À´Ï´Ù.
>>
>> ±×·±µ¥, ´Ù ÁÁÀºµ¥, ¾Æ½¬¿î°Ô ¿¢¼¿Àüȯ½Ã Ä÷³Çü½Ä°ü·Ã ¹®Á¦ÀÔ´Ï´Ù.
>>
>> Åë°è°°Àº°É ¸¸µé´Ùº¸¸é, ¼ýÀÚ°¡ ÀÖ°í ¹®ÀÚ°°Àº ¼ýÀÚ°¡ ÀÖÀݾƿä? ÀÌ°É Á¦´ë·Î ±¸ºÐÇÏÁö ¸øÇÕ´Ï´Ù.
>> ±×·¡¼ ¿É¼ÇÀ» Á¶Á¤Çϸé ÀüºÎ´Ù ¹®ÀÚ¿·Î µÇ¼ ¸¶¿ì½º·Î ±Ü¾î¼ Çհ質 µ¡¼ÀÀÌ ¾ÈµÇ°Ô µÇ°Å³ª, ¾Æ´Ï¸é ¼ýÀÚó·³ »ý±ä °Í(¿¹: 000012113 ->Çü½ÄÀÌ ¸Â¾Æ¾ß ÇÔ, ¶Ç´Â ÁֹιøÈ£->³¯Â¥³ª ¼ýÀÚ·Î ¹Ù²¸¹ö¸²)µé±îÁö ¸ðµÎ ¼ýÀÚ·Î ¹Ù²ã¼ ¾î¶»°Ô º¸¸é ³»°¡ ¿øÇϴ´ë·Î Ãâ·ÂÀÌ ¾ÈµÇ´Â°ÅÁÒ.
>>
>> CellTypeµµ ¹Ù²ãº¸°í Çߴµ¥ Àß ¾ÈµÇ´õ¶ó±¸¿ä.
>>
>> Ȥ½Ã ¹æ¹ýÀÌ ÀÖÀ»±î¿ä? ÀÌ Ä÷³Àº ¼ýÀÚ´Ù! ¹®ÀÚ´Ù! ¿¢¼¿Àüȯ½Ã ŸÀÔÀ» ±×´ë·Î µû¶ó°¡¶ó! ¹¹ ÀÌ·±½ÄÀ¸·Î¿ä.
>> ÇöÀç TMS ¹öÀüÀÌ ³·¾Æ¼ ±×·±°ÇÁö.. Áï ¹öÀü¾÷, ½Å±Ô±¸¸ÅÇϸé ÇØ°áµÇ´ÂÁö°¡ ±Ã±ÝÇÕ´Ï´Ù.
>>
>> Áö±Ý »ç¿ëÁßÀÎ TMS Grid¹öÀüÀº 3.1.0.7 ÀÔ´Ï´Ù.