You can get or set the Excel summary information (including the Title, Subject, Author, Manager, Company, Category, Keywords, Comments, Hyperlink Base, Version, Application, Application Version, Created, Creator, Creators, Language, Last Modified, Last Modified By, Revision, Description etc) ) while importing and exporting the data from or to the excel file.

The "Workbook views" settings in the Excel workbook can be imported/exported by the customer using the View property in the SheetView class. There are 3 views setting that includes : Normal, Page Layout, and Page Break Preview.

The DocumentProperties property in the FpSpread class represents all properties of the spread document that can be get/set by the users.

Using Code

This example code shows how to store the excel summary and review information.

//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 Grapecity";
fpSpread1.DocumentProperties.Creator = "Grapecity";
fpSpread1.DocumentProperties.Version = "11.0.0.0";
fpSpread1.DocumentProperties.Description = "Test values for Excel summary";
fpSpread1.DocumentProperties.Application = "Test Application";

'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 Grapecity"
fpSpread1.DocumentProperties.Creator = "Grapecity"
fpSpread1.DocumentProperties.Version = "11.0.0.0"
fpSpread1.DocumentProperties.Description = "Test values for Excel summary"
fpSpread1.DocumentProperties.Application = "Test Application"