/// <summary>
/// 单元格大小比较，用于排序
/// </summary>
/// <param name="cell">比较单元格</param>
/// <returns>1:较大 0:相等 -1:较小</returns>
public override int compareTo(FCGridCell cell)
{
double value = getDouble();
double target = cell.getDouble();
if (value > target)
{
return(1);
}
else if (value < target)
{
return(-1);
}
else
{
return(0);
}
}
/// <summary>
/// 导出到Excel
/// </summary>
/// <param name="path">路径</param>
public static void exportToExcel(String fileName, FCGrid grid)
{
DataTable dataTable = new DataTable();
List <FCGridColumn> columns = grid.m_columns;
int columnsSize = columns.Count;
for (int i = 0; i < columnsSize; i++)
{
dataTable.Columns.Add(new DataColumn(columns[i].Text));
}
List <FCGridRow> rows = grid.m_rows;
int rowsSize = rows.Count;
for (int i = 0; i < rowsSize; i++)
{
if (rows[i].Visible)
{
DataRow dr = dataTable.NewRow();
for (int j = 0; j < columnsSize; j++)
{
FCGridCell cell = grid.m_rows[i].getCell(j);
if (cell is FCGridStringCell)
{
dr[j] = cell.getString();
}
else
{
dr[j] = cell.getDouble();
}
}
dataTable.Rows.Add(dr);
}
}
DataCenter.ExportService.ExportDataTableToExcel(dataTable, fileName);
dataTable.Dispose();
}