How to read the excel which has values in the merged cells. When i exporting the excel to collection , i am able to see more empty cells along with values in the cell. I want to select few particular values from the excel. Sample data attached.
If there is a problem reading in merged cell data I would probably suggest experimenting with in-merging cells first which might require that you create a new Excel VBO action.
i
