[vb.net] CreateObject 를 이용한 Excel 컨트롤
하나를하더라도최선을
2019-10-10 18:24:59
55,376
0
0
Dim Excel As Object = CreateObject("Excel.Application")
Excel.Visible = True
Dim WB As Object = Excel.Workbooks.Open(Application.StartupPath & "\csv.csv")
Dim WS As Object = WB.Worksheets(1)
Dim C As Object = WS.UsedRange
Dim R As DataRow
For i As Integer = 2 To C.rows.count
R = D.NewRow
For n As Integer = 1 To C.columns.count
R("ck") = D.Rows.Count + 1
R(C(1, n).Value.Replace(Space(1), "_")) = C(i, n).Value
Next
Next