small excell conversion from vb.net to c#.

I have the following:
  private void ProcessSpreadsheet(string filename)
        {
            Microsoft.Office.Interop.Excel.Application xlApp;
            // Excel application object
            Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
            // Excel Workbook object
            Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
            // Excel Worksheet object
            Microsoft.Office.Interop.Excel.Range inputRange;
            // Excel Worksheet Range object
            int rowCount;
            int currRow;
            // row iterator
            string gradeName;
            // character input variables
            double Price;
            // price as a decimal number
            Microsoft.Office.Interop.Excel.Range cellvalue;
            double[,] discounts = new double[5, 4];
            int pricesColumn;

            // Define the input SS and open the 1st worksheet
            xlApp = new Microsoft.Office.Interop.Excel.Application();
            xlWorkBook = xlApp.Workbooks.Open(filename);
            xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.Item(1);

            // Store the rows and columns used in the input SS into inputRange
            inputRange = xlWorkSheet.UsedRange;

            // Read all used rows in the input SS, starting at the 11th row (rows are numbered from 0)
            // Data of interest is in columns O and R (numbered 15 and 18 respectively)

            for (rowCount = 10; rowCount <= inputRange.Rows.Count; rowCount++)
            {
                // Read the grade name and price
                // skip rows where the grade name is empty
                try
                {
                    // Initial prices load file has the prices in column 16
                    // All other load files have their prices in column 18
                    if (initialButton.Checked == true)
                    {
                        pricesColumn = 16;
                    }
                    else
                    {
                        pricesColumn = 18;
                    }
                    cellvalue = (Microsoft.Office.Interop.Excel.Range)inputRange.Cells(rowCount, pricesColumn);
                    if (Strings.Len(cellvalue.Value) > 0)
                    {
                        if (cellvalue.Value.ToString == "Stones" | cellvalue.Value.ToString == "Tough")
                        {
                            // all prices have been read
                            currRow = rowCount + 1;
                            // skip a row to where the discounts are
                            break; // TODO: might not be correct. Was : Exit For
                        }
                        Price = (double)cellvalue.Value;
                        cellvalue = (Microsoft.Office.Interop.Excel.Range)inputRange.Cells(rowCount, 15);
                        gradeName = cellvalue.Value.ToString;
                        Insert_Price_List_Detail(gradeName, Price);
                        // insert the prices
                    }
                }
                catch
                {
                    Console.WriteLine("Exception has occurred.");
                }
            }

            // Process discounts
            for (rowCount = currRow; rowCount <= currRow + 3; rowCount++)
            {
                // Read the discounts
                try
                {
                    cellvalue = (Microsoft.Office.Interop.Excel.Range)inputRange.Cells(rowCount, 16);
                    if (Strings.Len(cellvalue.Value) > 0)
                    {
                        discounts[rowCount - currRow, 0] = (double)cellvalue.Value;
                        cellvalue = (Microsoft.Office.Interop.Excel.Range)inputRange.Cells(rowCount, 17);
                        discounts[rowCount - currRow, 1] = (double)cellvalue.Value;
                        cellvalue = (Microsoft.Office.Interop.Excel.Range)inputRange.Cells(rowCount, 18);
                        if (cellvalue.Value.ToString != "N/A")
                        {
                            // Des Barley is the last discount
                            discounts[rowCount - currRow, 2] = (double)cellvalue.Value;
                            Update_Price_List_Header_with_Discounts(discounts);
                            // save the discounts
                            break; // TODO: might not be correct. Was : Exit For
                        }
                        else
                        {
                            discounts[rowCount - currRow, 2] = 0;
                        }
                    }
                }
                catch
                {
                    Console.WriteLine("Exception has occurred.");
                }
            }

            inputRange = null;
            xlWorkSheet = null;
            if (xlWorkBook != null)
            {
                xlWorkBook.Close(false);
            }
            xlWorkBook = null;
            if (xlApp != null)
            {
                xlApp.Quit();
            }
            xlApp = null;

        }

Error      1      Cannot apply indexing with [] to an expression of type 'method group'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      37      26      InitialPriceReportingSpreadsheet
Error      2      Property, indexer, or event 'Item' is not supported by the language; try directly calling accessor method 'Microsoft.Office.Interop.Excel.Sheets.get_Item(object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      38      91      InitialPriceReportingSpreadsheet
Error      3      The name 'initialButton' does not exist in the current context      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      54      25      InitialPriceReportingSpreadsheet
Error      4      'Microsoft.Office.Interop.Excel.Range.Cells' is a 'property' but is used like a 'method'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      62      82      InitialPriceReportingSpreadsheet
Error      5      The name 'Strings' does not exist in the current context      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      63      25      InitialPriceReportingSpreadsheet
Error      6      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      63      47      InitialPriceReportingSpreadsheet
Error      7      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      65      39      InitialPriceReportingSpreadsheet
Error      8      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      65      78      InitialPriceReportingSpreadsheet
Error      9      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      72      51      InitialPriceReportingSpreadsheet
Error      10      'Microsoft.Office.Interop.Excel.Range.Cells' is a 'property' but is used like a 'method'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      73      86      InitialPriceReportingSpreadsheet
Error      11      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      74      47      InitialPriceReportingSpreadsheet
Error      12      'Microsoft.Office.Interop.Excel.Range.Cells' is a 'property' but is used like a 'method'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      91      82      InitialPriceReportingSpreadsheet
Error      13      The name 'Strings' does not exist in the current context      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      92      25      InitialPriceReportingSpreadsheet
Error      14      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      92      47      InitialPriceReportingSpreadsheet
Error      15      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      94      78      InitialPriceReportingSpreadsheet
Error      16      'Microsoft.Office.Interop.Excel.Range.Cells' is a 'property' but is used like a 'method'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      95      86      InitialPriceReportingSpreadsheet
Error      17      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      96      78      InitialPriceReportingSpreadsheet
Error      18      'Microsoft.Office.Interop.Excel.Range.Cells' is a 'property' but is used like a 'method'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      97      86      InitialPriceReportingSpreadsheet
Error      19      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      98      39      InitialPriceReportingSpreadsheet
Error      20      Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      101      82      InitialPriceReportingSpreadsheet
Error      21      No overload for method 'Close' takes '1' arguments      C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs      122      17      InitialPriceReportingSpreadsheet

Private Sub Open_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpen.Click
        Dim xlApp As Excel.Application               ' Excel application object
        Dim xlWorkBook As Excel.Workbook             ' Excel Workbook object
        Dim xlWorkSheet As Excel.Worksheet           ' Excel Worksheet object
        Dim inputRange As Excel.Range                ' Excel Worksheet Range object
        Dim rowCount, currRow As Integer             ' row iterator 
        Dim gradeName As String                      ' character input variables
        Dim Price As Double                          ' price as a decimal number
        Dim cellvalue As Excel.Range
        Dim discounts(4, 3) As Double
        Dim pricesColumn As Integer
 
        ' Define the input SS and open the 1st worksheet
        xlApp = New Excel.Application
        xlWorkBook = xlApp.Workbooks.Open(txtFileInput.Text)
        xlWorkSheet = CType(xlWorkBook.Worksheets.Item(1), Excel.Worksheet)
 
        ' Store the rows and columns used in the input SS into inputRange
        inputRange = xlWorkSheet.UsedRange
 
        ' Read all used rows in the input SS, starting at the 11th row (rows are numbered from 0)
        ' Data of interest is in columns O and R (numbered 15 and 18 respectively)
 
        For rowCount = 10 To inputRange.Rows.Count
            ' Read the grade name and price
            ' skip rows where the grade name is empty
            Try
                ' Initial prices load file has the prices in column 16
                ' All other load files have their prices in column 18
                If initialButton.Checked = True Then
                    pricesColumn = 16
                Else
                    pricesColumn = 18
                End If
                cellvalue = CType(inputRange.Cells(rowCount, pricesColumn), Excel.Range)
                If Len(cellvalue.Value) > 0 Then
                    If cellvalue.Value.ToString = "Stones" Or cellvalue.Value.ToString = "Tough" Then ' all prices have been read
                        currRow = rowCount + 1 ' skip a row to where the discounts are
                        Exit For
                    End If
                    Price = CDbl(cellvalue.Value)
                    cellvalue = CType(inputRange.Cells(rowCount, 15), Excel.Range)
                    gradeName = cellvalue.Value.ToString
                    Insert_Price_List_Detail(gradeName, Price) ' insert the prices
                End If
            Catch
                Console.WriteLine("Exception has occurred.")
            End Try
        Next
 
        ' Process discounts
        For rowCount = currRow To currRow + 3
            ' Read the discounts
            Try
                cellvalue = CType(inputRange.Cells(rowCount, 16), Excel.Range)
                If Len(cellvalue.Value) > 0 Then
                    discounts(rowCount - currRow, 0) = CDbl(cellvalue.Value)
                    cellvalue = CType(inputRange.Cells(rowCount, 17), Excel.Range)
                    discounts(rowCount - currRow, 1) = CDbl(cellvalue.Value)
                    cellvalue = CType(inputRange.Cells(rowCount, 18), Excel.Range)
                    If cellvalue.Value.ToString <> "N/A" Then ' Des Barley is the last discount
                        discounts(rowCount - currRow, 2) = CDbl(cellvalue.Value)
                        Update_Price_List_Header_with_Discounts(discounts) ' save the discounts
                        Exit For
                    Else
                        discounts(rowCount - currRow, 2) = 0
                    End If
                End If
            Catch
                Console.WriteLine("Exception has occurred.")
            End Try
        Next
 
        inputRange = Nothing
        xlWorkSheet = Nothing
        If xlWorkBook IsNot Nothing Then
            xlWorkBook.Close(False)
        End If
        xlWorkBook = Nothing
        If xlApp IsNot Nothing Then
            xlApp.Quit()
        End If
        xlApp = Nothing
 
        ' Disable the "Open" button, so the user knows the file has been
        ' processed
        btnOpen.Enabled = False
    End Sub

Select allOpen in new window