Difference between revisions of "Exporting List View Results to Microsoft Excel"

From SmartWiki
Jump to: navigation, search
Line 3: Line 3:
 
A major feature of SmartSimple [[list views]] is that list view results can be easily exported to Microsoft Excel.  
 
A major feature of SmartSimple [[list views]] is that list view results can be easily exported to Microsoft Excel.  
  
−
- adding Excel file to [[SmartFolders]]
+
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.
  
 
{{ExportListViewPage}}
 
{{ExportListViewPage}}
−
{{EnableExport}}
+
 
 +
# The first step will be to select the {{EnableExport}} option.
 +
 
 
{{ExportEnabled}}
 
{{ExportEnabled}}
 +
 +
* This will make the Export button visible at the top of your list view.
 +
 +
# The next step will be to tell the system where in the resultant Excel file to position your results.
 +
 +
{{MSExcelSettings}}
 +
 +
* The default setting
 +
 +
- adding Excel file to [[SmartFolders]]
 +
 +
 
{{MSExcelSettings}}
 
{{MSExcelSettings}}
 
{{MSWordSettings}}
 
{{MSWordSettings}}

Revision as of 13:10, 23 April 2013

caption Click here to watch a video on creating and editing List Views.
Template: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 created, click on the "Export" tab of the list view for which you wish to enable exporting.

ExportListView1.PNG

  1. The first step will be to select the ExportListView enableexport.PNG option.

ExportListView exportenabled.png

  • This will make the Export button visible at the top of your list view.
  1. The next step will be to tell the system where in the resultant Excel file to position your results.

ExportListView MS Excel Settings.PNG

  • The default setting

- adding Excel file to SmartFolders


ExportListView MS Excel Settings.PNG ExportListView MS Word Settings.PNG ExportListView selectafile.png ExportListView SmartFolders.PNG



See Also

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Exporting_List_View_Results_to_Microsoft_Excel&oldid=13506’