# Storing Excel Summary and View

Discover how to access the DocumentProperties dialog through Spread Designer to manage Excel summary and review information

## Content

Storing Excel Summary and ViewYou can store and display the essential information for the workbook using the **Properties** dialog. The following tabs can be used to accomplish this task:

* **Summary Tab** \- This tab displays information such as the Title\, Subject and Author\. You can enter your custom details such as the Manager name and Company name using this menu\. Further\, you can list the keywords of your choice\, apply Comments and add Hyperlink base information to the spreadsheet\.
* **Contents Tab** \- This tab displays the list of the items present in the workbook such as the number of worksheets\.

![Summary and Contents tabs in Workbook Prpeorties dialog](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/document_properties.gif)

## Using the Spread Designer

In order to access the DocumentProperties dialog through Spread Designer, you can select the **Properties** option available in the **File Menu**.
**Using Code**
This example code shows how to use a Document Properties Form to store the summary and review information.

```csharp
//Get Workbook from fpSpread1
GrapeCity.Spreadsheet.Workbook workbook = fpSpread1.AsWorkbook();
//Call the DocumentPropertiesForm
FarPoint.Win.Spread.DocumentPropertiesForm form = new FarPoint.Win.Spread.DocumentPropertiesForm(workbook);
form.Show();
```

```vbnet
'Get Workbook from fpSpread1
Dim workbook As GrapeCity.Spreadsheet.Workbook = fpSpread1.AsWorkbook()
'Call the DocumentPropertiesForm
Dim form As FarPoint.Win.Spread.DocumentPropertiesForm = New FarPoint.Win.Spread.DocumentPropertiesForm(workbook)
form.Show()
```

The [DocumentProperties](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.DocumentProperties.html) property in the [FpSpread](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.html) class represents all the properties of the spread document that can be get or set by the users.
**Using Code**
This example code shows how to store the Excel summary and review information using [DocumentProperties](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.DocumentProperties.html) property.

```csharp
//Set the view type for the sheetview
fpSpread1.Sheets[0].View = GrapeCity.Spreadsheet.SheetViewType.PageLayout;
//Set the Excel summary properties using Spread's "DocumentProperties" API
fpSpread1.DocumentProperties.Title = "Spread Mescius";
fpSpread1.DocumentProperties.Creator = "Mescius";
fpSpread1.DocumentProperties.Version = "12.0.0.0";
fpSpread1.DocumentProperties.Description = "Test values for Excel summary";
fpSpread1.DocumentProperties.Application = "Test Application";
```

```vbnet
'Set the view type for the sheetview
fpSpread1.Sheets(0).View = GrapeCity.Spreadsheet.SheetViewType.PageLayout
'Set the Excel summary properties using Spread's "DocumentProperties" API
fpSpread1.DocumentProperties.Title = "Spread Mescius"
fpSpread1.DocumentProperties.Creator = "Mescius"
fpSpread1.DocumentProperties.Version = "12.0.0.0"
fpSpread1.DocumentProperties.Description = "Test values for Excel summary"
fpSpread1.DocumentProperties.Application = "Test Application"
```

## See Also

[Saving to a Spread XML File](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-usefiles/spwin-savefiles/spwin-save-spreadfile)
[Saving to an Excel File](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-usefiles/spwin-savefiles/spwin-save-excelfile)
[Saving to a Text File](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-usefiles/spwin-savefiles/spwin-save-texttfile)
[Saving to an HTML Table](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-usefiles/spwin-savefiles/spwin-save-htmltable)
[Saving Spreadsheet Data to Simple XML](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-usefiles/spwin-savefiles/spwin-save-dataxml)