Old "Text" BOM to Excel

Use this space to ask how to do whatever you're trying to use SolidWorks to do.
MJuric
Posts: 1070
Joined: Mon Mar 08, 2021 3:21 pm
Answers: 1
x 31
x 874

Old "Text" BOM to Excel

Unread post by MJuric »

Anyone have any tricks for getting old 2D text, non table BOM, from a DWG into Excel?
User avatar
josh
Posts: 293
Joined: Thu Mar 11, 2021 1:05 pm
Answers: 16
x 22
x 500

Re: Old "Text" BOM to Excel

Unread post by josh »

You mean AutoCAD DWG file? Check AutoDesk section of the forum?
User avatar
jcapriotti
Posts: 1852
Joined: Wed Mar 10, 2021 6:39 pm
Answers: 29
Location: The south
x 1196
x 1984

Re: Old "Text" BOM to Excel

Unread post by jcapriotti »

MJuric wrote: Mon Nov 04, 2024 1:51 pm Anyone have any tricks for getting old 2D text, non table BOM, from a DWG into Excel?
I recommend trying "Snag it" for this.
https://www.techsmith.com/snagit/

You can still get a perpetual license for $63 although I think they are going subscription only with the next version o[. Well worth it for general screen grabs and markup.

It has a function called "Grab Text". I took a screen grab of a table from a drawing, then in the Snag-It editor, select "Grab Text"
image.png
It then opens another window with the table and text. Select Copy All.....
image.png
Then paste into Excel
image.png
From there you can cut and paste from Excel to a SolidWorks General table if you want it there in SolidWorks instead. I tried copy / paste from the Snag-It grab text but it wouldn't paste into a SolidWorks table. So you must go the Excel route first.
image.png
Jason
MJuric
Posts: 1070
Joined: Mon Mar 08, 2021 3:21 pm
Answers: 1
x 31
x 874

Re: Old "Text" BOM to Excel

Unread post by MJuric »

Nice, I'll take a look and see if I can...snag it...see what I did there.

Thank You
MJuric
Posts: 1070
Joined: Mon Mar 08, 2021 3:21 pm
Answers: 1
x 31
x 874

Re: Old "Text" BOM to Excel

Unread post by MJuric »

josh wrote: Tue Nov 05, 2024 3:39 pm You mean AutoCAD DWG file? Check AutoDesk section of the forum?
I saw I could do that in AutoCAD...unfortunately I don't have an AutoCAD license at the moment. This is actually in Draftsight.
User avatar
JSculley
Posts: 640
Joined: Tue May 04, 2021 7:28 am
Answers: 55
x 9
x 872

Re: Old "Text" BOM to Excel

Unread post by JSculley »

MJuric wrote: Thu Nov 07, 2024 2:10 pm I saw I could do that in AutoCAD...unfortunately I don't have an AutoCAD license at the moment. This is actually in Draftsight.
Draftsight has an API
Post Reply