Posted on: 11/21/2012 12:47:22 AM | Views : 372

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 worked pe ...

Go to the complete details ...