I am facing an issue in loading an excel sheet which have a dynamic Column. It changes when ever a new data is entered in the sheet or to that particular column.
| ID | Name | Count=0 |
Over here the column "Count=0" the 0 will increase as we add data into the sheet. So for every time the name will change so how can I load this column? 0 is nothing but sum(entire row).
But you can use set analysis to get this field value inside your application.
Just to understand you right you want to keep Count= Sum(column). as a field value right ?
The problem is you need a static column and when you need the value as graph header etc. or textbox you can use set analysis
e.g. ='Count= ' and Sum(Count)
I guess it will not work. Can you please use my workbook attached and try to reload it after updating the count field in workbook? The Column count changes every time once you update anything in workbook.
Any solution will be really helpful.
It works perfectly.
Anbu's script is ignoring the column labels (header is 1 lines) and referring directly to the column names (A, B, C, ...). If you do not need the actual count value, this is the simplest approach.
The script assumes that the layout of all workbooks is the same. Therefor you'll need to rename the column identifiers back into the field names only once.