02-10-2014, 02:01 PM
You have not mentioned proper data information with your question. But what I got to know from your question I am sending possible solution:
First import that data from CSV to data table by this below formula:
DataTable.ImportSheet(FileName, SRCSheetName, DestinationSheetName)
After doing this, You will have all the csv data into your specified data table sheet.
Now if your data is in two columns, take the count of data from data table and based on the row count, create a for loop till the last count and insert the data in two dimension array like below:
Use this code and let me know if still there is any problem.
First import that data from CSV to data table by this below formula:
DataTable.ImportSheet(FileName, SRCSheetName, DestinationSheetName)
After doing this, You will have all the csv data into your specified data table sheet.
Now if your data is in two columns, take the count of data from data table and based on the row count, create a for loop till the last count and insert the data in two dimension array like below:
Code:
Dim a()
rcount = DataTable.GetRowCount
ReDim a(rcount-1, 1)
For i = 0 To rcount
For j = 0 To 1 Step 1
a(i, j) = DataTable.Value(...PrameterID..)
Next
Next
Use this code and let me know if still there is any problem.