Databases
StackOverflow2013
Postsdbo
POwhat is the way to check whether excel cell is locked or not?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POwhat is the way to check whether excel cell is locked or not?
    text
    copied!<p>How to Check if a particluar cell in that range is locked,</p> <p>I am posting the small snippet of my code, Please suggestme , the better way of writing to cell if the cell is not locked.</p> <p>if (reader.HasRows) { minRow = 0; minCol = 0;</p> <pre><code> // Process each result in the result set while (reader.Read()) { // Create an array big enough to hold the column values object[] values = new object[reader.FieldCount]; // Add the array to the ArrayList rowList.Add(values); // Get the column values into the array reader.GetValues(values); int iValueIndex = 0; int jValueIndex = 1; // If the Reading Format is by ColumnByColumn if (CurTaskNode.ReadFormat == "ColumnbyColumn") { minCol = 0; int lengthHeader = 0; if (CurTaskNode.ReadHeader == true) { lengthHeader = CurTaskNode.HEADER_MAX_ROW - CurTaskNode.HEADER_MIN_ROW; } else { lengthHeader = CurTaskNode.HeaderData.Length; } for (int iCol = 0; iCol &lt; lengthHeader; iCol++) { // Checking whether the Header data exists or not if (CurTaskNode.HeaderData[minCol] != "") { //if (!(excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol]).Locked) //{ // Assigning the Value from reader to the particular cell in excel sheet excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol] = values[iValueIndex]; iValueIndex++; //} } minCol++; } minRow++; } </code></pre> <p>In the code, writing to excel cell is </p> <p>excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol] = values[iValueIndex];</p> <p>here I have to check the condition whether the cell is locked or not, I tried it, but this is not correct.</p> <p>CurTaskNode.DATA_MIN_ROW is the minrow value for that data to write in excel sheet, this value comes from XML file and if I have to write from (10, 2) to (20, 10) , cells, in which if the first cell is say locked, I cant write it to that cell and I have to proceed writing with other cells.</p> <p>Please help me in doing this. Thanks, Ramm</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload