dynamic connection distinct solidworks-excel

[tzadik]

Hello everyone, is there a way to create a link between a distinct set in a solidworks set to a excel sheet?

premise: Solidworks has already a default format.
at the moment, I manually carry the solidworks distinct in *.xlsx and simply correct formatting, not moving cells or necks. change only character and stop.

what I would like is that the excel sheet was automatically updated when something changes inside the axieme (and of course in the distinct in it).

the purpose is to make the distinct solidworks (which is then a distinct real) readable by all...
... considering that not all users here have solidworks (or edrawings) and therefore cannot read a distinct if it is not in a "universal" format (at the moment it is still a excel sheet).

 

[MassiVonWeizen]

It's not possible.

 

[MassiVonWeizen]

It is also true for you what is often repeated.
the answers given confirms whether the solution was useful or not so as to be in your turn of help to those who will have a similar problem.
Your incriminated discussions:

Separazione "parti commerciali" e "parti progettate" nella distinta.

Salve, esiste un modo smart di avere sulla distinta di base (di un assieme) generata da SolidWorks una separazione tra parti progettate e le componenti commerciali? È implementabile associando questa il tipo di parte (progettata o commerciale) a una proprietà personalizzata (tipo...

www.cad3d.it

Moduli unificati di ruote dentate

Ciao a tutti, sto preparando l'esame di costruzione di macchine, e ho un dubbio riguardo al progetto delle ruote dentate. Nella scelta del modulo, la tabella dei moduli unificati ne riporta alcuni sconsigliati, ed altri fortemente sconsigliati. Che peso ha questa indicazione? Ad esempio, mi...

www.cad3d.it

 

[tzadik]

It's not possible.

solved.
Indirectly, but I solved.
Thank you.

 

[MassiVonWeizen]

solved.
Indirectly, but I solved.
Thank you.

thanks, exhaustive explanation and of which the forum will benefit

 

[tzadik]

I defined a "material distinct" template on solidworks.
in this template are contemplated some rules to organize what will then be the content.

Basic... I carry the distinct materials (which I generate inside a set) in excel format.

as I defined the separate template, I already know a priori that I will have to go to read the excel file cells created by a specific cell down/right.

remains to manually export from separate materials to excel files* but done this the rest comes automatically to me.


*: Probably you can create a macro that exports me the table of the distinct materials (contained inside the axieme of solidworks), for example, after each rescue.

 

[MassiVonWeizen]

Your request was

what I would like is that the excel sheet was automatically updated when something changes inside the axieme (and of course in the distinct in it).

This is not possible.

 

[tzadik]

but the result was obtained by adding an extra passage.

 

[MassiVonWeizen]

I apologize if I insist, but what you asked initially is not possible even adding a thousand extra steps.
if then you for extra passage you mean that at every modification of the distinct materials you have to export the excel file then you would have told you immediately how to do