private void btnCreate_Click(object sender, System.EventArgs e)
{
#region Workbook Initialize
//New instance of XlsIO is created.[Equivalent to launching MS Excel with no workbooks open].
//The instantiation process consists of two steps.
//Step 1 : Instantiate the spreadsheet creation engine.
ExcelEngine excelEngine = new ExcelEngine();
//Step 2 : Instantiate the excel application object.
IApplication application = excelEngine.Excel;
//Set the Default version as Excel 97to2003
if (this.rdbExcel97.Checked)
{
application.DefaultVersion = ExcelVersion.Excel97to2003;
fileName = "InteractiveFeatures.xls";
}
//Set the Default version as Excel 2007
else if (this.rdbExcel2007.Checked)
{
application.DefaultVersion = ExcelVersion.Excel2007;
fileName = "InteractiveFeatures.xlsx";
}
//Set the Default version as Excel 2010
else if (this.rdbExcel2010.Checked)
{
application.DefaultVersion = ExcelVersion.Excel2010;
fileName = "InteractiveFeatures.xlsx";
}
//Set the Default version as Excel 2013
else if (this.rdbExcel2013.Checked)
{
application.DefaultVersion = ExcelVersion.Excel2013;
fileName = "InteractiveFeatures.xlsx";
}
//A new workbook is created.[Equivalent to creating a new workbook in MS Excel]
//The new workbook will have 3 worksheets
IWorkbook workbook = application.Workbooks.Create(3);
//The first worksheet object in the worksheets collection is accessed.
IWorksheet sheet = workbook.Worksheets[0];
#endregion
sheet.IsGridLinesVisible = false;
sheet.Range["B2"].Text = "Interactive features";
sheet.Range["B2"].CellStyle.Font.Bold = true;
sheet.Range["B2"].CellStyle.Font.Size = 14;
sheet.Range["A4"].Text = "Some Useful links";
sheet.Range["A4"].CellStyle.Font.Bold = true;
sheet.Range["A4"].CellStyle.Font.Size = 12;
sheet.Range["A20"].Text = "Comments";
sheet.Range["A20"].CellStyle.Font.Bold = true;
sheet.Range["A20"].CellStyle.Font.Size = 12;
sheet.Range["B5"].Text = "Feature page";
sheet.Range["B7"].Text = "Support Email Id";
sheet.Range["B9"].Text = "Samples";
sheet.Range["B11"].Text = "Read the comment about XlsIO";
sheet.Range["B13"].Text = "Read the Comment about Interactive features";
sheet.Range["B20"].Text = "XlsIO";
sheet.Range["B22"].Text = "Interactive features";
#region Hyperlink
//Creating Hyperlink for a Website
IHyperLink hyperlink = sheet.HyperLinks.Add(sheet.Range["C5"]);
hyperlink.Type = ExcelHyperLinkType.Url;
hyperlink.Address = "http://www.syncfusion.com/products/windows-forms/xlsio";
hyperlink.ScreenTip = "To know more About XlsIO go through this link";
//Creating Hyperlink for e-mail
IHyperLink hyperlink1 = sheet.HyperLinks.Add(sheet.Range["C7"]);
hyperlink1.Type = ExcelHyperLinkType.Url;
hyperlink1.Address = "mailto:[email protected]";
hyperlink1.ScreenTip = "Send Mail to this id for your queries";
//Creating Hyperlink for Opening Files using type as File
IHyperLink hyperlink2 = sheet.HyperLinks.Add(sheet.Range["C9"]);
hyperlink2.Type = ExcelHyperLinkType.File;
hyperlink2.Address = "../../../";
hyperlink2.ScreenTip = "File path";
hyperlink2.TextToDisplay = "Hyperlink for files using File as type";
//Creating Hyperlink to another cell using type as Workbook
IHyperLink hyperlink4 = sheet.HyperLinks.Add(sheet.Range["C11"]);
hyperlink4.Type = ExcelHyperLinkType.Workbook;
hyperlink4.Address = "Sheet1!B20";
hyperlink4.ScreenTip = "Click here";
hyperlink4.TextToDisplay = "Click here to move to the cell with Comments about XlsIO";
IHyperLink hyperlink5 = sheet.HyperLinks.Add(sheet.Range["C13"]);
hyperlink5.Type = ExcelHyperLinkType.Workbook;
hyperlink5.Address = "Sheet1!B22";
hyperlink5.ScreenTip = "Click here";
hyperlink5.TextToDisplay = "Click here to move to the cell with Comments about this sample";
#endregion
#region Comments
//Insert Comments
//Adding comments to a cell.
sheet.Range["B20"].AddComment().Text = "XlsIO is a Backoffice product with high performance!";
//Add RichText Comments
IRange range = sheet.Range["B22"];
range.AddComment().RichText.Text = "Great Sample!";
IRichTextString rtf = range.Comment.RichText;
//Formatting first 4 characters
IFont greyFont = workbook.CreateFont();
greyFont.Bold = true;
greyFont.Italic = true;
greyFont.RGBColor = Color.FromArgb(333365);
rtf.SetFont(0, 3, greyFont);
//Formatting last 4 characters
IFont greenFont = workbook.CreateFont();
greenFont.Bold = true;
greenFont.Italic = true;
greenFont.RGBColor = Color.Green;
rtf.SetFont(4, 7, greenFont);
//Set column width
sheet.Columns[0].ColumnWidth = 30;
#endregion
#region Autofit the UsedRanges
sheet.UsedRange.AutofitRows();
sheet.UsedRange.AutofitColumns();
#endregion
#region Save the Workbook
//Saving the workbook to disk.
workbook.SaveAs(fileName);
#endregion
#region Workbook Close and Dispose
//Close the workbook.
workbook.Close();
//No exception will be thrown if there are unsaved workbooks.
excelEngine.ThrowNotSavedOnDestroy = false;
excelEngine.Dispose();
#endregion
#region View the Workbook
//Message box confirmation to view the created spreadsheet.
if (MessageBox.Show("Do you want to view the workbook?", "Workbook has been created",
MessageBoxButtons.YesNo, MessageBoxIcon.Information)
== DialogResult.Yes)
{
//Launching the Excel file using the default Application.[MS Excel Or Free ExcelViewer]
#if NETCORE
System.Diagnostics.Process process = new System.Diagnostics.Process();
process.StartInfo = new System.Diagnostics.ProcessStartInfo(fileName)
{
UseShellExecute = true
};
process.Start();
#else
Process.Start(fileName);
#endif
//Exit
this.Close();
}
else
{
// Exit
this.Close();
}
#endregion
}
//
// GET: /InteractiveFeatures/
public ActionResult InteractiveFeatures(string Saveoption)
{
if (Saveoption == null)
{
return(View());
}
//New instance of XlsIO is created.[Equivalent to launching Microsoft Excel with no workbooks open].
//The instantiation process consists of two steps.
//Step 1 : Instantiate the spreadsheet creation engine.
ExcelEngine excelEngine = new ExcelEngine();
//Step 2 : Instantiate the excel application object.
IApplication application = excelEngine.Excel;
// Default version is set as Excel 2007
if (Saveoption == "Xls")
{
application.DefaultVersion = ExcelVersion.Excel97to2003;
}
else
{
application.DefaultVersion = ExcelVersion.Excel2016;
}
//A new workbook is created.[Equivalent to creating a new workbook in Microsoft Excel]
//The new workbook will have 3 worksheets
IWorkbook workbook = application.Workbooks.Create(3);
//The first worksheet object in the worksheets collection is accessed.
IWorksheet sheet = workbook.Worksheets[0];
sheet.IsGridLinesVisible = false;
sheet.Range["B2"].Text = "Interactive features";
sheet.Range["B2"].CellStyle.Font.Bold = true;
sheet.Range["B2"].CellStyle.Font.Size = 14;
sheet.Range["A4"].Text = "Some Useful links";
sheet.Range["A4"].CellStyle.Font.Bold = true;
sheet.Range["A4"].CellStyle.Font.Size = 12;
sheet.Range["A20"].Text = "Comments";
sheet.Range["A20"].CellStyle.Font.Bold = true;
sheet.Range["A20"].CellStyle.Font.Size = 12;
sheet.Range["B5"].Text = "Feature page";
sheet.Range["B7"].Text = "Support Email Id";
sheet.Range["B11"].Text = "Read the comment about XlsIO";
sheet.Range["B13"].Text = "Read the Comment about Interactive features";
sheet.Range["B20"].Text = "XlsIO";
sheet.Range["B22"].Text = "Interactive features";
#region Hyperlink
//Creating Hyperlink for a Website
IHyperLink hyperlink = sheet.HyperLinks.Add(sheet.Range["C5"]);
hyperlink.Type = ExcelHyperLinkType.Url;
hyperlink.Address = "http://www.syncfusion.com/products/windows-forms/xlsio";
hyperlink.ScreenTip = "To know more About XlsIO go through this link";
//Creating Hyperlink for e-mail
IHyperLink hyperlink1 = sheet.HyperLinks.Add(sheet.Range["C7"]);
hyperlink1.Type = ExcelHyperLinkType.Url;
hyperlink1.Address = "mailto:[email protected]";
hyperlink1.ScreenTip = "Send Mail to this id for your queries";
//Creating Hyperlink to another cell using type as Workbook
IHyperLink hyperlink4 = sheet.HyperLinks.Add(sheet.Range["C11"]);
hyperlink4.Type = ExcelHyperLinkType.Workbook;
hyperlink4.Address = "Sheet1!B20";
hyperlink4.ScreenTip = "Click here";
hyperlink4.TextToDisplay = "Click here to move to the cell with Comments about XlsIO";
IHyperLink hyperlink5 = sheet.HyperLinks.Add(sheet.Range["C13"]);
hyperlink5.Type = ExcelHyperLinkType.Workbook;
hyperlink5.Address = "Sheet1!B22";
hyperlink5.ScreenTip = "Click here";
hyperlink5.TextToDisplay = "Click here to move to the cell with Comments about this sample";
#endregion
#region Comments
//Insert Comments
//Adding comments to a cell.
sheet.Range["B20"].AddComment().Text = "XlsIO is a Backoffice product with high performance!";
//Add RichText Comments
IRange range = sheet.Range["B22"];
range.AddComment().RichText.Text = "This sample describes the Essential XlsIO interactive.";
IRichTextString rtf = range.Comment.RichText;
//Formatting first 4 characters
IFont greyFont = workbook.CreateFont();
greyFont.Bold = true;
greyFont.Italic = true;
greyFont.RGBColor = Color.FromArgb(333365);
rtf.SetFont(0, 54, greyFont);
#endregion
sheet.UsedRange.AutofitColumns();
try
{
//Saving the workbook to disk.
if (Saveoption == "Xls")
{
return(excelEngine.SaveAsActionResult(workbook, "InteractiveFeatures.xls", HttpContext.ApplicationInstance.Response, ExcelDownloadType.PromptDialog, ExcelHttpContentType.Excel97));
}
else
{
return(excelEngine.SaveAsActionResult(workbook, "InteractiveFeatures.xlsx", HttpContext.ApplicationInstance.Response, ExcelDownloadType.PromptDialog, ExcelHttpContentType.Excel2016));
}
}
catch (Exception)
{
}
//Close the workbook.
workbook.Close();
excelEngine.Dispose();
return(View());
}