public Form1()
{
InitializeComponent();
excelEngine = new ExcelEngine();
importingHelper = new ImportingHelper();
FileStream fileStream = new FileStream(@"..\..\Data\Sample.xlsx", FileMode.Open);
if (fileStream != null)
{
workbook = excelEngine.Excel.Workbooks.Open(fileStream, ExcelOpenType.Automatic);
importingHelper.LoadWorkbook(this.tabBarSplitterControl1, workbook);
gridModelCollection = importingHelper.gridModelCollection;
}
//Used to focus formula cell when it is edit mode
GridFormulaCellRenderer.ForceEditWhenActivated = false;
}
private void importButton_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Files(*.xls)|*.xls|Files(*.xlsx)|*xlsx";
openFileDialog.DefaultExt = ".xls";
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
importingHelper.UnHookingEvents();
workbook.Close();
FileStream fileStream = new FileStream(openFileDialog.FileName, FileMode.Open);
if (fileStream != null)
{
workbook = excelEngine.Excel.Workbooks.Open(fileStream, ExcelOpenType.Automatic);
importingHelper.excelConverter.ImportBorders = this.importBordersCheckBox.Checked;
importingHelper.excelConverter.ImportStyles = this.importStylesCheckBox.Checked;
importingHelper.LoadWorkbook(this.tabBarSplitterControl1, workbook);
gridModelCollection = importingHelper.gridModelCollection;
}
}
}
public Form1()
{
InitializeComponent();
if (DpiAware.GetCurrentDpi() > 96)
{
this.CaptionBarHeight = (int)DpiAware.LogicalToDeviceUnits(this.CaptionBarHeight);
}
excelEngine = new ExcelEngine();
importingHelper = new ImportingHelper();
#if !NETCORE
FileStream fileStream = new FileStream(@"..\..\Data\Sample.xlsx", FileMode.Open);
#else
FileStream fileStream = new FileStream(@"..\..\..\Data\Sample.xlsx", FileMode.Open);
#endif
if (fileStream != null)
{
workbook = excelEngine.Excel.Workbooks.Open(fileStream, ExcelOpenType.Automatic);
importingHelper.LoadWorkbook(this.tabBarSplitterControl1, workbook);
gridModelCollection = importingHelper.gridModelCollection;
}
//Used to focus formula cell when it is edit mode
GridFormulaCellRenderer.ForceEditWhenActivated = false;
}