1:
2:
3:
4:
5:

procedure Excel_autofit(app_Excel:Variant;wb,sh:integer);
begin
  app_Excel.workbooks[wb].sheets[sh].Cells.select;
  app_Excel.Selection.Columns.autofit;
end;                    

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:

const      // Excelkonstanten werden benötigt.
  xlCenter = $FFFFEFF4;
  xlWorksheet = -4167;
  xlnone = -4142;
  xlContinuous = 1;
  xlDiagonalDown = 5;
  xlDiagonalup = 6;
  xlEdgeLeft = 7;
  xlEdgeTop = 8;
  xlEdgeBottom = 9;
  xlEdgeRight = 10;
  xlThin = 2;
  xlInsideVertical = 11;
  xlInsideHorizontal = 12;
  xlColumnClustered = 51;
  xlColumns = 2;
  xlRows = 1;
  xlCategory = 1;
  xlPrimary = 1;
  xlBottom = -4107;
  xlValue = 2;
  xlToRight = -4161;
  xlToLeft = -4159;
  xlLandscape = 2;
  xlPageBreakPreview = 2;
  xlNormalView = 1;


procedure Excel_autofit(app_Excel:Variant;wb,sh:integer);OVERLOAD;
procedure Excel_Spaltenfarbe(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer;farbe:TColor);
procedure Excel_Spaltenhintergrund(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer;farbe:Integer);
procedure Excel_Nummernformat(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer;format:String);
procedure Excel_Merge_Spalten(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer);
procedure Excel_Schriftgroesse(app_Excel:Variant;wb,sh,ro,ru,sl,sr,groesse:integer);
procedure Excel_Schriftart(app_Excel:Variant;wb,sh,ro,ru,sl,sr:Integer;fontstyle:String);
procedure Excel_autofit(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer);OVERLOAD;
procedure Excel_LineStyle(app_Excel:Variant;wb,sh,ro,ru,sl,sr,dd,du,el,er,eb,et,iv,ih,wdd,wdu,wel,wer,web,wet,wiv,wih:integer);
procedure Excel_Select(app_Excel:Variant;wb,sh,ro,ru,sl,sr:Integer);
procedure Excel_Zeilenumbruch(app_Excel:Variant;wb,sh,ro:Integer;hv:String);


procedure Excel_LineStyle(app_Excel:Variant;wb,sh,ro,ru,sl,sr,dd,du,el,er,eb,et,iv,ih,wdd,wdu,wel,wer,web,wet,wiv,wih:integer);
begin
  app_Excel.workbooks[wb].sheets[sh].Columns.Range[app_Excel.workbooks[wb].sheets[sh].Cells.Item[ro,sl],app_Excel.workbooks[wb].sheets[sh].Cells.Item[ru,sr]].Select;
  app_Excel.Selection.Borders[xlDiagonalDown].LineStyle := dd;
  app_Excel.Selection.Borders[xlDiagonalup].LineStyle := du;
  app_Excel.Selection.Borders[xlEdgeLeft].LineStyle := el;
  app_Excel.Selection.Borders[xlEdgeTop].LineStyle := et;
  app_Excel.Selection.Borders[xlEdgeBottom].LineStyle := eb;
  app_Excel.Selection.Borders[xlEdgeRight].LineStyle := er;
  if sl <> sr then
    app_Excel.Selection.Borders[xlInsideVertical].LineStyle := iv;
  if ru <> ro then
    app_Excel.Selection.Borders[xlInsideHorizontal].LineStyle := ih;
  if wdd <> xlnone then
    app_Excel.Selection.Borders[xlDiagonalDown].Weight := wdd;
  if wdu <> xlnone then
    app_Excel.Selection.Borders[xlDiagonalup].Weight := wdu;
  if wel <> xlnone then
    app_Excel.Selection.Borders[xlEdgeLeft].Weight := wel;
  if wet <> xlnone then
    app_Excel.Selection.Borders[xlEdgeTop].Weight := wet;
  if web <> xlnone then
    app_Excel.Selection.Borders[xlEdgeBottom].Weight := web;
  if wer <> xlnone then
    app_Excel.Selection.Borders[xlEdgeRight].Weight := wer;
  if sl <> sr then
  begin
    if wiv <> xlnone then
      app_Excel.Selection.Borders[xlInsideVertical].Weight := wiv;
  end;
  if ru <> ro then
  begin
    if wih <> xlnone then
      app_Excel.Selection.Borders[xlInsideHorizontal].Weight := wih;
  end;
end;

procedure Excel_Zeilenumbruch(app_Excel:Variant;wb,sh,ro:Integer;hv:String);
var Before : IDispatch;
    st : String;
begin
   st := inttoStr(ro);
   if hv = 'h' then
   begin
     Before := app_Excel.workbooks[wb].sheets[sh].Rows[st];
     app_Excel.workbooks[wb].sheets[sh].HPageBreaks.add(Before);
   end
   else
   begin
     Before := app_Excel.workbooks[wb].sheets[sh].Columns[hv];
     app_Excel.workbooks[wb].sheets[sh].VPageBreaks.add(Before);
   end;
end;


procedure Excel_Select(app_Excel:Variant;wb,sh,ro,ru,sl,sr:Integer);
begin
  app_Excel.workbooks[wb].sheets[sh].Columns.Range[app_Excel.workbooks[wb].sheets[sh].Cells.Item[ro,sl],app_Excel.workbooks[wb].sheets[sh].Cells.Item[ru,sr]].Select;
end;

procedure Excel_Schriftart(app_Excel:Variant;wb,sh,ro,ru,sl,sr:Integer;fontstyle:String);
begin
  app_Excel.workbooks[wb].sheets[sh].Columns.Range[app_Excel.workbooks[wb].sheets[sh].Cells.Item[ro,sl],app_Excel.workbooks[wb].sheets[sh].Cells.Item[ru,sr]].Select;
  app_Excel.Selection.font.fontstyle := fontstyle;
end;

procedure Excel_Schriftgroesse(app_Excel:Variant;wb,sh,ro,ru,sl,sr,groesse:integer);
begin
  app_Excel.workbooks[wb].sheets[sh].Columns.Range[app_Excel.workbooks[wb].sheets[sh].Cells.Item[ro,sl],app_Excel.workbooks[wb].sheets[sh].Cells.Item[ru,sr]].Select;
  app_Excel.Selection.font.size := groesse;
end;

procedure Excel_Merge_Spalten(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer);
begin
  app_Excel.workbooks[wb].sheets[sh].Columns.Range[app_Excel.workbooks[wb].sheets[sh].Cells.Item[ro,sl],app_Excel.workbooks[wb].sheets[sh].Cells.Item[ru,sr]].Select;
  app_Excel.Selection.MergeCells := true;
end;

procedure Excel_Nummernformat(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer;format:String);
begin
  app_Excel.workbooks[wb].sheets[sh].Columns.Range[app_Excel.workbooks[wb].sheets[sh].Cells.Item[ro,sl],app_Excel.workbooks[wb].sheets[sh].Cells.Item[ru,sr]].select;
  app_Excel.Selection.NumberFormat := format;
end;

procedure Excel_Spaltenfarbe(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer;farbe:TColor);
begin
  app_Excel.workbooks[wb].sheets[sh].Columns.Range[app_Excel.workbooks[wb].sheets[sh].Cells.Item[ro,sl],app_Excel.workbooks[wb].sheets[sh].Cells.Item[ru,sr]].select;
  app_Excel.Selection.font.color := farbe;
end;

procedure Excel_Spaltenhintergrund(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer;farbe:Integer);
begin
  app_Excel.workbooks[wb].sheets[sh].Columns.Range[app_Excel.workbooks[wb].sheets[sh].Cells.Item[ro,sl],app_Excel.workbooks[wb].sheets[sh].Cells.Item[ru,sr]].select;
  app_Excel.Selection.Interior.colorindex := farbe;
end;

procedure Excel_autofit(app_Excel:Variant;wb,sh,ro,ru,sl,sr:integer);
begin
  app_Excel.workbooks[wb].sheets[sh].Columns.Range[app_Excel.workbooks[wb].sheets[sh].Cells.Item[ro,sl],app_Excel.workbooks[wb].sheets[sh].Cells.Item[ru,sr]].select;
  app_Excel.Selection.Columns.autofit;
end;

procedure Excel_autofit(app_Excel:Variant;wb,sh:integer);
begin
  app_Excel.workbooks[wb].sheets[sh].Cells.select;
  app_Excel.Selection.Columns.autofit;
end;                    

1:

Excel_LineStyle(app_Excel,1,1,vonzeile,biszeile,von,bis,xlnone,xlnone,xlContinuous,xlContinuous,xlContinuous,xlContinuous,xlContinuous,xlContinuous,xlnone,xlnone,xlThin,xlThin,xlThin,xlThin,xlThin,xlThin);