Format file excel export nomenclature

Out of category
1

Hi everyone

I'm having a problem between my Solidworks BOMs and the BOMs exported in XLSX.

Here are some of the values in my Solidworks BOMs :

image
image692×1463 63.1 KB

And here's what I get in Excel :

image
image282×1135 28.3 KB

The excel export is done with " custom" cell properties transforming certain values into dates.

However, I have modified my options in excel as follows :

image
image995×321 30.3 KB

But the format of the cells must be done when exporting in XLSX from solidworks because despite the modified excel options, the XLSX files remain with a date format on some cells.

Does anyone have an idea of what to modify or do to obtain an excel file identical to the solidworks nomenclature?

Thank you very much.

2

Hello

Try to go through a csv export that you import back into Excel. You should be able to better control the parameters of each column (at least in Excel 365 you can).

1 Like
3

Thank you @froussel

It does work :+1:

We have a development that unfortunately only manages excel and we generate a lot of nomenclatures...
So I'll see about another solution or to automatically convert CSV to XSLX.

4

Hello
It is indeed the Solidworks record function from a table-based BOM that does this.
Without going through exports/imports, there are still macros, so the formatting of cells can be done on the fly to avoid the transformation into a date or the deletion of the 0s on the left.