How can I insert a spreadsheet into a drawing?
To insert a spreadsheet into a drawing, you can use one of the following methods.
Method 1
The TABLE command allows to insert spreadsheet data as native table entities.
This can be done by:
- Copying from Excel to the clipboard and then using the PASTESPEC command. Choose the XML Spreadsheet option in the Paste Special dialog box.
- Exporting the data from the spreadsheet (Microsoft Excel, LibreOffice, or OpenOffice) to CSV, XML, XLS, XLSX formats, and using the TABLE command. Use the Upload file option in the Insert Table dialog box, to insert an existing spreadsheet as a table entity in BricsCAD.
Method 2
- In the Insert menu, choose Insert Object....
- In the Insert Object dialog box choose between a new or an existing spreadsheet.
- To insert a new spreadsheet: Choose Create New, then select Microsoft Excel in the Object Type list.
- To insert an existing spreadsheet: Choose Create from File, then click the Browse... button and select the spreadsheet.
- Optionally, check the Link option. If selected, the drawing will update the spreadsheet every time you open the drawing.
- Click the OK button to insert the spreadsheet.
Method 3
- Open the spreadsheet in Microsoft Excel.
- Select the part of the spreadsheet you want to import in a BricsCAD drawing.
- Press Ctrl+C to copy the selection to the clipboard.
- Switch to BricsCAD, then press Ctrl+V to paste the selection.
In BricsCAD, spreadsheet data is pasted as an OLE object in a drawing.
When you select the object, then right-click and choose Edit OLE object... in the context menu, Excel (if not already open) will be launched to edit the spreadsheet.
When you save the spreadsheet, the OLE object in the drawing is updated.