Unknown Identifier error while accessing variables inside nested ranges about closedxml.report HOT 9 CLOSED

You can output {{DataYear}} into a cell outside the range (for example, cell A3) and collapse the column A. After that, you will be able to reference this cell within the range of $A$3

from closedxml.report.

Please could you explain more. If I collapse column A then will the excel work with report generation?

Here is my excel -
DataYear Test.xlsx

from closedxml.report.

Replace the formula in cell B4 with =CONCATENATE($C$1," Goals")

from closedxml.report.

Replace the formula in cell B4 with =CONCATENATE($C$1," Goals")

This gives the following error - This function does not accept cell ranges as parameters

from closedxml.report.

try this formula =$C$1&" Goals"

from closedxml.report.

@b0bi79 That works. Thanks.

from closedxml.report.

@b0bi79 I have one more question. I'm asking here as I couldn't find a way to contact you. Closed XML Report idea looks great. Can this similar idea be used to Generate PDF using Microsoft Word with some library named ClosedXML.PDF or ClosedXML.Word? Anything like that available already?

from closedxml.report.

ClosedXML does not yet support rendering to PDF. As for the Word functionality - it is on the earliest stages of development. See ClosedXML/ClosedXML#1260. A contribution is welcome.

from closedxml.report.

Thanks @Pankraty . I'll look on it.

from closedxml.report.