This tool can be used to export data from multiple worksheets as multiple ASCII files. Note that the ASCII export is limited to data-only worksheets.
Download the file Export Multiple Worksheets.opx, and then drag-and-drop onto the Origin workspace. An icon will appear in the Apps gallery window.
With the data worksheet active, click the app icon from the Apps gallery window. Then a dialog will pops up for the settings of exporting. Change the settings in dialog accordingly, then click OK button.
- Dialog Setings
- Input Worksheet(s): Specify the worksheet(s) for exporting. The active worksheet is selected by default. And you can click the triangle button to select other worksheet(s) from the context menu, including Active Worksheet Only, All In Active Workbook, All In Active Folder, All In Active Folder (recursive), and All In Project. And you can also Reset it, or click Select Worksheets... to open the Sheet Browser dialog to select worksheet(s) to export.
- Base Directory: Specify where to save the exported ASCII files, including options <User Files Folder> for User Files Folder, <Project Folder> for project folder, <Project Folder><PE Path> for project folder with the path of Project Explorer. And it also allows to select a folder by clicking the ... button.
- File Name(s): Specify file name(s) for exported files. If Auto, the short name of worksheet is used, and if there are duplicated names, names will be enumerated. And the # syntax is available for exporting multiple worksheets using number enumerated replacement. If each file has a specified name, the number of names has to match the number of input worksheets.
- Other Settings: Please refer to the related options in expASC X-Function.