public void SortRanges(CellDescriptor cd1Top, CellDescriptor cd1Bottom, int SortColumnIdx1, bool sortAscending1, int SortColumnIdx2, bool sortAscending2)
{
try
{
_Worksheet ws = (_Worksheet)(this.worksheet);
ws.Activate();
Range sortRange1 = ws.get_Range(GetCellName(cd1Top), GetCellName(cd1Bottom));
sortRange1.Sort
(sortRange1.Columns[SortColumnIdx1, _MISSING_], ((sortAscending1) ? XlSortOrder.xlAscending : XlSortOrder.xlDescending),
sortRange1.Columns[SortColumnIdx2, _MISSING_], _MISSING_, ((sortAscending2) ? XlSortOrder.xlAscending : XlSortOrder.xlDescending),
_MISSING_, XlSortOrder.xlAscending,
XlYesNoGuess.xlNo, _MISSING_, _MISSING_,
XlSortOrientation.xlSortColumns,
XlSortMethod.xlPinYin,
XlSortDataOption.xlSortNormal,
XlSortDataOption.xlSortNormal,
XlSortDataOption.xlSortNormal);
/*
* SortRange(cd1Top, cd1Bottom, SortColumnIdx1, sortAscending1);
* SortRange(cd1Top, cd1Bottom, SortColumnIdx2, sortAscending2);*/
}
catch (Exception e)
{
}
}
/// <summary>
/// Gets Span Name
/// </summary>
/// <param name="cdFrom"></param>
/// <param name="cdTo"></param>
/// <returns></returns>
public string GetSpanName(CellDescriptor cdFrom, CellDescriptor cdTo)
{
Range cRange1 = (Range)(worksheet.Cells[cdFrom.Row, cdFrom.Col]);
Range cRange2 = (Range)(worksheet.Cells[cdTo.Row, cdTo.Col]);
Range cRange = (Range)(worksheet.get_Range(cRange1.AddressLocal, cRange2.AddressLocal));
return(cRange.AddressLocal);
}
public void SortRange(CellDescriptor cd1, CellDescriptor cd2, int SortColumnIdx, bool sortAscending = true)
{
_Worksheet ws = (_Worksheet)(this.worksheet);
ws.Activate();
Range sortRange = ws.get_Range(GetCellName(cd1), GetCellName(cd2));
sortRange.Sort
(sortRange.Columns[SortColumnIdx, _MISSING_], XlSortOrder.xlDescending,
_MISSING_, _MISSING_, ((sortAscending)?XlSortOrder.xlAscending:XlSortOrder.xlDescending),
_MISSING_, XlSortOrder.xlAscending,
XlYesNoGuess.xlNo, _MISSING_, _MISSING_,
XlSortOrientation.xlSortColumns,
XlSortMethod.xlPinYin,
XlSortDataOption.xlSortNormal,
XlSortDataOption.xlSortNormal,
XlSortDataOption.xlSortNormal);
}
Range setCellValue(CellDescriptor cd)
{
Range cRange = (Range)(worksheet.Cells[cd.Row, cd.Col]);
if (!string.IsNullOrEmpty(cd.Value))
{
worksheet.Cells[cd.Row, cd.Col] = cd.Value;
}
if (0 != cd.Color)
{
cRange.Font.Color = cd.Color;
}
if (0 != cd.BgColor)
{
cRange.Interior.Color = cd.BgColor;
}
if (cd.MakeBold)
{
cRange.Font.Bold = true;
}
return(cRange);
}
/// <summary>
/// Gets a Cell Name
/// </summary>
/// <param name="cd">Give a name of the cell at cd.Row and cd.Col</param>
/// <returns>cell name</returns>
public string GetCellName(CellDescriptor cd)
{
Range cRange = (Range)(worksheet.Cells[cd.Row, cd.Col]);
return(cRange.AddressLocal);
}