private void OpenExcel_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog
{
Filter = "Excel files (*.xlsx)|*.xlsx",
Multiselect = false
};
if (openFileDialog.ShowDialog() == true)
{
InputSpread.Open(openFileDialog.FileName);
}
}
private void InputSpread_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
string sheetName;
for (int sheets = 0; sheets < InputSpread.Workbook.Worksheets.Count; sheets++)
{
sheetName = InputSpread.Workbook.Worksheets[sheets].Name;
int adopted = 0;
for (int col0 = 1; col0 < InputSpread.ActiveSheet.UsedRange.LastColumn + 1; col0++)
{
if (adopted == 0)
{
for (int v = 0; v < 4; v++)
{
if (InputSpread.ActiveSheet.Range[2, col0].Value.ToString() == ColArgs[v])
{
adopted = 1;
}
}
}
else
{
for (int col4 = 1; col4 < InputSpread.ActiveSheet.UsedRange.LastColumn + 1; col4++)
{
InputSpread.ActiveSheet.Range[2, col4].CellStyle.Color = colors[Int32.Parse(InputSpread.ActiveSheet.Range[1, col4].Value)];
InputSpread.ActiveSheet.Range[2, col4].CellStyle.Locked = true;
InputSpread.ActiveGrid.InvalidateCell(2, col4);
}
break;
}
}
if (adopted == 0)
{
InputSpread.SetActiveSheet(sheetName);
InputSpread.ActiveSheet.InsertRow(1, 2);
int lastcol = InputSpread.ActiveSheet.UsedRange.LastColumn + 1;
InputSpread.ActiveGrid.FrozenRows = 3;
for (int col = 1; col < lastcol; col++)
{
InputSpread.ActiveSheet.Range[1, col].Value = "0";
InputSpread.ActiveSheet.Range[2, col].Value = ColArgs[Int32.Parse(InputSpread.ActiveSheet.Range[1, col].Value)];
InputSpread.ActiveSheet.Range[2, col].CellStyle.Color = colors[Int32.Parse(InputSpread.ActiveSheet.Range[1, col].Value)];
InputSpread.ActiveSheet.Range[2, col].CellStyle.Locked = true;
}
}
InputSpread.ActiveSheet.CellValueChanged += ActiveSheet_CellValueChanged;
InputSpread.ActiveGrid.Model.ColumnsInserted += Model_ColumnsInserted;
}
}
private void InputSpread_WorksheetAdded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorksheetAddedEventArgs args)
{
string sheetName = args.SheetName;
InputSpread.SetActiveSheet(sheetName);
InputSpread.ActiveSheet.InsertRow(1, 2);
InputSpread.ActiveGrid.FrozenRows = 3;
for (int col = 1; col < InputSpread.ActiveGrid.ColumnCount + 1; col++)
{
InputSpread.ActiveSheet.Range[1, col].Value = "0";
InputSpread.ActiveSheet.Range[2, col].Value = ColArgs[Int32.Parse(InputSpread.ActiveSheet.Range[1, col].Value)];
InputSpread.ActiveSheet.Range[2, col].CellStyle.Color = colors[Int32.Parse(InputSpread.ActiveSheet.Range[1, col].Value)];
InputSpread.ActiveSheet.Range[2, col].CellStyle.Locked = true;
}
InputSpread.ActiveSheet.CellValueChanged += ActiveSheet_CellValueChanged;
InputSpread.ActiveGrid.Model.ColumnsInserted += Model_ColumnsInserted;
}
private void SaveExcel_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog
{
FileName = "Source",
DefaultExt = ".xlsx",
Filter = "Excel (.xlsx)|*.xlsx"
};
Nullable <bool> result = saveFileDialog.ShowDialog();
if (result == true)
{
string FileNameBase = saveFileDialog.FileName;
try
{
InputSpread.SaveAs(FileNameBase);
}
catch (IOException e2)
{
e2.StackTrace.ToString();
}
}
}
