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.
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.