Visual Basic

ahzarmokhli wrote:

there are more then 2000 control in one page

<br />
'Open in Excel<br />
        Dim myExcel As New Microsoft.Office.Interop.Excel.Application()<br />
        Dim workBook As Microsoft.Office.Interop.Excel.Workbook<br />
        Dim workSheet As New Worksheet<br />
<br />
        Try<br />
<br />
            If myExcel Is Nothing Then<br />
                'Failed to load Excell Object<br />
            Else<br />
<br />
                workBook = myExcel.Workbooks.Open("C:\myfile.xls", 0, True, 5, "", "", True, XlPlatform.xlWindows, "\t", False, False, 0, True, 1, 0)<br />
                workSheet = workBook.ActiveSheet<br />
<br />
                workSheet.Cells(1, 1) = "My value"<br />
<br />
                workBook.Close()<br />
<br />
            End If<br />
<br />
<br />
        Catch ex As Exception<br />
            'Handle Exception<br />
        End Try<br />
<br />
        myExcel.Close()<br />

Faruk Ansari wrote:

The results were as expected, but when I added this form to my MDI app, where it is supposed to be used, it does not display the groups, but the rest of the column data is displayed fine. I have tried everything I knew off but no luck.

string[] lines = File.ReadAllLines( <FILEPATH> );