Excel to Electrical Schematics (Excel Automation)
How it would be if Schematic Drawing Create Automatically with Reference to data in Excel Sheet???
Then you might to check out SOLIDWORKS Electrical 2017!!!
SOLIDWORKS Electrical has new interesting functionality called Excel Automation for doing just that. The basic steps for this process are
- Create the macros you would like to use.
- Create the XLS file (instructions) from the file template.
- Import the XLS file using the XLS Automation feature to generate the drawings.
1.Create the Macro
Macros is a predefined circuit, these macros are created in Library and must include these two rules, insertion point and variables.
Insertion point
The macros are automatically inserted in the drawing and must have a specific insertion point. From the Insertion point feature, click the point where you want the macro to be inserted. You will have to enter the coordinates of this point in the XLS file.
Variable definition
The macro contains variables that propagate information in the scheme such as a mark, a manufacturer part or an equipotential number. These variables will be replaced by texts you will set-up in the XLS file. The variables must be formatted with the “%” character placed before and after the variable.
For example %Contactor%, in which “Contactor” is the variable name.
2.Create the XLS file
The XLS file must contain specific instructions to be used to do the XLS Automation. It can have as many rows before the header as the user want. The process reads the first row that has the first string that start with the # character. It is the header line.
| Field Name | Description | Required |
| #mac_name | Name of the macro | Yes |
| #mac_posx | The position X where the macro will be inserted | Yes |
| #mac_posy | The position Y where the macro will be inserted | Yes |
Similarly File name, Folder name, Location, Function, Bundle can be created with # character.
3.Import the XLS file using the Excel Automation feature
Choose the Excel file in Excel automation feature
Reading the Excel file and inserting macros
Schematic Drawings been created
SIM Technologies Pvt Ltd is an Authorized Reseller for SOLIDWORKS Electrical 2017 Solution for live demo contact +91 87 5444 7021 | info@simtek.in | 044-6565 0842