conversion to separate custom excel base

[Dum]

Good morning to all,

I would like to ask you if there is a way to convert a sw diba to excel format on a master of a customer.
until today I have always solved by converting to excel and then copying each field, but it always takes me a lot of time.

is there any way to set the diba in sw so that the export is already in the excel template of the customer?
Is it a job that can sw or should you start excel?

in case it's a feasible thing (and I've been able to explain) do you have any links to turn around with step-by-step instructions of monkey? :



Thank you and good day!

 

[MassiVonWeizen]

Diba? What does that mean? is it a new kind of distinct?
the answer is: very very very difficult.
first you need to understand what excel template uses solidworks for export.
then you have to set the distinct (diba) as the distinct excel and if you have merged cells it is practically impossible.

 

[Dum]

Excuse me, Diba is what I call the distinct bases.
nothing new, the old dear distinguished in excel format. :

therefore the only way is to create in everything and for all a template equal to that of the customer in excel and see if it also converts images and all set ups of the heights/lengths of the cells.

I feared this answer.. :

Thanks for the answer.

 

[MassiVonWeizen]

already the fact that solidworks has a distinct material and a cutting should clarify that the term, to your personal use, does not make any sense.
inserting images into the solidworks' distinct is the first time I feel it and I think it is impossible not being conceived for that purpose.
settling of cells must be done according to the template that is used for export

 

[Dum]

It won't make sense, but the acronym diba is not that I invented it. :

the need for the image is not my whim is a necessity that comes to follow the master of the customer.

I think it's not possible from sw.
I hoped that there existed (and that someone knew about it) a way to bind excel cells to custom sw properties.
I admit I know very little excel, but I saw him manage formulas and connections between different systems, I hoped to be able to automate everything.

I will continue with ctrl+c ctrl+v

 

[New Rider]

It won't make sense, but the acronym diba is not that I invented it. :

the need for the image is not my whim is a necessity that comes to follow the master of the customer.

I think it's not possible from sw.
I hoped that there existed (and that someone knew about it) a way to bind excel cells to custom sw properties.
I admit I know very little excel, but I saw him manage formulas and connections between different systems, I hoped to be able to automate everything.

I will continue with ctrl+c ctrl+v

I was also looking for a method to tie the excel with the distinct creating solidworks.
In order to avoid copying/paste, you can save the diba that creates solidworks and save it in xls.
Once saved, you'll have to go fix it. such diba in xls. is not connected to solidworks. so if you change material/quantity/etc. the xls does not update.

 

[Dum]

I knew it was not connected, but believe me that it would be the least of the evils
I'd save me half an hour apart. .
I already convert them to xls, but I still have to copy each cell of the converted file to the customer's master file.

in the world of fairy tales that I would like to, I would have liked to be able to create an excel file identical to the customer master, in whose cells I put the link of custom properties (like the work that is done for the carts).
then digest that sw master so that the conversion into excel made it pointing the various values in custom properties.
it does not seem so impossible as a speech, but unfortunately on the guide I did not find any indication and excel the "mastic" little.

 

[New Rider]

I knew it was not connected, but believe me that it would be the least of the evils
I'd save me half an hour apart. .
I already convert them to xls, but I still have to copy each cell of the converted file to the customer's master file.

in the world of fairy tales that I would like to, I would have liked to be able to create an excel file identical to the customer master, in whose cells I put the link of custom properties (like the work that is done for the carts).
then digest that sw master so that the conversion into excel made it pointing the various values in custom properties.not so impossible as a speech, but unfortunately on the guide I did not find any indication and excel the "mastic" little.

They wouldn't sell pdm anymore. :

 

[Dum]

I'm struggling to pay my license...

 

[teseo]

queste cose secondo me sono da macro...provate con jennuary....ora secondo me mi uccide ciao.

ciao

 

[Dum]

Here.
for 10 years I say that I should try to understand how to do (and above all what can be done that I know that I am severaleparecchieassai) to plan a macro. :

 

[jenuary]

...theseo...theseo...
the automatic connection with a excel sheet in my opinion is feasible, obviously with macro, but it is not the cleanest thing to do.
to do this we should do the opposite, that is to create the distinct directly from the sheet, passing it the list of components and properties to read.
two buttons in the excel file allow
- to choose the components or add them in case the distinction has already been compiled once
- to update the distinct

This does not mean that I have to open components in solidworks, but you can work with the swdocumentmanager library that allows you to read within the files even without having solidworks installed in the pc (as swexplorer).

It is usually what dum asks, but it is not a clean thing even if programmable from vba of excel, rather I would make a macro of solidworks to which I pass the excel file to update, or a macro that exports the distinct being able to overwrite even the existing one.
I have done so much of all the colors that I no longer know what is right, everyone has their own ideas and needs.

 

[Dum]

Thank you.
but I appreciate the attempt.

However, I have a few words to google to try to find guides to get into the world of macros and vbas. :

 

[jenuary]

I doubt you find something good,
in the manual bees of solidworks there is everything, but it must be understood.
There has never been much at the level of books, but find many examples on google, that is.