AdvancedFeaturesCS

using System;
using System.Drawing;
 
using GemBox.Spreadsheet;
 
namespace AdvancedFeaturesCS
{
    class AdvancedFeaturesCS
    {
        [STAThread]
        static void Main(string[] args)
        {
            // TODO: If using GemBox.Spreadsheet Professional, put your serial key below.
            // Otherwise, if you are using GemBox.Spreadsheet Free, comment out the 
            // following line (Free version doesn't have SetLicense method). 
            // SpreadsheetInfo.SetLicense("YOUR-SERIAL-KEY-HERE");
 
            ExcelFile excelFile = new ExcelFile();
 
            ExcelWorksheetCollection worksheets = excelFile.Worksheets;
 
            ImagesSample(worksheets.Add("Images"));
            CommentsSample(worksheets.Add("Comments"));
            PrintViewOptionsSample(worksheets.Add("PrintViewOptions"));
            HyperlinkSample(worksheets.Add("Hyperlinks"));
            SummariesSample(excelFile);
 
            string fileName = "AdvancedFeatures.xlsx";
            excelFile.SaveXlsx(fileName);
 
            // Uncomment if you want to export in ODS.
            //string fileName = "AdvancedFeatures.ods";
            //excelFile.SaveOds(fileName);
 
            TryToDisplayGeneratedFile(fileName);
        }
 
        static void ImagesSample(ExcelWorksheet ws)
        {
            ws.Cells[0, 0].Value = "Image examples:";
 
            // Small BMP added by using rectangle.
            ws.Pictures.Add(@"..\..\SmallImage.bmp", new Rectangle(50, 50, 48, 48));
 
            // Large JPG added by using rectangle.
            ws.Pictures.Add(@"..\..\FragonardReader.jpg", new Rectangle(50, 150, 478, 600));
 
            // PNG added by using anchors.
            ws.Pictures.Add(@"..\..\Dices.png",
                PositioningMode.FreeFloating, new AnchorCell(ws.Columns[8], ws.Rows[16], true),
                new AnchorCell(ws.Columns[9], ws.Rows[20], false));
 
            // GIF added by using anchors. Notice that animation is lost in MS Excel.
            ws.Pictures.Add(@"..\..\Zahnrad.gif",
                PositioningMode.Move, new AnchorCell(ws.Columns[8], ws.Rows[22], 100000, 100000),
                new AnchorCell(ws.Columns[9], ws.Rows[24], 50000, 50000));
 
            // WMF added by using anchors.
            ws.Pictures.Add(@"..\..\Graphics1.wmf",
                PositioningMode.MoveAndSize, new AnchorCell(ws.Columns[10], ws.Rows[10], true),
                new AnchorCell(ws.Columns[15], ws.Rows[15], false));
        }
 
        static void CommentsSample(ExcelWorksheet ws)
        {
            ws.Cells[0, 0].Value = "Comment examples:";
 
            ws.Cells[2, 1].Comment.Text = "Empty cell.";
 
            ws.Cells[4, 1].Value = 5;
            ws.Cells[4, 1].Comment.Text = "Cell with a number.";
 
            ws.Cells["B7"].Value = "Cell B7";
            ws.Cells["B7"].Comment.Text = "Some text. Comment is:\na) multiline,\nb) large, and \nc) visible.";
            ws.Cells["B7"].Comment.IsVisible = true;
        }
 
        static void PrintViewOptionsSample(ExcelWorksheet ws)
        {
            ws.Cells["M1"].Value = "This worksheet shows how to set various print related and view related options.";
            ws.Cells["M2"].Value = "To see results of print options, go to Print and Page Setup dialogs in MS Excel.";
            ws.Cells["M3"].Value = "Notice that print and view options are worksheet based, not workbook based.";
 
            // Print options:
            ws.PrintOptions.Portrait = false;
            ws.PrintOptions.PaperSize = 8;
            ws.PrintOptions.NumberOfCopies = 5;
 
            // View options:
            ws.ViewOptions.FirstVisibleColumn = 3;
            ws.ViewOptions.ShowColumnsFromRightToLeft = true;
            ws.ViewOptions.Zoom = 123;
        }
 
        static void HyperlinkSample(ExcelWorksheet ws)
        {
            ws.Cells["B16"].Value = "GemboxSoftware";
            ws.Cells["B16"].Style.Font.UnderlineStyle = UnderlineStyle.Single;
            ws.Cells["B16"].Style.Font.Color = Color.Blue;
            ws.Cells["B16"].Hyperlink.Location = "http://www.gemboxsoftware.com";
            ws.Cells["B16"].Hyperlink.IsExternal = true;
 
            ws.Cells["B20"].Value = "Jump";
            ws.Cells["B20"].Hyperlink.ToolTip = "This is tool tip! This hyperlink jumps to A1!";
            ws.Cells["B20"].Hyperlink.Location = ws.Name + "!A1";
 
            ws.Cells["A1"].Value = "Jump Here";
        }
 
        private static void SummariesSample(ExcelFile excelFile)
        {
            var builtInDocProp = excelFile.DocumentProperties.BuiltIn;
            builtInDocProp[BuiltInDocumentProperties.Author] = Environment.UserName;
            builtInDocProp[BuiltInDocumentProperties.Title] = "Advanced Featrues Sample";
            builtInDocProp[BuiltInDocumentProperties.Comments] = "This is Advanced Featrues Sample";
 
            excelFile.DocumentProperties.Custom["X"] = "Some custom property";
        }
 
        static void TryToDisplayGeneratedFile(string fileName)
        {
            try
            {
                System.Diagnostics.Process.Start(fileName);
            }
            catch (Exception)
            {
                Console.WriteLine(fileName + " created in application folder.");
            }
        }
    }
}