Programming in asp.net-mvc: Reading XLS locally in asp (mvc) on newest questions tagged asp.net-mvc – Stack Overflow
thanks for reading, my doubt is the following, im trying to get data from an xls file but it has to be done locally, without uploading the file, i have done something similiar with txts files and works perfectly :
Function Send(ByVal file As HttpPostedFileBase) As ActionResult
Dim line As String
Dim textreader As System.IO.StreamReader = New StreamReader(file.InputStream)
While Not textreader.EndOfStream
line = textreader.ReadLine()
ViewBag.line = line
End While
Return View("Index")
End Function
but i cant do the same to the excel file, first of all, because i cant use the streamreader, so when using this code i dont know how to specify the dir of my xls file
Dim oApp As Excel.Application = New Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
oWB = oApp.Workbooks.Open(file.inputstream) <-- HERE IS WHERE I GET (AN OBVIOUS) ERROR
does anybody knows how to open the file locally? thanks for reading
See Answers
source: http://stackoverflow.com/questions/11568106/reading-xls-locally-in-asp-mvc
Programming in asp.net-mvc: programming-in-asp-net-mvc
Recent Comments