procedure TForm1.Dan;
var
Excel, WorkBook: variant;
i: integer;
begin
Excel:=CreateOleObject('Excel.Application');
Excel.DisplayAlerts:=False;
Workbook:=Excel.Workbooks.Open(Edit2.Text);
Combobox1.Clear;
for i:= 1 to Workbook.Sheets.Count do
Combobox1.Items.Add(Workbook.Sheets.Item[i].Name);
Combobox1.ItemIndex:= 0;
Workbook.Close(0);
Excel.Quit;
Excel:= UnAssigned;
end;
procedure TForm1.ComboBox1Click(Sender:TObject);
var
Excel, WorkBook, Sheet1: variant;
i: integer;
begin
Excel:=CreateOleObject('Excel.Application');
Excel.DisplayAlerts:=False;
Workbook:=Excel.Workbooks.Open(Edit2.Text);
Sheet1:= Workbook.Sheets[ComboBox1.Items[ComboBox1.ItemIndex]];
StringGrid1.RowCount:= 6;
for i:= 1 to 5 do
begin
StringGrid1.Cells[1,i]:= Sheet1.Range['a' + IntToStr(i)];
StringGrid1.Cells[2,i]:= Sheet1.Range['b' + IntToStr(i)];
end;
end;
for i:= 1 to 5 do
begin
StringGrid1.Cells[1,i]:= Sheet1.Range['a' + IntToStr(i)];
StringGrid1.Cells[2,i]:= Sheet1.Range['b' + IntToStr(i)];
Workbook.Close(0);
Excel.Quit;
Excel:= UnAssigned;
end;
end;
StringGrid1.RowCount:= 6;
for i := 1 to 5 do
begin
StringGrid1.Cells[1,i]:= Sheet1.Range['B' + IntToStr(i)];
StringGrid1.Cells[2,i]:= Sheet1.Range['C' + IntToStr(i)];
StringGrid1.Cells[3,i]:= Sheet1.Range['D' + IntToStr(i)];
StringGrid1.Cells[4,i]:= Sheet1.Range['E' + IntToStr(i)];
StringGrid1.Cells[5,i]:= Sheet1.Range['F' + IntToStr(i)];
StringGrid1.Cells[6,i]:= Sheet1.Range['G' + IntToStr(i)];
StringGrid1.Cells[7,i]:= Sheet1.Range['H' + IntToStr(i)];
StringGrid1.Cells[8,i]:= Sheet1.Range['J' + IntToStr(i)];
StringGrid1.Cells[9,i]:= Sheet1.Range['K' + IntToStr(i)];
procedure TForm1.ComboBox1Click(Sender:TObject);
var
Ex, WorkBook, Sheet1: variant;
i, j: integer;
begin
Ex:=CreateOleObject('Excel.Application');
Ex.DisplayAlerts:=False;
Workbook:=Ex.Workbooks.Open(Edit2.Text);
Sheet1:= Workbook.Sheets[ComboBox1.Items[ComboBox1.ItemIndex]];
StringGrid1.RowCount:= 6;
for i := 1 to 5 do
begin
StringGrid1.Cells[1,i]:= Sheet1.Cells.Range[3,5];
StringGrid1.Cells[2,i]:= Sheet1.Cells.Range[4,5];
StringGrid1.Cells[3,i]:= Sheet1.Cells.Range[5,5];
StringGrid1.Cells[4,i]:= Sheet1.Cells.Range[6,5];
StringGrid1.Cells[5,i]:= Sheet1.Cells.Range[7,5];
StringGrid1.Cells[6,i]:= Sheet1.Cells.Range[8,5];
end;
Workbook.Close(0);
Ex.Quit;
Ex:= UnAssigned;
end;
Sheet1:= Workbook.Sheets[ComboBox1.Items[ComboBox1.ItemIndex]];
StringGrid1.RowCount:= 36;
for i := 1 to 35 do
begin
StringGrid1.Cells[1,i]:= Sheet1.Range['B' + IntToStr(i)];
StringGrid1.Cells[2,i]:= Sheet1.Range['C' + IntToStr(i)];
StringGrid1.Cells[3,i]:= Sheet1.Range['D' + IntToStr(i)];
StringGrid1.Cells[4,i]:= Sheet1.Range['E' + IntToStr(i)];
StringGrid1.Cells[5,i]:= Sheet1.Range['F' + IntToStr(i)];
StringGrid1.Cells[6,i]:= Sheet1.Range['G' + IntToStr(i)];
StringGrid1.Cells[7,i]:= Sheet1.Range['H' + IntToStr(i)];
StringGrid1.Cells[8,i]:= Sheet1.Range['I' + IntToStr(i)];
StringGrid1.Cells[9,i]:= Sheet1.Range['J' + IntToStr(i)];
StringGrid1.Cells[10,i]:= Sheet1.Range['K' + IntToStr(i)];
procedure TForm1.ComboBox1Click(Sender:TObject);
var
Ex, WorkBook, Sheet1: variant;
i: integer;
d: TDateTime;
Timer: string;
begin
Ex:=CreateOleObject('Excel.Application');
Ex.DisplayAlerts:=False;
Workbook:=Ex.Workbooks.Open(Edit2.Text);
Sheet1:= Workbook.Sheets[ComboBox1.Items[ComboBox1.ItemIndex]];
d:=Now;
StringGrid1.RowCount:= 36;
for i := 1 to 35 do
begin
StringGrid1.Cells[1,i]:= Sheet1.Range['B' + IntToStr(i+4)];
try
StringGrid1.Cells[2,i]:= Format('%10.1f', [StrToFloat(Sheet1.Range['C' + IntToStr(i+4)])]);
except
StringGrid1.Cells[2,i]:= Sheet1.Range['C' + IntToStr(i+4)];
end;
StringGrid1.Cells[3,i]:= Sheet1.Range['D' + IntToStr(i+4)];
StringGrid1.Cells[4,i]:= Sheet1.Range['E' + IntToStr(i+4)];
StringGrid1.Cells[5,i]:= Sheet1.Range['F' + IntToStr(i+4)];
try
StringGrid1.Cells[6,i]:= Format('%10.1f', [StrToFloat(Sheet1.Range['G' + IntToStr(i+4)])]);
except
StringGrid1.Cells[6,i]:= Sheet1.Range['G' + IntToStr(i+4)];
end;
try
StringGrid1.Cells[20,i]:= Format('%10.2f', [StrToFloat(Sheet1.Range['V' + IntToStr(i+4)])]);
except
StringGrid1.Cells[20,i]:= Sheet1.Range['V' + IntToStr(i+4)];
end;
StringGrid1.Cells[21,i]:= Sheet1.Range['W' + IntToStr(i+4)];
StringGrid1.Cells[22,i]:= Sheet1.Range['X' + IntToStr(i+4)];
StringGrid1.Cells[23,i]:= Sheet1.Range['Y' + IntToStr(i+4)];
StringGrid1.Cells[24,i]:= Sheet1.Range['AA' + IntToStr(i+4)];
StringGrid1.Cells[25,i]:= Sheet1.Range['AB' + IntToStr(i+4)];
StringGrid1.Cells[26,i]:= Sheet1.Range['AC' + IntToStr(i+4)];
end;
Workbook.Close(0);
Ex.Quit;
Ex:= UnAssigned;
Timer :='Время загрузки: '+FormatDateTime('hh:mm:ss:zzz',Now()-d);
StatusBar1.Panels[0].Text :=Timer;
end;
Если Вы уже зарегистрированы на Портале - войдите в систему, если Вы еще не регистрировались - пройдите простую процедуру регистрации.