New bend tables that you create for SolidWorks are stored in an embedded Excel spreadsheet. You add bend table values into the cells of the spreadsheet, ensuring that the table is read properly by the SolidWorks software.
Bend tables made in Microsoft Excel now support the following:
All bend table types (bend deduction, bend allowance, and k-factor).
Multiple angles in a single bend table file.
To create a bend table:
In a part, click Insert, Sheet Metal, Bend Table, New.
If you get a message that says inserting a bend table may
cause the developed length of the flat pattern to change, click Yes.
In the dialog box:
Select an item in Units to set the unit of measurement.
Select an item in Type to set the bend allowance or bend deduction.
Type a path for File name, or click Browse to locate a path where you want to save the bend table.
Click OK.
An embedded Excel window, containing the bend table spreadsheet, appears in the SolidWorks window. The bend table spreadsheet contains default radius, thickness, and angle values.
Type the bend allowance or bend deduction values to the spreadsheet, depending on your choice for Type in step 2.
Click outside the table, but within the SolidWorks graphics area, to close the spreadsheet.