Integrations and Special Interfaces → Exporting SBM Data to Microsoft Excel® → Using the Export to Excel Link
The Export to Excel link is available on most item lists and report results and enables you to export data to Microsoft Excel. Use this link to export data that you do not wish to update each time that you open your Excel spreadsheet.
The Excel link exports the report into Excel by formatting the report and field information into XML. The XML allows the data to be imported correctly into Excel. For example, date fields are imported into Microsoft Excel as dates, not as numbers.
Text fields that are included in exported reports do not include any line breaks. Instead, the content is exported as single line text. Some report formatting is altered for better conversion to Excel. For example, the checkmarks in privilege reports are changed to Y's and the blanks are changed to N's in the Excel output.
To export SBM data to Excel using the Export to Excel link:
Copyright © 2001–2018 Serena Software, Inc., a Micro Focus company. All rights reserved.