Слайд 9Imports Microsoft.Office.Interop
Public Class Form1
Private Sub Form1_Load(sender As System.Object,
e As System.EventArgs) Handles MyBase.Load
Label1.TextAlign =
ContentAlignment.MiddleCenter
'A*X=L; X=A^(-1)*L
Dim A(,) As Double = {{1, 1, 1},
{1, 1, 0},
{0, 1, 1}}
Dim L() As Double = {6, 3, 5}
Dim oA, X As Object
Dim xl = New Excel.Application
Слайд 10With xl.Application.WorksheetFunction
Dim det_A As
Double = .MDeterm(A)
If Math.Abs(det_A)
< 0.01 Then
Label1.Text = "система не имеет решения, поскольку" & vbCrLf & vbCrLf & "определитель равен нулю"
Exit Sub
End If
oA = .MInverse(A)
X = .MMult(oA, .Transpose(L))
End With
Label1.Text = "Неизвестные равны" & vbCrLf & vbCrLf &
"X1=" & X(1, 1).ToString &
"; X2=" & X(2, 1).ToString &
"; X3=" & X(3, 1).ToString
End Sub
End Class