Question & Answer
Question
The default format for exported i2 iBase data using an Export Spec is .txt; can I change it so that it saves in a MS Excel format?
Answer
Yes, it is possible to set up an i2 iBase Export Spec to export in a MS Excel format such as .xlsx.
Here's how to do it:
1) On Step 2 of the Export Spec, click on the small button alongside the Export File Name box.
2) The Export File dialog opens, change Save as type to All Files.
3) In the File name box, manually change the file extension to xlsx.
4) Click the Save button to return to the import spec where you will see your file name is now set to save in a MS Excel format.
, 5) Continue through the Export Spec and run the export.
6) Navigate to your xlsx file and double click to open it in MS Excel.
[{"Product":{"code":"SSXW43","label":"i2 iBase"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.9.11;8.9.11.1;8.9.11.2","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Was this topic helpful?
Document Information
More support for:
i2 iBase
Software version:
8.9.11, 8.9.11.1, 8.9.11.2
Operating system(s):
Windows
Document number:
569399
Modified date:
16 June 2018
UID
swg22015411