スプレッドシートを図面に挿入するにはどうすればよいですか?

To insert a spreadsheet into a drawing, you can use one of the following methods.

Method 1

TABLEコマンドを使用すると、スプレッドシートデータをネイティブテーブルエンティティとして挿入できます。

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

  1. In the Insert menu, choose Insert Object....
  2. 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.
  3. Optionally, check the Link option. If selected, the drawing will update the spreadsheet every time you open the drawing.
  4. Click the OK button to insert the spreadsheet.

Method 3

  1. スプレッドシートを Microsoft Excel で開きます。
  2. BricsCAD図面にインポートするスプレッドシートの部分を選択します。
  3. Press Ctrl+C to copy the selection to the clipboard.
  4. 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.