Changes

Jump to: navigation, search

Exporting List View Results to Microsoft Excel

798 bytes added, 17:31, 23 April 2013
no edit summary
{{ListViewHeader}}
{{UnderConstruction}}
A major feature of SmartSimple [[list views]] is that list view results can be easily exported to Microsoft Excel. Once your list view has been [[Configuring List Views|created]], take the following steps to enable exporting to Excel:# Go to the [[Accessing the List View Configuration Page|list view configuration page]].# Click into the list view for which you wish to enable exporting.# Click on the "Export" tab.# Select the {{EnableExport}} option.
Once your list view has been [[Configuring List Views|created]], click on the "Export" tab of the list view for which you wish to enable exporting.{{ExportEnabled}}
* The Export button will now be enabled for your list view.<br><BR>* You can also tell the system where you want the results of the list view export to be positioned in the resultant Excel spreadsheet. Visit [[Positioning Exported List View Results in your Excel Spreadsheet|this page]] for instructions.* Additionally, you can upload an Excel spreadsheet to be used as a template for list view result exports. Visit [[Using an Excel Template for List View Export Results|this page]] for instructions. {{ListViewFooter}}* [[Positioning Exported List View Results in your Excel Spreadsheet]]* [[Using an Excel Template for List View Export Results]]  <!--{{ExportListViewPage}} # The first step will be to
# The first step will be to select the {{EnableExport}} option.
{{ExportEnabled}}
* This will make the Export button visible at the top of your list view.
{{ListViewFooter}}
<!--Support Tickets that pertain to exporting list views to Excel:
- 16998 - Export to Excel List View
- List view that export to MS Excel no longed render the numeric columns values as values so you cannot use MS Excel functions such as SUM()
8,849
edits

Navigation menu