Nav 2009 Generate Excel (Get Cell number)

Business Central/NAV Developers Forum
1

Hi all,

Anyone have idea about how to get the cell number from excel?

For example, I have done the report which will generate the excel and exported the field from table, then I want to determine which cell this field ‘HQ’ seated.

4152.ex.png

If “Emp Classification 4” = ‘HQ’ THEN BEGIN

//get cell number

END;

Please help to advise how to do this.

Thanks in advance.

2

this may help you:

http://www.excelfunctions.net/Excel-Address-Function.html

http://office.microsoft.com/en-nz/excel-help/address-function-HP010062407.aspx

http://www.techonthenet.com/excel/formulas/cell.php