/// <summary>
/// 初始化域信息
/// </summary>
/// <param name="rowIndex">行索引</param>
/// <param name="columnIndex">列索引</param>
/// <param name="value">值</param>
public void InitalizeRangeInformation(int rowIndex, int columnIndex, string value, double height)
{
try
{
string range = ExcelHelper.GetColumnLetter(columnIndex) + rowIndex.ToString();
InitalizeRangeValue(range, range, value);
SetRangeHeight(range, range, height);
}
catch (SystemException ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
/// <summary>
/// 初始化域信息
/// </summary>
/// <param name="rowIndex">行索引</param>
/// <param name="columnIndex">列索引</param>
/// <param name="value">值</param>
public void InitalizeCellInformation(int rowIndex, int columnIndex, object value, int endRowIndex = 0)
{
try
{
string range = ExcelHelper.GetColumnLetter(columnIndex) + rowIndex.ToString();
string endRange = string.Empty;
if (endRowIndex == 0)
{
endRange = range;
}
else
{
endRange = ExcelHelper.GetColumnLetter(columnIndex) + endRowIndex.ToString();
}
InitalizeRangeValue(range, endRange, value);
}
catch (SystemException ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
/// <summary>
/// 获取列值字母
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public string GetColumnLetter(int value)
{
return(ExcelHelper.GetColumnLetter(value));
}