Difference between revisions of "Exporting List View Results to Microsoft Excel"
From SmartWiki
| Line 20: | Line 20: | ||
* [[Import/Export and Integration Techniques Overview]] | * [[Import/Export and Integration Techniques Overview]] | ||
* [[Exporting Currency Values to Excel from List Views]] | * [[Exporting Currency Values to Excel from List Views]] | ||
| + | * Note that buttons displayed on the list view, such as [[Quick Edit]] buttons and {{WPV}}s, will not be exported. A blank column in the Excel file will result for columns containing only buttons. | ||
[[Category:Integration]] | [[Category:Integration]] | ||
| Line 28: | Line 29: | ||
- I fixed it by removing the currency format when exporting. I also apply a fix to remove all html codes from the content for the export. This is on org | - I fixed it by removing the currency format when exporting. I also apply a fix to remove all html codes from the content for the export. This is on org | ||
- 15327 - Issues with list view export to excel | - 15327 - Issues with list view export to excel | ||
| + | - 24623 - QuickEdit button should be excluded from export | ||
--> | --> | ||
Revision as of 10:49, 4 November 2013
Click here to watch a video on creating and editing List Views.
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, take the following steps to enable exporting to Excel:
- Go to the list view configuration page.
- Click into the list view for which you wish to enable exporting.
- Click on the "Export" tab.
- Select the
option. - Click the "Save" button.
- The Export button will now be enabled for your list view.
- 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 this page for instructions.
- Additionally, you can upload an Excel spreadsheet to be used as a template for list view result exports. Visit this page for instructions.
- SmartSimple uses special rules for exporting values stored in currency formats to Excel. Visit this page for detailed information.
See Also
- List View Overview
- Accessing the List View Configuration Page
- Configuring List Views
- Setting the Sort Order on a List View
- Exporting List View Results to Microsoft Excel
- Exporting List View Results to Microsoft Word
- Download files from List View
- Preparing Existing Word Template for List View Export
- Quick Edit
- Historic List View
- Configuring Interactive List View Charts
- Positioning Exported List View Results in your Excel Spreadsheet
- Using an Excel Template for List View Export Results
- Import/Export and Integration Techniques Overview
- Exporting Currency Values to Excel from List Views
- Note that buttons displayed on the list view, such as Quick Edit buttons and Web Page Views, will not be exported. A blank column in the Excel file will result for columns containing only buttons.
