|
Extract Reference File Data |
|
|
|
|
Sun Documentation -
Vision XL
|
|
Page 3 of 3
Sorting You now have the Output data items in the correct output order. Now we would like define the sorting of the output. Click this button: Click here to see the screenshotYou can apply ascending or descending sort orders to output data items. The order in which the data items appear in the Sorting window determines the sort order. Use the ‘move’ buttons to change the sort sequence. Select Description and Name in the Selection List and drag them to the Sorting window. Click OK
Tab2 Click here to see the screenshotTo enable you to later use this same extraction layout, you will save the selections and setting using Setup File and Workbook File. Enter the name for your Setup File. The Workbook File is save within the workbook, rather than externally in the file system (Setup File). It’s important to remember that the Excel workbook must be saved to save the Workbook file. Enter AR1 as a Workbook File name. Click OK – this will save the setup data to the Setup File and the Workbook File, and extract the data to the Excel workbook. Click here to see the screenshotThe columns are output in the order they were displayed in the Output window. The rows are sorted in Description then Asset Category Name sequence as defined in the Sorting window. If you want to you can load an existing Reference File Fill report, modify the file and save as a new Workbook. A few changes to filtering, selection or formatting can result in a radically different report, which can be saved to the same spreadsheet by using the save Workbook function or you can save it as a new Setup File.
Only registered users can write comments. Please login or register.
|