Hiding columns


#1

I have a workbook that contains a worksheet with data on it created with the Apose library. I’d like to hide three of the columns on the worksheet using the library before I save it - how do I do that? I’ve looked in the forums and API and can’t seem to figure this simple one out! Embarrassed [:$]


#2

this is how i hide columns

xlWSheet.Cells.HideColumn(ExcelHelper.ColumnNameToIndex(“A”))

because i do not know what version you are using, if you can’t find ExcelHelper than use CellsHelper


#3

Thank you for a quick response and the help…what you recommended worked perfectly! I am using an older library, so I used the ExcelHelper exactly as you indicated to get it working.