ExcelWorksheet.Cells[row, col].value2 No Longer Works

Scott Stewart

1y1.3k.NET

I have a class in my project that accesses Excel worksheets. After upgrading from .Net 4.8 to .Net 8.0, every line using the "value2' or 'value' is an error. The class wont even compile. I made sure to add Microsoft.Office.Interop..Excel to the dependencies. The error is;

CS1061 'object' does not contain a definition for 'Value2' and no accessible extension method 'Value2' accepting a first argument of type 'object' could be found (are you missing a using directive or an assembly reference?)

Does anyone know what I can do to fix this?

Thanks,

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Anupam Maiti1y ago
Accepted answer
In .NET 6 and later, accessing COM properties might require casting to the appropriate types. You may need to cast ExcelWorksheet.Cells[row, col] to a range before accessing Value2.

Can you try this below ?
```
using Excel = Microsoft.Office.Interop.Excel;  
  
public void UpdateExcelCell(Excel.Worksheet worksheet, int row, int col, object value)  
{  
    var cell = worksheet.Cells[row, col] as Excel.Range;  
    if (cell != null)  
    {  
        cell.Value2 = value;  
    }  
}  
```
Make sure project is configured to support COM interop. This includes setting the correct target framework in your .csproj file:
```
  
  
    
    net8.0  
    true  
    
  
    
      
    
  
  
```
For more refer this: https://learn.microsoft.com/en-us/dotnet/csharp/advanced-topics/interop/how-to-access-office-interop-objects
+1