Getting Started

To get started with the non-visual spreadsheet component, perform the following steps.

1. Start Visual Studio and create a new Console Application project by selecting FILE | New | Project… in the main menu. In the New Project window that is invoked, select Console Application, specify the name of the project, and click OK.

   

2. Add references to the following libraries:

   • DevExpress.Charts.v17.2.Core.dll
   • DevExpress.XtraCharts.v17.2.dll
   • DevExpress.Data.v17.2.dll
   • DevExpress.Docs.v17.2.dll
   • DevExpress.Office.v17.2.Core.dll
   • DevExpress.Spreadsheet.v17.2.Core.dll
   • DevExpress.Utils.v17.2.dll

3. Paste the code listed below in the Main method of the Program.cs file (Main procedure of the Module1.vb file for Visual Basic).

C#

using DevExpress.Spreadsheet; // ... // Create an instance of a workbook. Workbook workbook = new DevExpress.Spreadsheet.Workbook(); // Access the first worksheet in the workbook. Worksheet worksheet = workbook.Worksheets[0]; // Access the "A1" cell in the worksheet. Cell cell = worksheet.Cells["A1"]; // Specify the "A1" cell value. cell.Value = 1; // Fill cells with sequential numbers by using shared formulas. worksheet.Range["A2:A10"].Formula = "=SUM(A1+1)"; worksheet.Range["B1:B10"].Formula = "=A1+2"; // Multiply values contained in the cell range A1 through A10 // by the corresponding values contained in B1 through B10, // and display the results in cells C1 through C10. worksheet.Range["C1:C10"].ArrayFormula = "=A1:A10*B1:B10"; // Save the document file under the specified name. workbook.SaveDocument("TestDoc.xlsx", DocumentFormat.OpenXml); // Display gridlines in PDF. worksheet.PrintOptions.PrintGridlines = true; // Export the document to PDF. workbook.ExportToPdf("TestDoc.pdf"); // Open the PDF document using the default viewer.. System.Diagnostics.Process.Start("TestDoc.pdf"); // Open the XLSX document using the default application. System.Diagnostics.Process.Start("TestDoc.xlsx");

VB

Imports DevExpress.Spreadsheet ' ... ' Create an instance of a workbook. Dim workbook As Workbook = New DevExpress.Spreadsheet.Workbook() ' Access the first worksheet in the workbook. Dim worksheet As Worksheet = workbook.Worksheets(0) ' Access the "A1" cell in the worksheet. Dim cell As Cell = worksheet.Cells("A1") ' Specify the "A1" cell value. cell.Value = 1 ' Fill cells with sequential numbers by using shared formulas. worksheet.Range("A2:A10").Formula = "=SUM(A1+1)" worksheet.Range("B1:B10").Formula = "=A1+2" ' Multiply values contained in the cell range A1 through A10 ' by the corresponding values contained in B1 through B10, ' and display the results in cells C1 through C10. worksheet.Range("C1:C10").ArrayFormula = "=A1:A10*B1:B10" ' Save the document file under the specified name. workbook.SaveDocument("TestDoc.xlsx", DocumentFormat.OpenXml) ' Display gridlines in PDF. worksheet.PrintOptions.PrintGridlines = True ' Export the document to PDF. workbook.ExportToPdf("TestDoc.pdf") ' Open the PDF document using the default viewer.. System.Diagnostics.Process.Start("TestDoc.pdf") ' Open the XLSX document using the default application. System.Diagnostics.Process.Start("TestDoc.xlsx")

4. Run the project.

The following image shows the files generated after executing the code above.