Reading a File

[sathish_reddy]

How can read the file with the extension .mir

please help me out

[wild_bill]

Is it just a text file?

[mendhak]

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.

[sathish_reddy]

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

[wild_bill]

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.

[sathish_reddy]

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

thanks in advance
Sathish

[wild_bill]

Try this

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

[sathish_reddy]

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

[wild_bill]

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

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

[sathish_reddy]

thanx a lot it's working