public ImportXlsSheetControl(string filePath, XlsSheetMeta xlsSheetMeta)
{
InitializeComponent();
_filePath = filePath;
_sheetMeta = xlsSheetMeta;
_grid = new ReoGridControl();
ReoGridUtil.InitGrid(_grid, readOnly: true);
_gridLoadControl = new LoadingContainerControl {
ContainedControl = _grid, Dock = DockStyle.Fill
};
_previewPanel.Controls.Add(_gridLoadControl);
_columnsControl = new ImportColumnsControl {
Dock = DockStyle.Fill
};
_columnsControl.SetFixedColumnWidths();
_columnsLoadControl = new LoadingContainerControl {
ContainedControl = _columnsControl, Dock = DockStyle.Fill
};
_columnsPanel.Controls.Add(_columnsLoadControl);
Bind.OnChange(new Slot[] { _columnsControl.Change }, (sender, e) => ValueChanged?.Invoke(this, EventArgs.Empty));
_sheetOptions = new XlsSheetOptions();
_propGrid.SelectedObject = _sheetOptions;
}
public ColumnHeaderRange(XlsSheetOptions o)
{
FirstRowNumber = o.FirstRowNumber;
FirstColumnLetter = o.FirstColumnLetter;
LastColumnLetter = o.LastColumnLetter;
HeaderRow = o.ColumnHeaders == ColumnHeadersOption.Present;
}