BuyLog In
Example E4339
Visible to All Users

Spreadsheet Document API – How to Process Excel Workbooks in Code (Part 1)

The DevExpress Spreadsheet Document API is a non-visual library that allows you to generate, import, export, modify, and print Microsoft Excel workbooks in code.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this library in production code.

This example demonstrates how to use the Spreadsheet Document API to execute the following actions:

  • Manage spreadsheet document elements (worksheets, cells, rows, and columns)
  • Create formulas
  • Format cells
  • Import data from different data sources
  • Export a workbook to PDF
  • Print a workbook
  • Specify the built-in and custom document properties

The application form contains the list of supported operations. A user can select an operation and click the Run button to view the resulting spreadsheet document in Microsoft Excel.

Spreadsheet Document API - List of Supported Operations

Files to Look At

C# Visual Basic
CellActions.cs CellActions.vb
DocumentPropertiesActions.cs DocumentPropertiesActions.vb
ExportActions.cs ExportActions.vb
FormattingActions.cs FormattingActions.vb
FormulaActions.cs FormulaActions.vb
ImportActions.cs ImportActions.vb
PrintingActions.cs PrintingActions.vb
RowAndColumnActions.cs RowAndColumnActions.vb
WorksheetActions.cs WorksheetActions.vb

Documentation

More Examples

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)

Example Code

SpreadsheetExamples/SpreadsheetActions/CellActions.cs(vb) 
C#
using System;
using System.Drawing;
using DevExpress.Spreadsheet;
using System.Collections.Generic;
using System.IO;
using System.IO.Ports;

namespace SpreadsheetExamples {
    public static class CellActions {

        #region Actions
        public static Action<Workbook> ChangeCellValueAction = ChangeCellValue;
        public static Action<Workbook> SetValueFromTextAction = SetValueFromText;
        public static Action<Workbook> CreateNamedRangeAction = CreateNamedRange;
        public static Action<Workbook> AddHyperlinkAction = AddHyperlink;
        public static Action<Workbook> PlaceImageInCellAction = PlaceImageInCell;
        public static Action<Workbook> CopyCellDataAndStyleAction = CopyCellDataAndStyle;
        public static Action<Workbook> MergeAndSplitCellsAction = MergeAndSplitCells;
        public static Action<Workbook> ClearCellsAction = ClearCells;
        #endregion

        static void ChangeCellValue(Workbook workbook) {
            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Cells["A1"].Value = "dateTime:";
            worksheet.Cells["A2"].Value = "double:";
            worksheet.Cells["A3"].Value = "string:";
            worksheet.Cells["A4"].Value = "error constant:";
            worksheet.Cells["A5"].Value = "boolean:";
            worksheet.Cells["A6"].Value = "float:";
            worksheet.Cells["A7"].Value = "char:";
            worksheet.Cells["A8"].Value = "int32:";
            worksheet.Cells["A10"].Value = "Fill a range of cells:";

            worksheet.Columns["A"].WidthInCharacters = 20;
            worksheet.Columns["B"].WidthInCharacters = 20;
            worksheet.Range["A1:B8"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Left;

            #region #CellValue
            // Add data of different types to cells.
            worksheet.Cells["B1"].Value = DateTime.Now;
            worksheet.Cells["B2"].Value = Math.PI;
            worksheet.Cells["B3"].Value = "Have a nice day!";
            worksheet.Cells["B4"].Value = CellValue.ErrorReference;
            worksheet.Cells["B5"].Value = true;
            worksheet.Cells["B6"].Value = float.MaxValue;
            worksheet.Cells["B7"].Value = 'a';
            worksheet.Cells["B8"].Value = Int32.MaxValue;

            // Fill all cells in the "B10:E10" range with 10.
            worksheet.Range["B10:E10"].Value = 10;
            #endregion #CellValue
        }

        static void SetValueFromText(Workbook workbook) {
            workbook.BeginUpdate();
            try {
                Worksheet worksheet = workbook.Worksheets[0];

                worksheet.Cells["A1"].Value = "dateTime:";
                worksheet.Cells["A2"].Value = "double:";
                worksheet.Cells["A3"].Value = "string:";
                worksheet.Cells["A4"].Value = "error constant:";
                worksheet.Cells["A5"].Value = "boolean:";
                worksheet.Cells["A6"].Value = "float:";
                worksheet.Cells["A7"].Value = "int32:";
                worksheet.Cells["A8"].Value = "datetime (cell number format):";
                worksheet.Cells["A9"].Value = "formula:";
                worksheet.Cells["A11"].Value = "Fill a range of cells:";

                worksheet.Columns["A"].WidthInCharacters = 40;
                worksheet.Columns["B"].WidthInCharacters = 20;

                #region #SetValueFromText
                // Add data of different types to cells.
                worksheet.Cells["B1"].SetValueFromText("27-Jul-16 5:43PM");
                worksheet.Cells["B2"].SetValueFromText("3.1415926536");
                worksheet.Cells["B3"].SetValueFromText("Have a nice day!");
                worksheet.Cells["B4"].SetValueFromText("#REF!");
                worksheet.Cells["B5"].SetValueFromText("true");
                worksheet.Cells["B6"].SetValueFromText("3.40282E+38");
                worksheet.Cells["B7"].SetValueFromText("2147483647");
                worksheet.Cells["B8"].NumberFormat = "###.###";
                worksheet.Cells["B8"].SetValueFromText("27-Jul-16 5:43PM", true);
                worksheet.Cells["B9"].SetValueFromText("=SQRT(25)");

                // Apply the date and time display format to the "C11:F11" cell range.
                worksheet.Range["C11:F11"].NumberFormat = "m/d/yy h:mm";
                // Fill all cells in the "C11:F11" range with the "B1" cell value. 
                worksheet.Range["C11:F11"].SetValueFromText("=B1", true);
                #endregion #SetValueFromText
            }
            finally {
                workbook.EndUpdate();
            }

        }

        static void CreateNamedRange(Workbook workbook) {

            #region #NamedRange
            Worksheet worksheet = workbook.Worksheets[0];

            // Create a range.
            CellRange rangeB3D6 = worksheet.Range["B3:D6"];
            // Specify the name for the created range.
            rangeB3D6.Name = "rangeB3D6";

            // Create a new defined name with the specifed range name and absolute reference.
            DefinedName definedName = worksheet.DefinedNames.Add("rangeB17D20", "Sheet1!$B$17:$D$20");
            // Use the specified defined name to obtain the cell range.
            CellRange B17D20 = worksheet.Range[definedName.Name];
            #endregion #NamedRange
        }

        static void AddHyperlink(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];
            
            worksheet.Range["A:C"].ColumnWidthInCharacters = 12;

            #region #AddHyperlink
            // Create a hyperlink to a web page.
            Cell cell = worksheet.Cells["A1"];
            worksheet.Hyperlinks.Add(cell, "http://www.devexpress.com/", true, "DevExpress");

            // Create a hyperlink to a cell range in a workbook.
            CellRange range = worksheet.Range["C3:D4"];
            Hyperlink cellHyperlink = worksheet.Hyperlinks.Add(range, "Sheet2!B2:E7", false, "Select Range");
            cellHyperlink.TooltipText = "Click Me";
            #endregion #AddHyperlink
        }

        static void CopyCellDataAndStyle(Workbook workbook) {
            #region #CopyCell
            Worksheet worksheet = workbook.Worksheets[0];
            
            worksheet.Columns["A"].WidthInCharacters = 32;
            worksheet.Columns["B"].WidthInCharacters = 20;
            Style style = workbook.Styles[BuiltInStyleId.Input];

            // Specify the content and formatting for a source cell.
            worksheet.Cells["A1"].Value = "Source Cell";

            Cell sourceCell = worksheet.Cells["B1"];
            sourceCell.Formula = "= PI()";
            sourceCell.NumberFormat = "0.0000";
            sourceCell.Style = style;
            sourceCell.Font.Color = Color.Blue;
            sourceCell.Font.Bold = true;
            sourceCell.Borders.SetOutsideBorders(Color.Black, BorderLineStyle.Thin);

            // Copy all information from the source cell to the "B3" cell. 
            worksheet.Cells["A3"].Value = "Copy All";
            worksheet.Cells["B3"].CopyFrom(sourceCell);

            // Copy only the source cell content (e.g., text, numbers, formula calculated values) to the "B4" cell.
            worksheet.Cells["A4"].Value = "Copy Values";
            worksheet.Cells["B4"].CopyFrom(sourceCell, PasteSpecial.Values);

            // Copy the source cell content (e.g., text, numbers, formula calculated values) 
            // and number formats to the "B5" cell.
            worksheet.Cells["A5"].Value = "Copy Values and Number Formats";
            worksheet.Cells["B5"].CopyFrom(sourceCell, PasteSpecial.Values | PasteSpecial.NumberFormats);

            // Copy only the formatting information from the source cell to the "B6" cell.
            worksheet.Cells["A6"].Value = "Copy Formats";
            worksheet.Cells["B6"].CopyFrom(sourceCell, PasteSpecial.Formats);

            // Copy all information from the source cell to the "B7" cell except for border settings.
            worksheet.Cells["A7"].Value = "Copy All Except Borders";
            worksheet.Cells["B7"].CopyFrom(sourceCell, PasteSpecial.All & ~PasteSpecial.Borders);

            // Copy information only about borders from the source cell to the "B8" cell.
            worksheet.Cells["A8"].Value = "Copy Borders";
            worksheet.Cells["B8"].CopyFrom(sourceCell, PasteSpecial.Borders);
            #endregion #CopyCell
        }

        static void MergeAndSplitCells(Workbook workbook) {
            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Cells["A1"].FillColor = Color.LightGray;

            worksheet.Cells["B2"].Value = "B2";
            worksheet.Cells["B2"].FillColor = Color.LightGreen;

            worksheet.Cells["C3"].Value = "C3";
            worksheet.Cells["C3"].FillColor = Color.LightSalmon;

            #region #MergeCells
            // Merge cells contained in the "A1:C5" range.
            worksheet.MergeCells(worksheet.Range["A1:C5"]);
            #endregion #MergeCells
        }

        static void PlaceImageInCell(Workbook workbook)
        {
            #region #PlaceImageInCell
            Worksheet worksheet = workbook.Worksheets.ActiveWorksheet;

            byte[] imageBytes = File.ReadAllBytes(@"Documents\x-docserver.png");
            MemoryStream imageStream = new MemoryStream(imageBytes);

            worksheet.Cells["A2"].ColumnWidthInCharacters = 20;
            // Insert cell images from a stream
            worksheet.Cells["A2"].Value = imageStream;

            // Specify image information
            if (worksheet.Cells["A2"].Value.IsCellImage)
            {
                worksheet.Cells["A2"].ImageInfo.Decorative = true;
                worksheet.Cells["A2"].ImageInfo.AlternativeText = "Image AltText";
            }
            #endregion #PlaceImageInCell


        }

        static void ClearCells(Workbook workbook) {
            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Range["A:D"].ColumnWidthInCharacters = 30;
            worksheet.Range["B1:D6"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

            worksheet["B1"].Value = "Initial Cell Content and Formatting:";
            worksheet.MergeCells(worksheet["C1:D1"]);
            worksheet["C1:D1"].Value = "Cleared Cells:";

            worksheet["A2"].Value = "Clear All:";
            worksheet["A3"].Value = "Clear Cell Content Only:";
            worksheet["A4"].Value = "Clear Cell Formatting Only:";
            worksheet["A5"].Value = "Clear Cell Hyperlinks Only:";
            worksheet["A6"].Value = "Clear Cell Comments Only:";

            // Specify initial content and formatting for cells.
            CellRange sourceCells = worksheet["B2:D6"];
            sourceCells.Value = DateTime.Now;
            sourceCells.Style = workbook.Styles[BuiltInStyleId.Accent3_40percent];
            sourceCells.Font.Color = Color.LightSeaGreen;
            sourceCells.Font.Bold = true;
            sourceCells.Borders.SetAllBorders(Color.Blue, BorderLineStyle.Dashed);
            worksheet.Hyperlinks.Add(worksheet["B5"], "http://www.devexpress.com/", true, "DevExpress");
            worksheet.Hyperlinks.Add(worksheet["C5"], "http://www.devexpress.com/", true, "DevExpress");
            worksheet.Hyperlinks.Add(worksheet["D5"], "http://www.devexpress.com/", true, "DevExpress");
            worksheet.Comments.Add(worksheet["B6"], "Me", "Cell Comment");
            worksheet.Comments.Add(worksheet["C6"], "Me", "Cell Comment");
            worksheet.Comments.Add(worksheet["D6"], "Me", "Cell Comment");

            #region #ClearCell
            // Remove all cell information (content, formatting, hyperlinks and comments).
            worksheet.Clear(worksheet["C2:D2"]);

            // Remove cell content.
            worksheet.ClearContents(worksheet["C3"]);
            worksheet["D3"].Value = null;

            // Remove cell formatting.
            worksheet.ClearFormats(worksheet["C4"]);
            worksheet["D4"].Style = workbook.Styles.DefaultStyle;

            // Remove hyperlinks from cells.
            worksheet.ClearHyperlinks(worksheet["C5"]);

            Hyperlink hyperlinkD5 = worksheet.Hyperlinks.GetHyperlinks(worksheet["D5"])[0];
            worksheet.Hyperlinks.Remove(hyperlinkD5);

            // Remove comments from cells.
            worksheet.ClearComments(worksheet["C6"]);

            Comment commentD6 = worksheet.Comments.GetComments(worksheet["D6"])[0];
            worksheet.Comments.Remove(commentD6);
            #endregion #ClearCell
        }
    }
}
SpreadsheetExamples/SpreadsheetActions/DocumentPropertiesActions.cs(vb) 
C#
using DevExpress.Spreadsheet;
using System;
using System.Collections.Generic;
using System.Drawing;

namespace SpreadsheetExamples {
    class DocumentPropertiesActions {
        #region DocumentProperties
        public static Action<IWorkbook> BuiltInPropertiesAction = BuiltInPropertiesValue;
        public static Action<IWorkbook> CustomPropertiesAction = CustomPropertiesValue;
        #endregion

        static void BuiltInPropertiesValue(IWorkbook workbook)
        {
            workbook.BeginUpdate();
            try
            {
                Worksheet worksheet = workbook.Worksheets[0];
                worksheet.Columns[0].WidthInCharacters = 2;
                worksheet["E6"].Value = "Mike Hamilton";

                CellRange header = worksheet.Range["B2:C2"];
                header[0].Value = "Property Name";
                header[1].Value = "Value";
                header.Style = workbook.Styles[BuiltInStyleId.Accent2];

                #region #Built-inProperties
                // Set the built-in document properties.
                workbook.DocumentProperties.Title = "Spreadsheet API: document properties example";
                workbook.DocumentProperties.Description = "How to manage document properties using the Spreadsheet API";
                workbook.DocumentProperties.Keywords = "Spreadsheet, API, properties, OLEProps";
                workbook.DocumentProperties.Company = "Developer Express Inc.";

                // Display the specified built-in properties in a worksheet.
                worksheet["B3"].Value = "Title";
                worksheet["C3"].Value = workbook.DocumentProperties.Title;
                worksheet["B4"].Value = "Description";
                worksheet["C4"].Value = workbook.DocumentProperties.Description;
                worksheet["B5"].Value = "Keywords";
                worksheet["C5"].Value = workbook.DocumentProperties.Keywords;
                worksheet["B6"].Value = "Company";
                worksheet["C6"].Value = workbook.DocumentProperties.Company;
                #endregion #Built-inProperties

                worksheet.Columns.AutoFit(1, 2);
            }
            finally { workbook.EndUpdate(); }
        }

        static void CustomPropertiesValue(IWorkbook workbook)
        {
            workbook.BeginUpdate();
            try
            {
                Worksheet worksheet = workbook.Worksheets[0];
                worksheet.Columns[0].WidthInCharacters = 2;

                CellRange header = worksheet.Range["B2:C2"];
                header[0].Value = "Property Name";
                header[1].Value = "Value";
                header.Style = workbook.Styles[BuiltInStyleId.Accent2];
                header.ColumnWidthInCharacters = 20;

                #region #CustomProperties
                // Set the custom document properties.
                workbook.DocumentProperties.Custom["Revision"] = 3;
                workbook.DocumentProperties.Custom["Completed"] = true;
                workbook.DocumentProperties.Custom["Published"] = DateTime.Now;
                #endregion #CustomProperties

                #region #LinkToContent
                // Define a name to the cell linked to the custom property.
                workbook.DefinedNames.Add("checked_by", "E6");

                // Connect the custom property with the named cell.
                workbook.DocumentProperties.Custom.LinkToContent("Checked by", "checked_by");
                #endregion #LinkToContent

                #region #DisplayCustomProperties
                // Display the specified custom properties in a worksheet.
                IEnumerable<string> customPropertiesNames = workbook.DocumentProperties.Custom.Names;
                int rowIndex = 2;
                foreach (string propertyName in customPropertiesNames)
                {
                    worksheet[rowIndex, 1].Value = propertyName;
                    worksheet[rowIndex, 2].Value = workbook.DocumentProperties.Custom[propertyName];
                    if (worksheet[rowIndex, 2].Value.IsDateTime)
                        worksheet[rowIndex, 2].NumberFormat = "[$-409]m/d/yyyy h:mm AM/PM";
                    rowIndex++;
                }
                #endregion #DisplayCustomProperties

                #region #RemoveCustomProperty
                // Remove an individual custom document property.
                workbook.DocumentProperties.Custom["Published"] = null;
                #endregion #RemoveCustomProperty

                #region #ClearCustomProperties
                // Remove all custom document properties.
                workbook.DocumentProperties.Custom.Clear();
                #endregion #ClearCustomProperties
            }
            finally { workbook.EndUpdate(); }
        }
    }
}
SpreadsheetExamples/SpreadsheetActions/ExportActions.cs(vb) 
C#
using System;
using System.IO;
using System.Data;
using System.Drawing;
using System.Diagnostics;
using System.Collections.Generic;
using DevExpress.Spreadsheet;

namespace SpreadsheetExamples
{
    public static class ExportActions
    {
        #region Actions
        public static Action<Workbook> ExportToPdfAction = ExportToPdf;
        #endregion

        static void ExportToPdf(Workbook workbook)
        {
            workbook.Worksheets[0].Cells["D8"].Value = "This document is exported to the PDF format.";

            #region #ExportToPdf
            // Export the workbook to PDF.
            using (FileStream pdfFileStream = new FileStream("Documents\\Document_PDF.pdf", FileMode.Create))
            {
                workbook.ExportToPdf(pdfFileStream);
            }
            #endregion #ExportToPdf
            var p = new Process();
            p.StartInfo = new ProcessStartInfo(@"Documents\Document_PDF.pdf")
            {
                UseShellExecute = true
            };
            p.Start();
        }
    }
}
SpreadsheetExamples/SpreadsheetActions/FormattingActions.cs(vb) 
C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DevExpress.Spreadsheet;
using System.Drawing;

namespace SpreadsheetExamples {
    public static class FormattingActions {
        #region Actions
        public static Action<Workbook> ApplyStyleAction = ApplyStyle;
        public static Action<Workbook> CreateModifyStyleAction = CreateModifyStyle;
        public static Action<Workbook> FormatCellAction = FormatCell;
        public static Action<Workbook> SetDateFormatsAction = SetDateFormats;
        public static Action<Workbook> SetNumberFormatsAction = SetNumberFormats;
        public static Action<Workbook> ChangeCellColorsAction = ChangeCellColors;
        public static Action<Workbook> SpecifyCellFontAction = SpecifyCellFont;
        public static Action<Workbook> AlignCellContentsAction = AlignCellContents;
        public static Action<Workbook> AddCellBordersAction = AddCellBorders;
        #endregion

        static void ApplyStyle(Workbook workbook) {
            #region #ApplyCellStyle
            Worksheet worksheet = workbook.Worksheets[0];

            // Access the built-in "Good" MS Excel style from the Styles collection of the workbook.
            Style styleGood = workbook.Styles[BuiltInStyleId.Good];

            // Apply the "Good" style to a cell range.
            worksheet.Range["A1:C4"].Style = styleGood;

            // Access the previously created custom style by its name.
            Style customStyle = workbook.Styles["Custom Style"];

            // Apply the custom style to the cell.
            worksheet.Cells["D6"].Style = customStyle;

            // Apply the "Good" style to the eighth row.
            worksheet.Rows[7].Style = styleGood;

            // Apply the custom style to the "H" column.
            worksheet.Columns["H"].Style = customStyle;
            #endregion #ApplyCellStyle
        }

        static void CreateModifyStyle(Workbook workbook) {
            #region #CreateNewStyle
            // Add a new style under the "My Style" name to the workbook's style collection.
            Style myStyle = workbook.Styles.Add("My Style");

            // Specify formatting characteristics for the style.
            myStyle.BeginUpdate();
            try {
                // Specify the font color.
                myStyle.Font.Color = Color.Blue;

                // Specify the font size.
                myStyle.Font.Size = 12;

                // Specify the horizontal alignment.
                myStyle.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

                // Set the background.
                myStyle.Fill.BackgroundColor = Color.LightBlue;
                myStyle.Fill.PatternType = PatternType.LightGray;
                myStyle.Fill.PatternColor = Color.Yellow;
            } 
            finally {
                myStyle.EndUpdate();
            }
            #endregion #CreateNewStyle

            #region #DuplicateExistingStyle
            // Add a new style under the "My Good Style" name to the workbook's style collection.
            Style myGoodStyle = workbook.Styles.Add("My Good Style");

            // Copy all format settings from the built-in Good style.
            myGoodStyle.CopyFrom(BuiltInStyleId.Good);

            // Modify the required formatting characteristics if needed.
            // ...
            #endregion #DuplicateExistingStyle

            #region #ModifyExistingStyle
            // Access the style to be modified.
            Style customStyle = workbook.Styles["Custom Style"];

            // Change the required formatting characteristics of the style.
            customStyle.BeginUpdate();
            try {
                customStyle.Fill.BackgroundColor = Color.Gold;
                // ...
            } finally {
                customStyle.EndUpdate();
            }
            #endregion #ModifyExistingStyle
        }

        static void FormatCell(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Cells["B2"].Value = "Test";
            worksheet.Range["C3:E6"].Value = "Test";

            #region #CellFormatting
            // Access the "B2" cell.
            Cell cell = worksheet.Cells["B2"];

            // Specify font settings (font name, color, size and style).
            cell.Font.Name = "MV Boli";
            cell.Font.Color = Color.Blue;
            cell.Font.Size = 14;
            cell.Font.FontStyle = SpreadsheetFontStyle.Bold;

            // Specify the cell background color.
            cell.Fill.BackgroundColor = Color.LightSkyBlue;

            // Specify text alignment. 
            cell.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
            cell.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            #endregion #CellFormatting

            #region #RangeFormatting
            // Access the "C3:E6" cell range.
            CellRange range = worksheet.Range["C3:E6"];

            // Start to update the cell range formatting. 
            Formatting rangeFormatting = range.BeginUpdateFormatting();

            // Specify font settings (font name, color, size and style).
            rangeFormatting.Font.Name = "MV Boli";
            rangeFormatting.Font.Color = Color.Blue;
            rangeFormatting.Font.Size = 14;
            rangeFormatting.Font.FontStyle = SpreadsheetFontStyle.Bold;

            // Specify the cell background color.
            rangeFormatting.Fill.BackgroundColor = Color.LightSkyBlue;

            // Specify text alignment.
            rangeFormatting.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
            rangeFormatting.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

            // Finalize to update the cell range formatting.
            range.EndUpdateFormatting(rangeFormatting);
            #endregion #RangeFormatting
        }


        static void SetDateFormats(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];
            
            worksheet.Range["A1:F1"].ColumnWidthInCharacters = 15;
            worksheet.Range["A1:F1"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

            #region #DateTimeFormats
            worksheet.Range["A1:F1"].Formula = "= Now()";

            // Apply different date display formats.
            worksheet.Cells["A1"].NumberFormat = "m/d/yy";

            worksheet.Cells["B1"].NumberFormat = "d-mmm-yy";

            worksheet.Cells["C1"].NumberFormat = "dddd";

            // Apply different time display formats.
            worksheet.Cells["D1"].NumberFormat = "m/d/yy h:mm";

            worksheet.Cells["E1"].NumberFormat = "h:mm AM/PM";

            worksheet.Cells["F1"].NumberFormat = "h:mm:ss";

            #endregion #DateTimeFormats
        }

        static void SetNumberFormats(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Range["A1:H1"].ColumnWidthInCharacters = 12;
            worksheet.Range["A1:H1"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

            #region #NumberFormats
            // Display 111 as 111.
            worksheet.Cells["A1"].Value = 111;
            worksheet.Cells["A1"].NumberFormat = "#####";

            // Display 222 as 00222.
            worksheet.Cells["B1"].Value = 222;
            worksheet.Cells["B1"].NumberFormat = "00000";

            // Display 12345678 as 12,345,678.
            worksheet.Cells["C1"].Value = 12345678;
            worksheet.Cells["C1"].NumberFormat = "#,#";

            // Display .126 as 0.13.
            worksheet.Cells["D1"].Value = .126;
            worksheet.Cells["D1"].NumberFormat = "0.##";

            // Display 74.4 as 74.400.
            worksheet.Cells["E1"].Value = 74.4;
            worksheet.Cells["E1"].NumberFormat = "##.000";

            // Display 1.6 as 160.0%.
            worksheet.Cells["F1"].Value = 1.6;
            worksheet.Cells["F1"].NumberFormat = "0.0%";

            // Display 4321 as $4,321.00.
            worksheet.Cells["G1"].Value = 4321;
            worksheet.Cells["G1"].NumberFormat = "$#,##0.00";

            // Display 8.75 as 8 3/4.
            worksheet.Cells["H1"].Value = 8.75;
            worksheet.Cells["H1"].NumberFormat = "# ?/?";
            #endregion #NumberFormats
        }

        static void ChangeCellColors(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Range["C3:D4"].Merge();
            worksheet.Range["C3:D4"].Value = "Test";
            worksheet.Cells["A1"].Value = "Test";

            #region #ColorCells
            // Format an individual cell.
            worksheet.Cells["A1"].Font.Color = Color.Red;
            worksheet.Cells["A1"].FillColor = Color.Yellow;

            // Format a cell range.
            CellRange range = worksheet.Range["C3:D4"];
            Formatting rangeFormatting = range.BeginUpdateFormatting();
            rangeFormatting.Font.Color = Color.Blue;
            rangeFormatting.Fill.BackgroundColor = Color.LightBlue;
            rangeFormatting.Fill.PatternType = PatternType.LightHorizontal;
            rangeFormatting.Fill.PatternColor = Color.Violet;
            range.EndUpdateFormatting(rangeFormatting);
            #endregion #ColorCells
        }

        static void SpecifyCellFont(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Cells["A1"].Value = "Font Attributes";
            worksheet.Cells["A1"].ColumnWidthInCharacters = 20;

            #region #FontSettings
            // Access the Font object.
            SpreadsheetFont cellFont = worksheet.Cells["A1"].Font;
            // Specify the font name.
            cellFont.Name = "Times New Roman";
            // Specify the font size.
            cellFont.Size = 14;
            // Specify the font color.
            cellFont.Color = Color.Blue;
            // Format text as bold.
            cellFont.Bold = true;
            // Specify the font underline type.
            cellFont.UnderlineType = UnderlineType.Double;
            #endregion #FontSettings
        }

        static void AlignCellContents(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];

            CellRange range = worksheet.Range["A1:B3"];
            range.ColumnWidthInCharacters = 30;
            range.RowHeight = 200;

            #region #AlignCellContents
            // Align the "A1" cell content.
            Cell cellA1 = worksheet.Cells["A1"];
            cellA1.Value = "Right and top";
            cellA1.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Right;
            cellA1.Alignment.Vertical = SpreadsheetVerticalAlignment.Top;

            // Align the "A2" cell content.
            Cell cellA2 = worksheet.Cells["A2"];
            cellA2.Value = "Center";
            cellA2.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            cellA2.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;

            // Align the "A3" cell content.
            Cell cellA3 = worksheet.Cells["A3"];
            cellA3.Value = "Left and bottom, indent";
            cellA3.Alignment.Indent = 1;

            // Align the "B1" cell content.
            Cell cellB1 = worksheet.Cells["B1"];
            cellB1.Value = "The Alignment.ShrinkToFit property is applied";
            cellB1.Alignment.ShrinkToFit = true;

            // Align the "B2" cell content.
            Cell cellB2 = worksheet.Cells["B2"];
            cellB2.Value = "Rotated Cell Contents";
            cellB2.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            cellB2.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
            cellB2.Alignment.RotationAngle = 15;

            // Align the "B3" cell content.
            Cell cellB3 = worksheet.Cells["B3"];
            cellB3.Value = "The Alignment.WrapText property is applied to wrap the text within a cell";
            cellB3.Alignment.WrapText = true;
            #endregion #AlignCellContents
        }

        static void AddCellBorders(Workbook workbook) {
            #region #CellBorders
            Worksheet worksheet = workbook.Worksheets[0];

            // Specify borders for the "B2" cell.
            Cell cellB2 = worksheet.Cells["B2"];
            Borders cellB2Borders = cellB2.Borders;
            cellB2Borders.LeftBorder.LineStyle = BorderLineStyle.MediumDashDot;
            cellB2Borders.LeftBorder.Color = Color.Pink;
            cellB2Borders.TopBorder.LineStyle = BorderLineStyle.MediumDashDotDot;
            cellB2Borders.TopBorder.Color = Color.HotPink;
            cellB2Borders.RightBorder.LineStyle = BorderLineStyle.MediumDashed;
            cellB2Borders.RightBorder.Color = Color.DeepPink;
            cellB2Borders.BottomBorder.LineStyle = BorderLineStyle.Medium;
            cellB2Borders.BottomBorder.Color = Color.Red;
            cellB2Borders.DiagonalBorderType = DiagonalBorderType.Up;
            cellB2Borders.DiagonalBorderLineStyle = BorderLineStyle.Thick;
            cellB2Borders.DiagonalBorderColor = Color.Red;

            // Specify diagonal borders for the "C4" cell.
            Cell cellC4 = worksheet.Cells["C4"];
            Borders cellC4Borders = cellC4.Borders;
            cellC4Borders.SetDiagonalBorders(Color.Orange, BorderLineStyle.Double, DiagonalBorderType.UpAndDown);

            // Specify outside borders for the "D6" cell. 
            Cell cellD6 = worksheet.Cells["D6"];
            cellD6.Borders.SetOutsideBorders(Color.Gold, BorderLineStyle.Double);
            #endregion #CellBorders

            #region #CellRangeBorders
            // Specify all borders for the "B8:F13" cell range.
            CellRange range1 = worksheet.Range["B8:F13"];
            range1.Borders.SetAllBorders(Color.Green, BorderLineStyle.Double);

            // Specify inside and outside borders for the "C15:F18" cell range.
            CellRange range2 = worksheet.Range["C15:F18"];
            range2.SetInsideBorders(Color.SkyBlue, BorderLineStyle.MediumDashed);
            range2.Borders.SetOutsideBorders(Color.DeepSkyBlue, BorderLineStyle.Medium);

            // Specify horizontal and vertical borders for the "D21:F23" cell range.
            CellRange range3 = worksheet.Range["D21:F23"];
            Formatting range3Formatting = range3.BeginUpdateFormatting();
            Borders range3Borders = range3Formatting.Borders;
            range3Borders.InsideHorizontalBorders.LineStyle = BorderLineStyle.MediumDashDot;
            range3Borders.InsideHorizontalBorders.Color = Color.DarkBlue;
            range3Borders.InsideVerticalBorders.LineStyle = BorderLineStyle.MediumDashDotDot;
            range3Borders.InsideVerticalBorders.Color = Color.Blue;
            range3.EndUpdateFormatting(range3Formatting);

            // Specify borders for the "E25:F26" cell range. 
            CellRange range4 = worksheet.Range["E25:F26"];
            Formatting range4Formatting = range4.BeginUpdateFormatting();
            Borders range4Borders = range4Formatting.Borders;
            range4Borders.SetOutsideBorders(Color.Black, BorderLineStyle.Thick);
            range4Borders.LeftBorder.Color = Color.Violet;
            range4Borders.TopBorder.Color = Color.Violet;
            range4Borders.RightBorder.Color = Color.DarkViolet;
            range4Borders.BottomBorder.Color = Color.DarkViolet;
            range4Borders.DiagonalBorderType = DiagonalBorderType.UpAndDown;
            range4Borders.DiagonalBorderLineStyle = BorderLineStyle.MediumDashed;
            range4Borders.DiagonalBorderColor = Color.BlueViolet;
            range4.EndUpdateFormatting(range4Formatting);
            #endregion #CellRangeBorders
        }
    }
}
SpreadsheetExamples/SpreadsheetActions/FormulaActions.cs(vb) 
C#
using DevExpress.Spreadsheet;
using System;
using System.Drawing;

namespace SpreadsheetExamples
{
    public static class FormulaActions
    {

        #region Actions
        public static Action<Workbook> UseConstantsAndCalculationOperatorsInFormulasAction = UseConstantsAndCalculationOperatorsInFormulas;
        public static Action<Workbook> R1C1ReferencesInFormulassAction = R1C1ReferencesInFormulas;
        public static Action<Workbook> UseNamesInFormulasAction = UseNamesInFormulas;
        public static Action<Workbook> CreateNamedFormulasAction = CreateNamedFormulas;
        public static Action<Workbook> UseFunctionsInFormulasAction = UseFunctionsInFormulas;
        public static Action<Workbook> CreateSharedAndArrayFormulasAction = CreateSharedAndArrayFormulas;
        public static Action<Workbook> CreateDynamicArrayFormulasAction = CreateDynamicArrayFormulas;
        #endregion

        static void UseConstantsAndCalculationOperatorsInFormulas(Workbook workbook)
        {
            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Cells["A1"].Value = "Formula";
            worksheet.Cells["B1"].Value = "Value";
            worksheet.Range["A1:B1"].FillColor = Color.LightGray;
            worksheet.Cells["A2"].Value = "'= (1+5)*6";

            #region #ConstantsAndCalculationOperators
            // Use constants and calculation operators in a formula.
            workbook.Worksheets[0].Cells["B2"].Formula = "= (1+5)*6";
            #endregion #ConstantsAndCalculationOperators
        }

        static void R1C1ReferencesInFormulas(Workbook workbook)
        {
            Worksheet worksheet = workbook.Worksheets[0];

            // Fill cells with static data.
            worksheet.Cells["A1"].Value = "Data";
            worksheet.Range["A2:A11"].Formula = "=ROW() - 1";

            worksheet.Cells["B1"].Value = "Cell Reference Style";
            worksheet.Cells["B2"].Value = "Relative R1C1 Cell Reference";
            worksheet.Cells["B3"].Value = "Absolute R1C1 Cell Reference";

            worksheet.Cells["C1"].Value = "Formula";
            worksheet.Cells["C2"].Value = "'=SUM(RC[-3]:R[9]C[-3])";
            worksheet.Cells["C3"].Value = "'=SUM(R2C1:R11C1)";

            worksheet.Cells["D1"].Value = "Value";

            worksheet.Range["A1:D1"].AutoFitColumns();
            worksheet.Range["A1:D1"].FillColor = Color.LightGray;
            worksheet.Range["A1:D11"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

            #region #R1C1ReferencesInFormulas
            // Switch on the R1C1 reference style in a workbook.
            workbook.DocumentSettings.R1C1ReferenceStyle = true;

            // Specify a formula with relative R1C1 references in the "D2" cell
            // to add values contained in cells "A2" through "A11".
            worksheet.Cells["D2"].Formula = "=SUM(RC[-3]:R[9]C[-3])";

            // Specify a formula with absolute R1C1 references 
            // to add values contained in cells "A2" through "A11".
            worksheet.Cells["D3"].Formula = "=SUM(R2C1:R11C1)";

            #endregion #R1C1ReferencesInFormulas
        }

        static void UseNamesInFormulas(Workbook workbook)
        {
            Worksheet worksheet = workbook.Worksheets[0];

            CellRange dataRangeHeader = worksheet.Range["A1:C1"];
            worksheet.MergeCells(dataRangeHeader);
            dataRangeHeader.Value = "myRange:";
            dataRangeHeader.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            dataRangeHeader.FillColor = Color.LightGray;

            worksheet.Range["A2:C5"].Value = 2;
            worksheet.Range["A2:C5"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            worksheet.Range["A2:C5"].Borders.SetOutsideBorders(Color.LightBlue, BorderLineStyle.Medium);

            CellRange sumHeader = worksheet.Range["E1:F1"];
            worksheet.MergeCells(sumHeader);
            sumHeader.Value = "Sum:";
            sumHeader.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            sumHeader.FillColor = Color.LightGray;

            worksheet.Range["E2:F2"].ColumnWidthInCharacters = 15;
            worksheet.Cells["E2"].Value = "Formula:";
            worksheet.Cells["E3"].Value = "Value:";
            worksheet.Cells["F2"].Value = "'= SUM(myRange)";

            #region #NamesInFormulas
            // Access the "A2:C5" cell range.
            CellRange range = worksheet.Range["A2:C5"];

            // Specify the created range name.
            range.Name = "myRange";

            // Create a formula that sums up the values of all cells included in the specified range.
            worksheet.Cells["F3"].Formula = "= SUM(myRange)";
            #endregion #NamesInFormulas
        }

        static void CreateNamedFormulas(Workbook workbook)
        {
            workbook.Worksheets[0].Cells["A1"].Value = 2;
            workbook.Worksheets[0].Cells["B2"].Value = 3;
            workbook.Worksheets[0].Cells["C3"].Value = 4;

            workbook.Worksheets[1].Range["A1:C1"].FillColor = Color.LightGray;
            workbook.Worksheets[1].Range["A1:C1"].ColumnWidthInCharacters = 25;

            workbook.Worksheets[1].Cells["A1"].Value = "Formula Name";
            workbook.Worksheets[1].Cells["B1"].Value = "Formula";
            workbook.Worksheets[1].Cells["C1"].Value = "Formula Result";

            workbook.Worksheets[1].Cells["A2"].Value = "Range_Sum";
            workbook.Worksheets[1].Cells["A3"].Value = "Range_DoubleSum";
            workbook.Worksheets[1].Cells["A4"].Value = "-";

            workbook.Worksheets[1].Cells["B2"].Value = "'=SUM(Sheet1!$A$1:$C$3)";
            workbook.Worksheets[1].Cells["B3"].Value = "'=2*Sheet1!Range_Sum";
            workbook.Worksheets[1].Cells["B4"].Value = "'=Range_DoubleSum + 100";

            #region #NamedFormulas
            Worksheet worksheet1 = workbook.Worksheets["Sheet1"];
            Worksheet worksheet2 = workbook.Worksheets["Sheet2"];

            // Create a name for a formula that sums up the values of all cells
            // included in the "A1:C3" range of the "Sheet1" worksheet. 
            // The scope of this name is the "Sheet1" worksheet.
            worksheet1.DefinedNames.Add("Range_Sum", "=SUM(Sheet1!$A$1:$C$3)");

            // Create a name for a formula that doubles the value resulting
            // from the "Range_Sum" named formula.
            // The scope of this name is the entire workbook.
            workbook.DefinedNames.Add("Range_DoubleSum", "=2*Sheet1!Range_Sum");

            // Create formulas that use other formulas with the specified names.
            worksheet2.Cells["C2"].Formula = "=Sheet1!Range_Sum";
            worksheet2.Cells["C3"].Formula = "=Range_DoubleSum";
            worksheet2.Cells["C4"].Formula = "=Range_DoubleSum + 100";
            #endregion #NamedFormulas

            workbook.Worksheets.ActiveWorksheet = workbook.Worksheets["Sheet2"];
        }

        static void UseFunctionsInFormulas(Workbook workbook)
        {
            Worksheet worksheet = workbook.Worksheets[0];
            // Fill cells with static data.
            worksheet.Cells["A1"].Value = "Data";
            worksheet.Cells["A2"].Value = 15;
            worksheet.Range["A3:A5"].Value = 3;
            worksheet.Cells["A6"].Value = 20;
            worksheet.Cells["A7"].Value = 15.12345;

            worksheet.Cells["B1"].ColumnWidthInCharacters = 30;
            worksheet.Cells["B1"].Value = "Formula String";
            worksheet.Cells["B2"].Value = @"'=IF(A2<10, ""Normal"", ""Excess"")";
            worksheet.Cells["B3"].Value = "'=AVERAGE(A2:A7)";
            worksheet.Cells["B4"].Value = "'=SUM(A3:A5,A6,100)";
            worksheet.Cells["B5"].Value = "'=ROUND(SUM(A6,A7),2)";
            worksheet.Cells["B6"].Value = "'=Today()";
            worksheet.Cells["B7"].Value = @"'=UPPER(""formula"")";

            worksheet.Cells["C1"].Value = "Formula";

            worksheet.Range["A1:C1"].FillColor = Color.LightGray;
            worksheet.Range["A1:C7"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Left;

            #region #FunctionsInFormulas
            // If the number in the "A2" cell is less than 10, the formula returns "Normal" 
            // and the "C2" cell displays this text. Otherwise, the "C2" cell displays "Excess".
            worksheet.Cells["C2"].Formula = @"=IF(A2<10, ""Normal"", ""Excess"")";

            // Calculate the average value for cell values within the "A2:A7" range.
            worksheet.Cells["C3"].Formula = "=AVERAGE(A2:A7)";

            // Add values contained in the "A3:A5" cell range, add the "A6" cell value, 
            // and add 100 to that result.
            worksheet.Cells["C4"].Formula = "=SUM(A3:A5,A6,100)";

            // Use a nested function in a formula.
            // Round the sum of the values contained in the "A6" and "A7" cells to two decimal places.
            worksheet.Cells["C5"].Formula = "=ROUND(SUM(A6,A7),2)";

            // Add the current date to the "C6" cell.
            worksheet.Cells["C6"].Formula = "=Today()";
            worksheet.Cells["C6"].NumberFormat = "m/d/yy";

            // Convert the specified text to uppercase.
            worksheet.Cells["C7"].Formula = @"=UPPER(""formula"")";
            #endregion #FunctionsInFormulas
        }

        static void CreateSharedAndArrayFormulas(Workbook workbook)
        {
            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Range["A1:D1"].ColumnWidthInCharacters = 10;
            worksheet.Range["A1:D1"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            worksheet.Range["A1:D1"].FillColor = Color.LightGray;

            worksheet.MergeCells(worksheet.Range["A1:B1"]);
            worksheet.Range["A1:B1"].Value = "Use Shared Formulas:";

            worksheet.MergeCells(worksheet.Range["C1:D1"]);
            worksheet.Range["C1:D1"].Value = "Use Array Formulas:";

            #region #SharedFormulas
            worksheet.Cells["A2"].Value = 1;

            // Use the shared formula in the "A3:A11" cell range.
            worksheet.Range["A3:A11"].Formula = "=SUM(A2+1)";

            // Use the shared formula in the "B2:B11" cell range.
            worksheet.Range["B2:B11"].Formula = "=A2+2";
            #endregion #SharedFormulas

            #region #ArrayFormulas
            // Create an array formula that multiplies values of the "A2:A11" cell range
            // by values of the "B2:B11" cell range, 
            // and displays the results in the "C2:C11" cell range.
            worksheet.Range["C2:C11"].ArrayFormula = "=A2:A11*B2:B11";

            // Create an array formula that multiplies values of the "C2:C11" cell range by 2
            // and displays the results in the "D2:D11" cell range.
            worksheet.Range["D2:D11"].ArrayFormula = "=C2:C11*2";

            // Create an array formula that multiplies values of the "B2:D11" cell range, 
            // adds the results, and displays the total sum in "D12" cell.
            worksheet.Cells["D12"].ArrayFormula = "=SUM(B2:B11*C2:C11*D2:D11)";

            // Re-dimension an array formula range:
            // delete the array formula and create a new range with the same formula.
            if (worksheet.Cells["C13"].HasArrayFormula)
            {
                string af = worksheet.Cells["C13"].ArrayFormula;
                worksheet.Cells["C13"].GetArrayFormulaRange().ArrayFormula = string.Empty;
                worksheet.Range["C2:C11"].ArrayFormula = af;
            }
            #endregion #ArrayFormulas
        }

        static void CreateDynamicArrayFormulas(Workbook workbook)
        {
            #region #DynamicArrayFormulas
            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Range["A1"].ColumnWidthInCharacters = 20;
            worksheet.Range["A1"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            worksheet.Range["A1"].FillColor = Color.LightGray;

            worksheet.Range["A1"].Value = "Dynamic Array Formulas:";


            // Insert dynamic array formulas
            worksheet["A2"].DynamicArrayFormulaInvariant = "={\"Red\",\"Green\",\"Orange\",\"Blue\"}";
            worksheet.DynamicArrayFormulas.Add(worksheet["B1"], "=LEN(A2:D2)");
            #endregion #DynamicArrayFormulas
        }
    }
}
SpreadsheetExamples/SpreadsheetActions/ImportActions.cs(vb) 
C#
using System;
using System.IO;
using System.Data;
using System.Drawing;
using System.Diagnostics;
using System.Collections.Generic;
using DevExpress.Spreadsheet;

namespace SpreadsheetExamples {
    public static class ImportActions {
        #region Actions
        public static Action<Workbook> ImportArraysAction = ImportArrays;
        public static Action<Workbook> ImportListAction = ImportList;
        public static Action<Workbook> ImportDataTableAction = ImportDataTable;
        public static Action<Workbook> ImportArrayWithFormulasAction = ImportArrayWithFormulas;
        public static Action<Workbook> ImportCustomObjectSpecifiedFieldsAction = ImportCustomObjectSpecifiedFields;
        public static Action<Workbook> ImportCustomObjectUsingCustomConverterAction = ImportCustomObjectUsingCustomConverter;
        
        #endregion

        static void ImportArrays(Workbook workbook) {
            workbook.Worksheets[0].Cells["A1"].ColumnWidthInCharacters = 35;
            workbook.Worksheets[0].Cells["A1"].Value = "Import an array horizontally:";
            workbook.Worksheets[0].Cells["A3"].Value = "Import a two-dimensional array:";

            #region #ImportArray
            Worksheet worksheet = workbook.Worksheets[0];
            // Create an array of strings.
            string[] array = new string[] { "AAA", "BBB", "CCC", "DDD" };
            // Insert array values into the worksheet horizontally.
            // Data import starts with the "B1" cell.
            worksheet.Import(array, 0, 1, false);
            #endregion #ImportArray

            #region #ImportTwoDimensionalArray
            // Create a two-dimensional array of strings.
            String[,] names = new String[2, 4]{
            {"Ann", "Edward", "Angela", "Alex"},
            {"Rachel", "Bruce", "Barbara", "George"}
            };
            // Insert array values into the worksheet.
            // Data import starts with the "B3" cell.
            worksheet.Import(names, 2, 1);
            #endregion #ImportTwoDimensionalArray
        }
        
        static void ImportList(Workbook workbook) {  
            #region #ImportList  
            Worksheet worksheet = workbook.Worksheets[0];
            // Create a list that contains string values.
            List<string> cities = new List<string>();
            cities.Add("New York");
            cities.Add("Rome");
            cities.Add("Beijing");
            cities.Add("Delhi");
            // Insert list values into the worksheet vertically.
            // Data import starts with the "A1" cell.
            worksheet.Import(cities, 0, 0, true);
            #endregion #ImportList
        }

        static void ImportDataTable(Workbook workbook)
        {  
            #region #ImportDataTable
            Worksheet worksheet = workbook.Worksheets[0];
            // Create an "Employees" DataTable object with four columns.
            DataTable table = new DataTable("Employees");
            table.Columns.Add("FirstN", typeof(string));
            table.Columns.Add("LastN", typeof(string));
            table.Columns.Add("JobTitle", typeof(string));
            table.Columns.Add("Age", typeof(Int32));

            table.Rows.Add("Nancy", "Davolio", "recruiter", 32);
            table.Rows.Add("Andrew", "Fuller", "engineer", 28);

            // Insert data table values into the worksheet.
            // Data import starts with the "A1" cell.
            worksheet.Import(table, true, 0, 0);

            // Color the table header.
            for (int i = 1; i < 5; i++) {
                worksheet.Cells[10, i].FillColor = Color.LightGray;
            }
            #endregion #ImportDataTable
        }
        
        static void ImportArrayWithFormulas(Workbook workbook)
        {
            #region  #ImportArrayWithFormulas
            Worksheet worksheet = workbook.Worksheets[0];
                
                string[] array = new string[] { "000", "=3,141", "=B1+1,01" };
                // Import data as formulas in German locale (decimal and list separators).
                worksheet.Import(array, 0, 0, false, new DataImportOptions() { ImportFormulas = true, 
                    FormulaCulture = new System.Globalization.CultureInfo("de-DE") });
                
                string[] arrayR1C1 = new string[] { "=3.141", "=R[-1]C+1.01" };
                // Import data as formulas that use the R1C1 reference style.
                worksheet.Import(arrayR1C1, 1, 0, true, new DataImportOptions() { ImportFormulas = true, ReferenceStyle= ReferenceStyle.R1C1});
            #endregion  #ImportArrayWithFormulas
        }
        
        #region #ImportCustomObjectSpecifiedFields
        class MyDataObject
        {
            public MyDataObject(int intValue, string value, bool boolValue)
            {
                this.myInteger = intValue;
                this.myString = value;
                this.myBoolean = boolValue;
                
            }
                public int myInteger { get; set; }
                public string myString { get; set; }
                public bool myBoolean { get; set; }
            }

        static void ImportCustomObjectSpecifiedFields(Workbook workbook)
        {
            Worksheet worksheet = workbook.Worksheets[0];
            List<MyDataObject> list = new List<MyDataObject>();
            list.Add(new MyDataObject(1, "1", true));
            list.Add(new MyDataObject(2, "2", false));

            // Import values from specific data source fields.
            worksheet.Import(list, 0, 0, new DataSourceImportOptions() { PropertyNames = new string[] { "myBoolean", "myInteger" } });
        }
        #endregion #ImportCustomObjectSpecifiedFields

        #region #ImportCustomObjectUsingCustomConverter
        // A custom converter that converts the first column's integer values to text.
        class MyDataValueConverter : IDataValueConverter
        {
            public bool TryConvert(object value, int columnIndex, out CellValue result)
            {
                if (columnIndex == 0)
                {
                    result = DevExpress.Docs.Text.NumberInWords.Ordinal.ConvertToText((int)value);
                    return true;
                }
                else
                    result = CellValue.FromObject(value);
                return true;
            }
        }

        static void ImportCustomObjectUsingCustomConverter(Workbook workbook)
        {
            Worksheet worksheet = workbook.Worksheets[0];
            List<MyDataObject> list = new List<MyDataObject>();
            list.Add(new MyDataObject(1, "one", true));
            list.Add(new MyDataObject(2, "two", false));
            // Import values from specific data source fields and converts integer values to text.
            worksheet.Import(list, 0, 0, new DataSourceImportOptions() { Converter = new MyDataValueConverter() });
        }
        #endregion #ImportCustomObjectUsingCustomConverter
    }
}
SpreadsheetExamples/SpreadsheetActions/PrintingActions.cs(vb) 
C#
using System;
using System.Drawing;
#region #printingUsings
using DevExpress.Spreadsheet;
using DevExpress.XtraPrinting;
#endregion #printingUsings

namespace SpreadsheetExamples {
    public static class PrintingActions {

        public static Action<Workbook> PrintAction = Print;

        static void Print(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];

            // Generate a simple multiplication table.
            CellRange topHeader = worksheet.Range.FromLTRB(1, 0, 20, 0);
            topHeader.Formula = "=COLUMN() - 1";
            CellRange leftCaption = worksheet.Range.FromLTRB(0, 1, 0, 20);
            leftCaption.Formula = "=ROW() - 1";
            CellRange tableRange = worksheet.Range.FromLTRB(1, 1, 20, 20);
            tableRange.Formula = "=(ROW()-1)*(COLUMN()-1)";

            

            // Format headers of the multiplication table.
            Formatting rangeFormatting = topHeader.BeginUpdateFormatting();
            rangeFormatting.Borders.BottomBorder.LineStyle = BorderLineStyle.Thin;
            rangeFormatting.Borders.BottomBorder.Color = Color.Black;
            topHeader.EndUpdateFormatting(rangeFormatting);

            rangeFormatting = leftCaption.BeginUpdateFormatting();
            rangeFormatting.Borders.RightBorder.LineStyle = BorderLineStyle.Thin;
            rangeFormatting.Borders.RightBorder.Color = Color.Black;
            leftCaption.EndUpdateFormatting(rangeFormatting);

            rangeFormatting = tableRange.BeginUpdateFormatting();
            rangeFormatting.Fill.BackgroundColor = Color.LightBlue;
            tableRange.EndUpdateFormatting(rangeFormatting);

            #region #WorksheetPrintOptions
            worksheet.ActiveView.Orientation = PageOrientation.Landscape;
            //  Display row and column headings.
            worksheet.ActiveView.ShowHeadings = true;
            worksheet.ActiveView.PaperKind = DevExpress.Drawing.Printing.DXPaperKind.A4;
            // Access an object that contains print options.
            WorksheetPrintOptions printOptions = worksheet.PrintOptions;
            //  Print in black and white.
            printOptions.BlackAndWhite = true;
            //  Do not print gridlines.
            printOptions.PrintGridlines = false;
            //  Scale the print area to fit to a page.
            printOptions.FitToPage = true;
            //  Print a dash instead of a cell error message.
            printOptions.ErrorsPrintMode = ErrorsPrintMode.Dash;
            #endregion #WorksheetPrintOptions

            #region #PrintWorkbook
            // Invoke the Print Preview dialog for the workbook.
            using (PrintingSystem printingSystem = new PrintingSystem()) {
                using (PrintableComponentLink link = new PrintableComponentLink(printingSystem)) {
                    link.Component = workbook;
                    link.CreateDocument();
                    link.ShowPreviewDialog();
                }
            }
            #endregion #PrintWorkbook
        }
    }
}
SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.cs(vb) 
C#
using System;
using DevExpress.Spreadsheet;
using System.Drawing;

namespace SpreadsheetExamples {
    public static class RowAndColumnActions {
        #region Actions
        public static Action<Workbook> InsertRowsColumnsAction = InsertRowsColumns;
        public static Action<Workbook> DeleteRowsColumnsAction = DeleteRowsColumns;
        public static Action<Workbook> CopyRowsColumnsAction = CopyRowsColumns;
        public static Action<Workbook> ShowHideRowsColumnsAction = ShowHideRowsColumns;
        public static Action<Workbook> SpecifyRowsHeightColumnsWidthAction = SpecifyRowsHeightColumnsWidth;
        public static Action<Workbook> GroupRowsColumnsAction = GroupRowsColumns;
        public static Action<Workbook> DeleteRowsBasedOnConditionAction = DeleteRowsBasedOnCondition;
        public static Action<Workbook> DeleteColumnsBasedOnConditionAction = DeleteColumnsBasedOnCondition;

        #endregion

        static void InsertRowsColumns(Workbook workbook) {
            Worksheet worksheet = workbook.Worksheets[0];

            // Populate cells with data.
            for (int i = 0; i < 10; i++) {
                worksheet.Cells[i, 0].Value = i + 1;
                worksheet.Cells[0, i].Value = i + 1;
            }
            
            #region #InsertRows
            // Insert the third row.
            worksheet.Rows["3"].Insert();

            // Insert the fifth row.
            worksheet.Rows.Insert(4);

            // Insert five rows (from row 9 to row 13).
            worksheet.Rows.Insert(8, 5);

            // Insert two rows above the "L15:M16" cell range.
            worksheet.InsertCells(worksheet.Range["L15:M16"], InsertCellsMode.EntireRow);
            #endregion #InsertRows

            #region #InsertColumns
            // Insert column "C".
            worksheet.Columns["C"].Insert();

            // Insert column "E".
            worksheet.Columns.Insert(4);

            // Insert three columns (from column "G" to column "I").
            worksheet.Columns.Insert(6, 3);

            // Insert two columns to the left of the "L15:M16" cell range.
            worksheet.InsertCells(worksheet.Range["L15:M16"], InsertCellsMode.EntireColumn);
            #endregion #InsertColumns
        }

        static void DeleteRowsColumns(Workbook workbook) {
            Worksheet worksheet = workbook.Worksheets["Sheet1"];

            // Fill cells with data.
            for (int i = 0; i < 15; i++) 
            {
                worksheet.Cells[i, 0].Value = i + 1;
                worksheet.Cells[0, i].Value = i + 1;
            }

            #region #DeleteRows
            // Delete the second row.
            worksheet.Rows[1].Delete();

            // Delete the third row.
            worksheet.Rows.Remove(2);

            // Delete three rows (from row 10 to row 12).
            worksheet.Rows.Remove(9, 3);

            // Delete a row that contains the "B2" cell.
            worksheet.DeleteCells(worksheet.Cells["B2"], DeleteMode.EntireRow);
            #endregion #DeleteRows

            #region #DeleteColumns
            // Delete the second column.
            worksheet.Columns[1].Delete();

            // Delete the third column.
            worksheet.Columns.Remove(2);

            // Delete three columns (from column "J" to column "L").
            worksheet.Columns.Remove(9, 3);

            // Delete a column that contains the "B2" cell.
            worksheet.DeleteCells(worksheet.Cells["B2"], DeleteMode.EntireColumn);
            #endregion #DeleteColumns
        }

        static void CopyRowsColumns(Workbook workbook) {
            Worksheet worksheet = workbook.Worksheets[0];

            // Modify the second row. 
            worksheet.Cells["A2"].Value = "Row 2";
            worksheet.Rows["2"].Height = 150;
            worksheet.Rows["2"].Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
            worksheet.Rows["2"].FillColor = Color.LightCyan;

            // Modify the "B" column.
            worksheet.Cells["B1"].Value = "ColumnB";
            worksheet.Columns["B"].Borders.SetOutsideBorders(Color.CadetBlue, BorderLineStyle.Thick);
            
            #region #CopyRowsColumns
            // Copy all data from the second row to the fifth row.
            worksheet.Rows["5"].CopyFrom(worksheet.Rows["2"]);

            // Copy only borders from the "B" column to the "E" column.
            worksheet.Columns["E"].CopyFrom(worksheet.Columns["B"], PasteSpecial.Borders);
            #endregion #CopyRowsColumns
        }

        static void ShowHideRowsColumns(Workbook workbook) {
            #region #ShowHideRowsColumns
            Worksheet worksheet = workbook.Worksheets[0];
            
            // Hide the eighth row.
            worksheet.Rows[7].Visible = false;            
            // Hide the fourth column.
            worksheet.Columns[3].Visible = false;

            // Hide columns from 5 to 7.
            worksheet.Columns.Hide(5, 7);
            // Hide rows from 6 to 8.
            worksheet.Rows.Hide(5, 7);

            // Hide the tenth row.
            worksheet.Rows[9].Height = 0;
            // Hide the tenth column.
            worksheet.Columns[9].Width = 0;
            #endregion #ShowHideRowsColumns
        }

        static void SpecifyRowsHeightColumnsWidth(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];

            worksheet.Range["B1:J1"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            worksheet.Cells["B1"].Value = "30 characters";
            worksheet.Cells["C1"].Value = "15 mm";
            worksheet.Cells["E1"].Value = "100 points";
            worksheet.Cells["F1"].Value = "70 points";
            worksheet.Cells["G1"].Value = "70 points";
            worksheet.Cells["H1"].Value = "70 points";
            worksheet.Cells["J1"].Value = "30 characters";
            worksheet.Cells["K1"].Value = "15 mm";

            worksheet.Cells["A3"].Value = "50 points";
            worksheet.Cells["A5"].Value = "2 inches";
            worksheet.Cells["A7"].Value = "50 points";
            Formatting rowHeightValues = worksheet.Range["A3:A7"].BeginUpdateFormatting();            
            rowHeightValues.Alignment.RotationAngle = 90;
            rowHeightValues.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
            rowHeightValues.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
            worksheet.Range["A3:A7"].EndUpdateFormatting(rowHeightValues);

            #region #RowHeight
            // Set the height of the third row to 50 points.
            workbook.Unit = DevExpress.Office.DocumentUnit.Point;
            worksheet.Rows[2].Height = 50;

            // Set the height of the row that contains the "C5" cell to 2 inches.
            workbook.Unit = DevExpress.Office.DocumentUnit.Inch;
            worksheet.Cells["C5"].RowHeight = 2;

            // Set the height of the seventh row to the height of the third row.
            worksheet.Rows["7"].Height = worksheet.Rows["3"].Height;

            // Set the default row height to 30 points.
            workbook.Unit = DevExpress.Office.DocumentUnit.Point;
            worksheet.DefaultRowHeight = 30;
            #endregion #RowHeight

            #region #ColumnWidth
            // Set the "B" column width to 30 characters of the default font that is specified by the Normal style.
            worksheet.Columns["B"].WidthInCharacters = 30;

            // Set the "C" column width to 15 millimeters.
            workbook.Unit = DevExpress.Office.DocumentUnit.Millimeter;
            worksheet.Columns["C"].Width = 15;

            // Set the width of the column that contains the "E15" cell to 100 points.
            workbook.Unit = DevExpress.Office.DocumentUnit.Point;
            worksheet.Cells["E15"].ColumnWidth = 100;

            // Set the width of all columns that contain the "F4:H7" cell range (the "F", "G" and "H" columns) to 70 points.
            worksheet.Range["F4:H7"].ColumnWidth = 70;

            // Set the "J" column width to the "B" column width value.
            worksheet.Columns["J"].Width = worksheet.Columns["B"].Width;

            // Copy the "C" column width value and assign it to the "K" column width.
            worksheet.Columns["K"].CopyFrom(worksheet.Columns["C"], PasteSpecial.ColumnWidths);

            // Set the default column width to 40 pixels.
            worksheet.DefaultColumnWidthInPixels = 40;
            #endregion #ColumnWidth

        }

        static void GroupRowsColumns(Workbook workbook) {

            Worksheet worksheet = workbook.Worksheets[0];

            #region #GroupRows
            // Group ten rows (from the second row to the eleventh row).
            worksheet.Rows.Group(1, 10, false);
            #endregion #GroupRows

            #region #GroupColumns
            // Group eight columns (from the third column to the tenth column).
            worksheet.Columns.Group(2, 9, true);
            #endregion #GroupColumns
        }

        static void DeleteRowsBasedOnCondition(IWorkbook workbook)
        {
            #region #DeleteRowsBasedOnCondition
            // Load a document from a file.
            workbook.LoadDocument("Documents\\Document.xlsx");

            // Access a worksheet.
            Worksheet worksheet = workbook.Worksheets[0];

            // Specify the condition to remove worksheet rows.
            // If a value in column "A" is greater than 3
            // and less than 14, remove the corresponding row. 
            Func<int, bool> rowRemovalCondition = x => worksheet.Cells[x, 0].Value.NumericValue > 3.0 && worksheet.Cells[x, 0].Value.NumericValue < 14.0;

            // Fill cells with data.
            for (int i = 0; i < 15; i++)
            {
                worksheet.Cells[i, 0].Value = i + 1;
                worksheet.Cells[0, i].Value = i + 1;
            }

            // Delete all rows that meet the specified condition.
            //worksheet.Rows.Remove(rowRemovalCondition);

            // Delete rows that meet the specified condition.
            // Check from the 8th row.
            worksheet.Rows.Remove(7, rowRemovalCondition);

            // Delete rows that meet the specified condition.
            // Check rows 6 through 15.
            //worksheet.Rows.Remove(5, 14, rowRemovalCondition);
            #endregion #DeleteRowsBasedOnCondition
        }

        static void DeleteColumnsBasedOnCondition(IWorkbook workbook)
        {
            #region #DeleteColumnsBasedOnCondition
            // Load a document from a file.
            workbook.LoadDocument("Documents\\Document.xlsx");

            // Access a worksheet.
            Worksheet worksheet = workbook.Worksheets[0];

            // Specify the condition to remove worksheet columns.
            // If a value in the first row is greater than 3
            // and less than 14, remove the corresponding column. 
            Func<int, bool> columnRemovalCondition = x => worksheet.Cells[0, x].Value.NumericValue > 3.0 && worksheet.Cells[0, x].Value.NumericValue < 14.0;

            // Fill cells with data.
            for (int i = 0; i < 15; i++)
            {
                worksheet.Cells[i, 0].Value = i + 1;
                worksheet.Cells[0, i].Value = i + 1;
            }

            // Delete all columns that meet the specified condition.
            //worksheet.Columns.Remove(columnRemovalCondition);

            // Delete columns that meet the specified condition.
            // Check from the 8th column.
            worksheet.Columns.Remove(7, columnRemovalCondition);

            // Delete columns that meet the specified condition.
            // Check columns "F" through "O".
            //worksheet.Columns.Remove(5, 14, columnRemovalCondition);

            #endregion #DeleteColumnsBasedOnCondition
        }
    }
}
SpreadsheetExamples/SpreadsheetActions/WorksheetActions.cs(vb) 
C#
using System;
using System.Drawing;
using DevExpress.Spreadsheet;

namespace SpreadsheetExamples {

    public static class WorksheetActions {
        #region Actions
        public static Action<Workbook> AssignActiveWorksheetAction = AssignActiveWorksheet;
        public static Action<Workbook> AddWorksheetAction = AddWorksheet;
        public static Action<Workbook> RemoveWorksheetAction = RemoveWorksheet;
        public static Action<Workbook> RenameWorksheetAction = RenameWorksheet;
        public static Action<Workbook> CopyWorksheetWithinWorkbookAction = CopyWorksheetWithinWorkbook;
        public static Action<Workbook> CopyWorksheetBetweenWorkbooksAction = CopyWorksheetBetweenWorkbooks;
        public static Action<Workbook> MoveWorksheetAction = MoveWorksheet;
        public static Action<Workbook> ShowHideWorksheetAction = ShowHideWorksheet;
        public static Action<Workbook> ShowHideGridlinesAction = ShowHideGridlines;
        public static Action<Workbook> ShowHideHeadingsAction = ShowHideHeadings;
        public static Action<Workbook> PageSetupAction = PageSetup;
        public static Action<Workbook> ZoomWorksheetAction = ZoomWorksheet;
        
        #endregion

        static void AssignActiveWorksheet(Workbook workbook) {
            #region #ActiveWorksheet
            // Set the second worksheet under the "Sheet2" name as active.
            workbook.Worksheets.ActiveWorksheet = workbook.Worksheets["Sheet2"];
            #endregion #ActiveWorksheet
        }

        static void AddWorksheet(Workbook workbook) {
            #region #AddWorksheet
            // Add a new worksheet to the workbook. The worksheet is appended to the end of the worksheet collection
            // under the name "SheetN", where N is a number that is greater by 1
            // than the maximum number used in worksheet names of the same type.
            workbook.Worksheets.Add();

            // Add a new worksheet under the specified name.
            workbook.Worksheets.Add().Name = "TestSheet1";

            workbook.Worksheets.Add("TestSheet2");

            // Add a new worksheet to the specified position in the worksheet collection.
            workbook.Worksheets.Insert(1, "TestSheet3");

            workbook.Worksheets.Insert(3);

            #endregion #AddWorksheet
        }

        static void RemoveWorksheet(Workbook workbook) {
            #region #DeleteWorksheet
            // Delete the "Sheet2" worksheet.
            workbook.Worksheets.Remove(workbook.Worksheets["Sheet2"]);

            // Delete the first worksheet.
            workbook.Worksheets.RemoveAt(0);
            #endregion #DeleteWorksheet
        }

        static void RenameWorksheet(Workbook workbook) {
            #region #RenameWorksheet
            // Rename the second worksheet.
            workbook.Worksheets[1].Name = "Renamed Sheet";
            #endregion #RenameWorksheet
        }

        static void CopyWorksheetWithinWorkbook(Workbook workbook) {

            workbook.Worksheets["Sheet1"].Cells.FillColor = Color.LightSteelBlue;
            workbook.Worksheets["Sheet1"].Cells["A1"].ColumnWidthInCharacters = 50;
            workbook.Worksheets["Sheet1"].Cells["A1"].Value = "Sheet1's Content";

            #region #CopyWorksheet
            // Add a new worksheet to a workbook.
            workbook.Worksheets.Add("Sheet1_Copy");

            // Copy all information (content and formatting) to the newly created worksheet 
            // from the "Sheet1" worksheet.
            workbook.Worksheets["Sheet1_Copy"].CopyFrom(workbook.Worksheets["Sheet1"]);
            #endregion #CopyWorksheet
        }

        static void CopyWorksheetBetweenWorkbooks(Workbook workbook)
        {
            #region #CopyWorksheetsBetweenWorkbooks
            // Create a source workbook.
            Workbook sourceWorkbook = new Workbook();

            // Add a new worksheet.
            sourceWorkbook.Worksheets.Add();

            // Modify the second worksheet of the source workbook.
            sourceWorkbook.Worksheets[1].Cells["A1"].Value = "A worksheet to be copied";
            sourceWorkbook.Worksheets[1].Cells["A1"].Font.Color = Color.ForestGreen;

            // Copy the second worksheet of the source workbook into the first worksheet of another workbook.
            workbook.Worksheets[0].CopyFrom(sourceWorkbook.Worksheets[1]);
            #endregion #CopyWorksheetsBetweenWorkbooks
        }

        static void MoveWorksheet(Workbook workbook) {
            #region #MoveWorksheet
            // Move the first worksheet to the position of the last worksheet within the workbook.
            workbook.Worksheets[0].Move(workbook.Worksheets.Count - 1);
            #endregion #MoveWorksheet
        }

        static void ShowHideWorksheet(Workbook workbook) {
            #region #ShowHideWorksheet
            // Hide the "Sheet2" worksheet and disable access to this worksheet in the user interface.
            // Use the Worksheet.Visible property to unhide this worksheet.
            workbook.Worksheets["Sheet2"].VisibilityType = WorksheetVisibilityType.VeryHidden;

            // Hide the "Sheet3" worksheet. 
            // You can unhide this worksheet from the user interface.
            workbook.Worksheets["Sheet3"].Visible = false;
            #endregion #ShowHideWorksheet
        }

        static void ShowHideGridlines(Workbook workbook) {
            #region #ShowHideGridlines
            // Hide gridlines on the first worksheet.
            workbook.Worksheets[0].ActiveView.ShowGridlines = false;
            #endregion #ShowHideGridlines
        }

        static void ShowHideHeadings(Workbook workbook) {
            #region #ShowHideHeadings
            // Hide row and column headings in the first worksheet.
            workbook.Worksheets[0].ActiveView.ShowHeadings = false;
            #endregion #ShowHideHeadings
        }

        static void PageSetup(Workbook workbook)
        {
            #region #ViewType
            // Select the worksheet view type.
            workbook.Worksheets[0].ActiveView.ViewType = WorksheetViewType.PageLayout;
            #endregion #ViewType

            #region #PageOrientation
            // Set the page orientation to Landscape.
            workbook.Worksheets[0].ActiveView.Orientation = PageOrientation.Landscape;
            #endregion #PageOrientation

            #region #PageMargins
            // Specifies inches as the workbook's measurement units.
            workbook.Unit = DevExpress.Office.DocumentUnit.Inch;

            // Access page margins.
            Margins pageMargins = workbook.Worksheets[0].ActiveView.Margins;

            // Specify page margins.
            pageMargins.Left = 1;
            pageMargins.Top = 1.5F;
            pageMargins.Right = 1;
            pageMargins.Bottom = 0.8F;

            // Specify header and footer margins.
            pageMargins.Header = 1;
            pageMargins.Footer = 0.4F;
            #endregion #PageMargins

            #region #PaperSize
            // Select the page's paper size.
            workbook.Worksheets[0].ActiveView.PaperKind = DevExpress.Drawing.Printing.DXPaperKind.A4;
            #endregion #PaperSize
        }

        static void ZoomWorksheet(Workbook workbook) {
            #region #WorksheetZoom
            // Zoom in the worksheet view. 
            workbook.Worksheets[0].ActiveView.Zoom = 150;            
            #endregion #WorksheetZoom
        }

    }
}

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.