Hiding columns

bquinn47 · July 25, 2006, 11:14am

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 [:$]

Dandd · July 25, 2006, 2:05pm

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

bquinn47 · July 25, 2006, 3:08pm

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.