I have an excel sheet having predefined columns 'Qname','CorrectOptions' etc.
Following that excel columns user fills data.
Problem occurs when, in column 'CorrectOptions' user put ex. 2,3 value, while
reading cell value getting empty. But if user enters any digit value without comma, it reads fine.

I think excel makes assumption of column type when it reads first cell of that column.

Any suggestions?

Dis you set that column as Text data?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.