Export of BOMs to excel

Out of category
1

Hello

When I export a table bill of materials to excel, the points of my numbering are changed to commas so that when I get to 1.10 the value is set to 1.1 on excel.

Maybe someone with the solution?

Thank you.

 

2

Hello

In Excel: use "replace" (with the search tool under 365): , by .

Otherwise change the decimal sign in excel or solidworks (the option exists in both software). There is probably also a windows option (probably more or less related to the language)

For SW: Tools / options / general / "use the default decimal symbol for dimensions"

 

3

In windows if misconfigured (related to the language):

https://portal.makeitsimple.ch/knowledgebase/63/Windows-10---Parametres-Region-et-langue---Francais-Suisse-avec-le-point-a-la-place-de-la-virgule.html

Otherwise in excel:

https://forums.commentcamarche.net/forum/affich-3636065-format-de-nombre-excel-point-virgule
 

Hoping it helps.

4

Hello 

I finally found the solution;

In the "xlapp. Workbooks.Open "c:\.... xls" it was enough to put: "xlapp. Workbooks.OpenText "c:\.... xls"

Thank you.