UnHide a column

Aspose.Cells Product Family
1

The Cells class contains a HideColumn method to hide a column.

Is there a way to UnHide a column in a similar fashion?

2

Thanks for you suggestion. Now I added UnhideColumn method in this attached fix. Please try it.

Cells cells = excel.Worksheets[0].Cells;
cells.UnhideColumn(1, 13); //Unhide column B and set its width to 13

3

I would be very difficult to ask for faster service than that.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank Laurence.

4

@ChristianVerdon,
Aspose.Cells is the latest product that has replaced Aspose.Excel which is no more available now. You can hide and show rows/columns in a variety of ways with Aspose.Cells. Here is an example that demonstrates the feature of unhiding columns.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
Workbook workbook = new Workbook("book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Unhiding the 3rd row and setting its height to 13.5
worksheet.Cells.UnhideRow(2, 13.5);

// Unhiding the 2nd column and setting its width to 8.5
worksheet.Cells.UnhideColumn(1, 8.5);

// Saving the modified Excel file
workbook.Save("output.xls");

Refer to the following article for more information on hiding and showing rows and columns.
Hiding and Showing Rows and Columns

Download the latest trial version here:
Aspose.Cells for .NET (Latest Version)

Download a complete runnable solution here to test variety of features of this product.