I’m trying to reproduce the same kind of functionality found in Aspose.Words, where blank lines (rows) are removed automatically. For example, let’s say I have an name and address block comprised of the following smart markers, each in a separate cell of an Excel worksheet:
&=Customer.Name
&=Customer.Address1
&=Customer.Address2
My first question is: do you have a suggestion as to how I can remove the “&=Customer.Address2” line if no data is present, ie, some of our contacts have a suite number, some do not. It would be something like the document.MailMerge.RemoveEmptyParagraphs property from Aspose.Words. I rather doubt anything like that exists, but I thought I’d ask.
You can use Cells.DeleteRows or Cells.DeleteRange method to delete them.