DXL - Creating an Excel file with custom tab names
I'm not sure if I am in the correct forum, but I have a question about DXL. I would like to create an Excel file (.xls) that contains 5 columns of varying widths. I know how to create a .csv file, but you can't colorize cells nor change the name of a worksheet as you can in an Excel file. So how do I create a file that can be saved as with a .xls extension and add the data to it.
Along with this, one of the items I want to save is the Description of the latest baseline. How would I retrieve the attributes of the latest baseline?
Chris Cote
One answer
I think you should follow these steps to save as with a .xls extension and add the data to it:
- Click File > Export > Change File Type.
- Under Workbook File Types, double-click Excel 97-2003 Workbook (*.xls).
- In the Save As popup window, choose a folder location for the workbook.
- In the File name box, type a new file name (or use the one that’s already there).
- Click Save.
-
If the Compatibility Checker appears, review any compatibility issues that were found.
- The Find link takes you to that place in your worksheet, and the Help link takes you to information on the issue and possible solutions.