Export a Table to Excel?
‎Feb 01, 2010
09:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 01, 2010
09:46 AM
Export a Table to Excel?
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 email: sylvain.ferris[at]fr.schneider-electric.com (replace the [at] by @ please) Thanks
Labels:
- Labels:
-
2D Drawing
9 REPLIES 9
‎Feb 02, 2010
02:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 02, 2010
02:50 AM
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.
‎Feb 02, 2010
04:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 02, 2010
04:53 AM
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?
‎Feb 02, 2010
04:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 02, 2010
04:56 AM
"Anthony Howard" wrote:
We are using Wildfire 4, hopefully Wildfire 2 also has this export option.
‎Feb 02, 2010
05:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 02, 2010
05:16 AM
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]
‎Feb 02, 2010
05:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 02, 2010
05:35 AM
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
‎Feb 02, 2010
05:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 02, 2010
05:46 AM
Sorry, I can't see an option for automatically leaving the .1 off the end of the filename.
‎Feb 11, 2018
02:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 11, 2018
02:35 AM
To get the.1 off just rename the file without the .1
‎Feb 12, 2018
08:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 12, 2018
08:32 PM
your IT department has to make it so you can see it. It is not a creo option
‎Feb 12, 2018
08:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Feb 12, 2018
08:57 PM
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.