I want to be able to paste an area from Excel into a multiline textbox on a web page, and then have my logic break this into rows and columns. I found that Excel data is pasted as a string of columns within rows, with rows being separated by vbCrLf and
(within each row) columns being separated by vbTab.
I thought that I had it sorted with
Dim content As String = Replace(Text, vbCrLf, vbCr)
Dim Rows As String() = content.Split(vbCr)
Dim RowCount As Integer = Rows.Length
For Rownbr As Integer = 1 To RowCount
Dim Columns As String() = Rows(Rowsub).Split(vbTab)
...
Next
This worke ...
Go to the complete details ...