How to populate the Excel Cell Dynamically
Hi Expert,
We have observed that business user is delighted with the Web-Adi Solution. One of the requirement is: " user will tab out of the cell in Excel and based on the cell value other Few Cell will be defaulted automatically". Now I am able to put any excel function, but how I will use (Select email_address from ap_supplier_sites_all where site_code=[SITE_CODE}) , this sql is not working in web-adi layout, But If I put =[ID]+1, where [ID} is one of my cell name, it's perfectly working, doe this means that you can't use a sql statement using the [CELL] value?
We have observed that business user is delighted with the Web-Adi Solution. One of the requirement is: " user will tab out of the cell in Excel and based on the cell value other Few Cell will be defaulted automatically". Now I am able to put any excel function, but how I will use (Select email_address from ap_supplier_sites_all where site_code=[SITE_CODE}) , this sql is not working in web-adi layout, But If I put =[ID]+1, where [ID} is one of my cell name, it's perfectly working, doe this means that you can't use a sql statement using the [CELL] value?
0