Dim r As excel.Range r = CType(xlworksheet.Rows(numbersrows), excel.Range) If r.PageBreak = excel.XlPageBreak.xlPageBreakAutomatic Then end if
Dim objexcel As New excel.Application Dim xlBook As excel.Workbook Dim xlworksheet As excel.Worksheet Dim numbersrows As Integer try xlBook = objexcel.Workbooks.Add xlworksheet = CType(xlBook.ActiveSheet, excel.Worksheet) objexcel.Visible = True With xlworksheet for numbersrows = 1 to 100 'ici dans l'editeur du vb.net le if.rows ' est souligné If .Rows(numbersrows).PageBreak = excel.XlPageBreak.xlPageBreakAutomatic Then End If next End With objexcel = Nothing Catch ex As Exception MessageBox.Show(ex.Message) End Try