Thank you for contacting Aspose support, and sorry for our delayed response.
In case you wish to to hide the row containing the Subtotal/Grad Total, you may try the approach provided here
to search for a particular value in the cells, and hide the fetched row. Please check the below provided code snippet in reference to the approach discussed on your other thread
Row row = null;
Cell current = null;
while ((current = sheet.Cells.Find(“grand total”, current, opts))!= null)
if (current != null)
row = sheet.Cells.Rows[current.Row];
row.IsHidden = true;
If we have misunderstood your requirement then please provide us the sample spreadsheet and your desired results, so we could have a better understanding of what you really wish to accomplish.