Reading a File

How can read the file with the extension .mir

please help me out

Is it just a text file?

http://filext.com/detaillist.php?extdetail=mir

It's probably a complex file, so you should look to see if Bauhaus has any APIs you can use to understand the file. Else all you'll get is a bunch of gibberish.

Hi all ,
I converted that .mir file to .xls file
but i need to read this .xls in asp.net letter by letter
bcoz the data excel is not in a table format

if there is any solution pls help me out

Thanks in advance
Sathish..

In excel is it just a bunch of text within the first cell? If so you could use ADO.net to read the data into a variable, then go through it character by character.

Hi Wild bill
can u plesae tell me how to read the excel cell through ado.net

thanks in advance
Sathish

Try this

VB Code:

Public Function GetExcelData(ByVal fileName As String, ByVal sheetName As String) As String
        Dim mySelectQuery As String = "select * from [" & sheetName & "$]"
        Dim myConnection As New OleDbConnection( _
                  "provider=Microsoft.Jet.OLEDB.4.0; " & _
                  "data source=" & fileName & _
                  ";Extended Properties=""Excel 8.0;HDR=No""")
        Dim myCommand As New OleDbCommand(mySelectQuery, myConnection)
        myConnection.Open()
        Dim myReader As OleDbDataReader = myCommand.ExecuteReader()
        ' Always call Read before accessing data.
        myReader.Read()
        'get first value of first row
        Dim info As String = Convert.ToString(myReader.GetValue(0))
        ' always call Close when done reading.
        myReader.Close()
        ' Close the connection when done with it.
        myConnection.Close()
 
        Return info
 
    End Function

Hi to all i am able to read the file in to one string

but how to read the required characters(bytes) from that stirng

i mean how to read 1 st character to 5 th character like and so on....

is there any file sytem objects to read the whole string
pls help me out


thanks in advance
Sathish

Now that you've got your text into a string, you can use string methods, specifically substring, to grab chunks of text:

VB Code:

For i as integer = 0 to info.length - 1
  console.writeline(info.substring(i,1))
Next

thanx a lot it's working