/// <summary>
/// 获取一个Cell
/// </summary>
/// <param name="row"></param>
/// <param name="column"></param>
/// <returns></returns>
public dynamic Cell(int row, int column)
{
string rangStr = ExcelUtilityMethod.ConvertToTitle(column + 1) + (row + 1).ToString();
object tenmpRange = ExcelUtilityMethod.GetProperty(m_workSheet, "Range",
new object[] { rangStr });
return(ExcelUtilityMethod.GetProperty(tenmpRange, "Value"));
}
/// <summary>
/// 获取一个Range
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public Range Range(int row, int column)
{
string rangStr = ExcelUtilityMethod.ConvertToTitle(column + 1) + (row + 1).ToString();
object tenmpRange = ExcelUtilityMethod.GetProperty(m_workSheet, "Range",
new object[] { rangStr });
return(new Range(tenmpRange));
}
/// <summary>
/// 获取一个Cell
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public void Cell(int row, int column, dynamic input)
{
string rangStr = ExcelUtilityMethod.ConvertToTitle(column + 1) + (row + 1).ToString();
object tenmpRange = ExcelUtilityMethod.GetProperty(m_workSheet, "Range",
new object[] { rangStr });
ExcelUtilityMethod.SetProperty(tenmpRange, "Value", new object[] { input });
}
/// <summary>
/// 获取一个Range
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public Range Range(int rowOne, int columnOne, int rowTwo, int columnTwo)
{
string rangStrOne = ExcelUtilityMethod.ConvertToTitle(columnOne + 1) + (rowOne + 1).ToString();
string rangStrTwo = ExcelUtilityMethod.ConvertToTitle(columnTwo + 1) + (rowTwo + 1).ToString();
string rangStr = rangStrOne + ":" + rangStrTwo;
object tenmpRange = ExcelUtilityMethod.GetProperty(m_workSheet, "Range",
new object[] { rangStr });
return(new Range(tenmpRange));
}