Applicable Products : IJCAD 2014 / 2015 / 2016
How to capture the table data of EXCEL to IJCAD There are several.
Paste as OLE data
-
- In Excel, select the range you want to copy to the CAD, then copy it to the clipboard in the shortcut of CTRL + C.
- Open the drawing file you want to paste the table in IJCAD.
- Run the Paste command in the shortcut of [CTRL] + [V].
- When you paste, you might see a dialog of the "OLE text size" is displayed.
If you want to change the character height to match the drawing scale in the drawing, click on the OK button to change the input. - OLE insertion position (lower left point) tells.
- Table is created as CAD graphic (OLE).
- When you paste as OLE data, when you double-click the pasted data on the CAD original application will be able to edit to start. However, please note or not to display the part of OLE data When you open a drawing data in the original application-free environment, it will be in the state that can not be edited.
Paste as CAD graphic
- In Excel, select the range you want to copy to the CAD, then copy it to the clipboard in the shortcut of [CTRL] + [C].
- Open the drawing file you want to paste the table in IJCAD.
- Run the "Pastespec" command.
- Click the OK button to select the "DWG entity" from the Paste format.
- It tells Paste position (upper left point).
(Depending on the contents of the copied table it may take a long time to begin the instruction of pasting position.) - Table is created as CAD graphic (letters and line segment).
- If you have pasted as CAD graphic, it becomes a form you do not want to link the original Excel data, will be in a good state even without the original Excel data. If you want to modify the contents of the created table, you will want to edit the data that has been created to IJCAD not the Excel data.
Note: to paste the copied data as a table (Table) shapes in Excel does not support. (IJCAD 2016 time)
- In Excel, select the range you want to copy to the CAD, then copy it to the clipboard in the shortcut of CTRL + C.