topic Re: Save a Table file to Excel in 3D Part & Assembly Design

Export a Table to Excel?

ptc-3106393 — Sat, 05 May 2018 11:17:08 GMT

Hello, I have a really urgent need about this subject: How can I export a table in ProE to a Excel file? I know how to export a table to a Text file, but not to Excel. I work at Schneider Electric on ProE WF2. Sorry for the mistakes I'm French (but my licence is in English). My

Export table file to Excel

AnthonyHoward — Tue, 02 Feb 2010 07:50:03 GMT

Hi Sylvain. It is possible to export a csv file from Pro/E. This can be imported into Excel. When opening the file in Excel, chose 'delimited' in step 1 and 'comma' in step 2. We are using Wildfire 4, hopefully Wildfire 2 also has this export option.

RE: Export table file to Excel

ptc-3106393 — Tue, 02 Feb 2010 09:53:17 GMT

Thanks, but I have a problem: I don't find the export option for .csv file I've just found "table file" and "text file" by selecting the table, and clicking on "table" > "save table". Where do you click to find the export of a .csv file?

Re: Export table file to Excel

ptc-3106393 — Tue, 02 Feb 2010 09:56:20 GMT

"Anthony Howard" wrote:

We are using Wildfire 4, hopefully Wildfire 2 also has this export option.

Export a Table to Excel

AnthonyHoward — Tue, 02 Feb 2010 10:16:47 GMT

It sounds like you dont have the option. It's in the same place as 'As Table File' and 'As Text File' (Table>Save Table>As CSV File).[/img]

RE: Export a Table to Excel

ptc-3106393 — Tue, 02 Feb 2010 10:35:47 GMT

Ok, you're right, I don't have this option... I will try to resolve it with the exportation of a text file. Thank you for helping me I've just found another problem: when I export a text file, ProE create a Versionned file like this: *.txt.1 That is a little restrictive for the macro in Excel which will import this file. Do you have an idea for delete automatically the version extension? Thanks

Save a Table file to Excel

AnthonyHoward — Tue, 02 Feb 2010 10:46:21 GMT

Sorry, I can't see an option for automatically leaving the .1 off the end of the filename.

Re: Save a Table file to Excel

PhilSmith — Sun, 11 Feb 2018 07:35:16 GMT

To get the.1 off just rename the file without the .1

Re: Save a Table file to Excel

dsell — Tue, 13 Feb 2018 01:32:10 GMT

your IT department has to make it so you can see it. It is not a creo option

Re: Save a Table file to Excel

PhilSmith — Tue, 13 Feb 2018 01:57:32 GMT

I do it all the time. It's a windows function. Click on the file name in explorer and right click "rename" then take off the.1 at the end and enter..............done. Then do to a new excel and click file open and browse to the file. You man have to play around with the columns bringing it in. Too bad the excel sheet does not update when you change things in pro/e, with it did.