Just add the function to your class just like this..
public class findbeam
{
public static string RangeToString(Range range)
{
object[,] values = range.get_Value
(Excel.XlRangeValueDataType.xlRangeValueDefault) as object[,];
StringBuilder sb = new StringBuilder();
for (int i = 1; i <= values.GetUpperBound(0); i++)
{
sb.Append("\n"); // new line for each row
for (int j = 1; j <= values.GetUpperBound(1); j++)
{
sb.Append(string.Format("{0} ", values[i, j]));
}
}
return sb.ToString();
}
[ComVisibleAttribute(true)]
public string FindBeam(double dist2, double w, double V, double M, double wthick)
{
object missing = System.Reflection.Missing.Value;
//object newTemplate = false;
//object docType = 0;
//object isVisible = true;
Excel._Application ExcelApp = new Excel.ApplicationClass();
ExcelApp.Visible = false;
Workbook objBook = ExcelApp.Workbooks._Open("C:\\Beam Data\\Wood.xls", Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Worksheet objSheet = (Worksheet)objBook.Sheets["Sheet1"];
ExcelApp.Visible = true;
ExcelApp.WindowState = XlWindowState.xlMinimized;
objSheet.Cells[12, 15] = w;
Range rang;
int off;
if (wthick < 5.0)
{
rang = objSheet.get_Range("I5", "I10");
off = 5;
}
else
{
rang = objSheet.get_Range("I11", "I15");
off = 11;
}
int Vrow = (int)ExcelApp.WorksheetFunction.Match(V, rang, 1);
Range ranga = objSheet.get_Range(objSheet.Cells[Vrow + off, 3], missing);
return RangeToString(ranga);
}
}