Excel Output of Tech Packs

This topic includes information about tech pack output in the Excel format.

Sharing an Excel Tech Pack

To share an Excel format tech pack, you must include both of the following:

• .xlxs file

• .res folder

For example, to share the tech pack of a garment called SummerT, you must include SummerT.xlxs and SummerT.res.

Excel Tech Pack Printing Tips

If you print the Excel version of the tech pack, for some of the worksheets you may find the content easier to follow if you ensure the column and row labels are repeated on every page. You may also want to set up your own page breaks.

Column and Row Labels

To format the worksheet output for labels:

1. In Excel, open the worksheet you want to configure.

2. On the Page Layout tab, in the Page Setup group, click Print Titles.

   

   The Page Setup dialog box is displayed with the Sheet tab selected.

   

3. In Rows to repeat at top, type in the rows that contain the column labels. For example, to print column labels at the top of every page, type $1:$1.

4. In Columns to repeat at left, type in the columns that contain the row labels. For example, to print the row labels of column A at the left side of every page, type $A:$A.

Page Break

To insert a page break:

1. In Excel, open the worksheet you want to configure.

2. On the View tab, in the Workbook Views group, click Page Break Preview.

   

   The worksheet displays with a preview of the page breaks.

3. You can insert vertical and horizontal page breaks. To insert a:

   1. Vertical page break, select the row below where you want to insert the page break.

   2. Horizontal page break, select the column to the right of where you want to insert the page break.

4. On the Page Layout tab, in the Page Setup group, click Breaks.

   

   A menu is displayed.

5. Click Insert Page Break. The page break is inserted.

Excel Tech Pack Known Limitations

The following are known limitations applicable to the Excel version of tech packs.

• MacOS

  If you print the Excel version of the tech pack, the page layout (portrait or landscape) of the currently selected sheet determines the page layout for all pages.

• Windows

  If you print the Excel version of the tech pack, the default printer margin settings may overrule the default tech pack margin settings of 0.2”. For best output, change the default printer margin settings accordingly.