Free Support Forum - aspose.com

Read only in Excel visible cells with aspose.cells

Hi,

is there a possibility to read only the cells of a worksheet that are visible in Excel? For example if a user hided or grouped some columns to hide them? I only want the range of cells that are directly viewable if you open the file without unhiding columns or expanding grouped columns.

Thanks

Hi,

Well, I think you may protect your desired cells in the worksheet while protecting the worksheet using Aspose.Cells for .NET APIs.

See the topic for your reference, check the sub-topic "Protect a few Cells in the Worksheet " (especially) for your need.
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/protecting-worksheets.html

Thank you.