/// <summary>
/// Init Worksheet
/// </summary>
private void InitWorksheet()
{
WorksheetAttribute classAttribue = _RecordModelType.GetCustomAttribute(typeof(WorksheetAttribute)) as WorksheetAttribute;
if (classAttribue != null)
{
_Worksheet.Name = classAttribue.Title;
}
else
{
_Worksheet.Name = _RecordModelType.Name;
}
PropertyInfo[] properties = _RecordModelType.GetProperties();
Dictionary <PropertyInfo, ColumnHeaderAttribute> ColHeaderAttributeDict = new Dictionary <PropertyInfo, ColumnHeaderAttribute>();
foreach (PropertyInfo property in properties)
{
ColumnHeaderAttribute headerAttribute = property.GetCustomAttribute(typeof(ColumnHeaderAttribute)) as ColumnHeaderAttribute;
if (headerAttribute != null && headerAttribute.IsVisible) //filter invisible item
{
ColHeaderAttributeDict.Add(property, headerAttribute);
}
}
if (ColHeaderAttributeDict.Count < 1)
{
#if DEBUG
Console.WriteLine("InitWorksheet Failed: HeaderAttributes.Count is 0.");
#endif
return;
}
ColHeaderAttributeDict = ColHeaderAttributeDict.OrderBy(one => one.Value.Index).ToDictionary(one => one.Key, one => one.Value); // order by index
// Re-Set Index
for (int i = 0; i < ColHeaderAttributeDict.Keys.Count; i++)
{
var key = ColHeaderAttributeDict.Keys.ElementAt(i);
ColHeaderAttributeDict[key].Index = i;
}
_Worksheet.Columns = ColHeaderAttributeDict.Count;
RangePosition rangePosition = new RangePosition();
rangePosition.Cols = 1;
rangePosition.Row = 0;
rangePosition.Rows = _Worksheet.RowCount;
for (int i = 0; i < properties.Count(); i++)
{
PropertyInfo property = properties[i];
var attribute = property.GetCustomAttribute(typeof(FormatAttributeBase));
if (attribute == null)
{
continue;
}
IFormatArgs formatArgs = attribute as IFormatArgs;
if (formatArgs != null)
{
ColumnHeaderAttribute headerAttribute = (from key in ColHeaderAttributeDict.Keys
where key.Equals(property)
select ColHeaderAttributeDict[property]).FirstOrDefault();
if (headerAttribute != null && headerAttribute.IsVisible)
{
rangePosition.Col = headerAttribute.Index;
//not work correctly
switch (formatArgs.CellDataFormatFlag)
{
case CellDataFormatFlag.General:
break;
case CellDataFormatFlag.Number:
{
NumberFormatAttribute numberFormatAttribute = formatArgs as NumberFormatAttribute;
NumberDataFormatter.NumberFormatArgs numberFormatter = new NumberDataFormatter.NumberFormatArgs();
if (numberFormatAttribute.DecimalPlaces != short.MaxValue)
{
numberFormatter.DecimalPlaces = numberFormatAttribute.DecimalPlaces;
}
numberFormatter.NegativeStyle = numberFormatAttribute.NegativeStyle;
numberFormatter.UseSeparator = numberFormatAttribute.UseSeparator;
numberFormatter.CustomNegativePrefix = numberFormatAttribute.CustomNegativePrefix;
numberFormatter.CustomNegativePostfix = numberFormatAttribute.CustomNegativePostfix;
_Worksheet.SetRangeDataFormat(rangePosition, CellDataFormatFlag.Number, numberFormatter);
//_ReoGridControl.DoAction(new SetRangeDataFormatAction(rangePosition, CellDataFormatFlag.Number, numberFormatter));
break;
}
case CellDataFormatFlag.DateTime:
{
DateTimeFormatAttribute dateTimeFormatAttribute = formatArgs as DateTimeFormatAttribute;
DateTimeDataFormatter.DateTimeFormatArgs dateTimeFormatArgs = new DateTimeDataFormatter.DateTimeFormatArgs();
dateTimeFormatArgs.Format = dateTimeFormatAttribute.Format;
dateTimeFormatArgs.CultureName = dateTimeFormatAttribute.CultureName;
_Worksheet.SetRangeDataFormat(rangePosition, CellDataFormatFlag.DateTime, dateTimeFormatArgs);
break;
}
case CellDataFormatFlag.Percent:
break;
case CellDataFormatFlag.Currency:
break;
case CellDataFormatFlag.Text:
break;
case CellDataFormatFlag.Custom:
break;
default:
break;
}
}
}
}
_ColumnWidthList = new List <int>();
_RowHeightList = new List <int>();
for (int i = 0; i < ColHeaderAttributeDict.Count; i++)
{
ColumnHeaderAttribute headerAttribute = ColHeaderAttributeDict.ElementAt(i).Value;
if (string.IsNullOrEmpty(headerAttribute.Text))
{
_Worksheet.ColumnHeaders[i].Text = ColHeaderAttributeDict.ElementAt(i).Key.Name;
}
else
{
_Worksheet.ColumnHeaders[i].Text = headerAttribute.Text;
}
if (headerAttribute.Width <= 0)
{
_Worksheet.ColumnHeaders[i].IsAutoWidth = true;
}
else
{
_Worksheet.ColumnHeaders[i].Width = (ushort)headerAttribute.Width;
}
_Worksheet.ColumnHeaders[i].IsVisible = true;
_Worksheet.ColumnHeaders[i].Tag = ColHeaderAttributeDict.ElementAt(i).Key; // Tag stores PropertyInfo of Model
_ColumnWidthList.Add(_Worksheet.ColumnHeaders[i].Width); // store column width
}
//stroe row height
for (int i = 0; i < _Worksheet.Rows; i++)
{
_RowHeightList.Add(_Worksheet.RowHeaders[i].Height);
}
// load data
LoadRecords();
_Worksheet.BeforeCellEdit += Worksheet_BeforeCellEdit;
_Worksheet.CellDataChanged += Worksheet_CellDataChanged;
_Worksheet.RangeDataChanged += Worksheet_RangeDataChanged;
_Worksheet.AfterPaste += Worksheet_AfterPaste;
_Worksheet.RowsHeightChanged += Worksheet_RowsHeightChanged;
_Worksheet.ColumnsWidthChanged += Worksheet_ColumnsWidthChanged;
}
