How to read cell values that are dynamically generated using macros in c#?

worksheet 

public Excel.Worksheet worksheet1 = null;

public ReadExcelDoc(string filename)
        {
            app = new Excel.Application();
            workbook = app.Workbooks.Open(filename, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue);
            worksheet1 = (Excel.Worksheet)workbook.Worksheets.get_Item(1);
            worksheet2 = (Excel.Worksheet)workbook.Worksheets.get_Item(2);
            String or int or double as you need = readData(1, 1, worksheet1);
            Close();
        }



public double readData(int row, int col, Excel.Worksheet worksheet)
        {
            Object data;

            workSheet_range = (Excel.Range)worksheet.Cells[row, col];
            data = (System.Object)workSheet_range.get_Value(Missing.Value);
            return Convert.ToDouble(data);
        }

 private object misValue = System.Reflection.Missing.Value;