Skip to content
Paul Ebbers edited this page Jan 28, 2024 · 13 revisions

This workbench is developed to import data for the titleblock in your TechDraw drawing.

The main functions are:

  • Load the data (editable fields with or without values) from your drawing into a spreadsheet
  • Use document information from your document as input.
  • Use system units from your system as input.
  • Import data from an excel workbook to a spreadsheet.
  • Export the data to an excel workbook.
  • Fill the titleblock on all pages in your document from data in the spreadsheet.
  • Export the workbench settings to a excel workbook.
  • Import the workbook settings from a excel workbook at startup.

There are three main ways to use this workbench:

  1. Use a spreadsheet with data to fill titleblocks in a document with multiple TechDraw pages.
  2. Use a central Excel workbook when working with multiple documents. You can set standard data like Project name, approver name, etc.
  3. Use a central Excel workbook on a shared location when working with multiple people on a project. Like with way 2, you can set standard date but also synchronise workbook settings among all users.

Important note: After changing settings in the preference menu, FreeCAD needs to be restarted!

Additional notes:

  • To ensure that the optional toolbar for the TechDraw Workbench is loaded during startup, set this workbench to auto-load.
  • Although this workbench makes use of excel files, it does not depend on Excel itself. You can use any program to open, read and modify your Excel file. For example you can use LibreOffice or OpenOffice.

Clone this wiki locally