Hey
is it possibel to show or hide rows or columne?
thank you GH
Dim workbook As New Workbook()
workbook.LoadFromFile("sample.xlsx")
Dim sheet As Worksheet = workbook.Worksheets(0)
sheet.HideRow(2)
sheet.HideColumn(3)
sheet.ShowRow(4)
sheet.ShowColumn(5)
workbook.SaveToFile("result.xlsx", Spire.Xls.FileFormat.Version2013)
Private Sub hideRowToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles hideRowToolStripMenuItem.Click
For i As Integer = spreadsheet1.ActiveWorksheet.GetSelectedRange().Top To spreadsheet1.ActiveWorksheet.GetSelectedRange().Bottom
spreadsheet1.ActiveWorksheet.Rows(i).IsHidden = True
Next i
End Sub
Private Sub hideColumnsToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles hideColumnsToolStripMenuItem.Click
For i As Integer = spreadsheet1.ActiveWorksheet.GetSelectedRange().Left To spreadsheet1.ActiveWorksheet.GetSelectedRange().Right
spreadsheet1.ActiveWorksheet.Columns(i).IsHidden = True
Next i
End Sub
Private Sub unhideRowsToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles unhideRowsToolStripMenuItem.Click
For i As Integer = spreadsheet1.ActiveWorksheet.GetSelectedRange().Top To spreadsheet1.ActiveWorksheet.GetSelectedRange().Bottom
spreadsheet1.ActiveWorksheet.Rows(i).IsHidden = False
Next i
End Sub
Private Sub unhideColumnsToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles unhideColumnsToolStripMenuItem.Click
For i As Integer = spreadsheet1.ActiveWorksheet.GetSelectedRange().Left To spreadsheet1.ActiveWorksheet.GetSelectedRange().Right
spreadsheet1.ActiveWorksheet.Columns(i).IsHidden = False
Next i
End Sub