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.