EPPlus can't read locked cells value
<p>I am using EPPlus to read data from .XLSX file.</p>

<p>issue is it is not able to read locked cells. So I have to open excel, Unlock cells, and then upload. Is there way to read lock cells. I tried as below:</p>

<pre><code> For row As Integer = workSheet.Dimension.Start.Row + 1 To workSheet.Dimension.[End].Row
            workSheet.Cells(row, vLocation).Style.Locked = False
            Dim strLocation = Convert.ToString(workSheet.Cells(row, vLocation).Value)

 Next
</code></pre>

<p>Even i tried following code to unlock the worksheet with EPPlus</p>

<pre><code>    Try
        workSheet.Protection.IsProtected = False
        workSheet.Cells("A1:Z200").Style.Locked = False
    Catch ex As Exception
    End Try
</code></pre>

<p>But it does not work. If I unlock cells manually and upload file then it works. </p>

<p><a href="https://i.stack.imgur.com/6q2Vj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6q2Vj.png" alt="enter image description here"></a></p>

<p>otherwise following line returns nothing</p>

<pre><code>Dim strLocation = Convert.ToString(workSheet.Cells(row, vLocation).Value)
</code></pre>