Trying to pull in an excel file on an external website and then read the data.
Yes, I can download and then fill a dataset with no code errors but the first column is for the sku which the first row value (A2) is numeric but later on down the worksheet some alphanumeric (ie: 1234-RV) type values. So when I loop through the dataset
these alphanumeric are blank in the dataset.
Seems like when filling the dataset it reads the first row and defines the columns datatype by what it see in first row. Any way to fix this?
Code
rotected Sub btnGetExcelFile_Click(sender As Object, e As System.EventArgs) Handles btnGetExcelFile.Click
litOutput.Text = ""
Dim ws As New WebPost
ws.URL = "http://www.domain.com/dropship/feed.xls"
'downloads excel file based on url
Dim bExcel() As Byte = ws.RequestBinaryData("", True)
Dim sFileFolder As S ...
Go to the complete details ...