G
goldenview
Guest
Hi everyone,
I made a simulation tool exports .txt data files, data is split by ";". And I want to add a report-making function in this tool in excel format which will include all .txt files. I wrote this tool in VB.NET.
Currently in this tool I read data in .txt file and store them in several list(of double), and then write them into excel cells in iterations. It works but very slow. Is there any way to copy the .txt file to excel sheets directly?
I found some information like below but I open only .txt not in excel in the end
Dim oApp As New Excel.Application
Dim oWB As Excel.Workbook
Dim oWS As Excel.Sheets
oWB = oApp.Workbooks.Open("D:\1.CSV", Format:=6, Delimiter:=";")
oApp.Visible = True
oWB.Activate()
Thank you!
Continue reading...
I made a simulation tool exports .txt data files, data is split by ";". And I want to add a report-making function in this tool in excel format which will include all .txt files. I wrote this tool in VB.NET.
Currently in this tool I read data in .txt file and store them in several list(of double), and then write them into excel cells in iterations. It works but very slow. Is there any way to copy the .txt file to excel sheets directly?
I found some information like below but I open only .txt not in excel in the end
Dim oApp As New Excel.Application
Dim oWB As Excel.Workbook
Dim oWS As Excel.Sheets
oWB = oApp.Workbooks.Open("D:\1.CSV", Format:=6, Delimiter:=";")
oApp.Visible = True
oWB.Activate()
Thank you!
Continue reading...