importing spreadsheet to drafting table
importing spreadsheet to drafting table
(OP)
Hi
I have problem with importing data stored in excel file to a table in drafting. I have a spreadsheet containing around 50 rows and 6 columns in excel, when I'm trying to import it to a table instead of getting one 6 x 50 table I have 10 tables and information from my spreadsheet is divided between them :/. What is more NX is creating additional drawing sheets, each one of them is containing a part of the table. Anyone knows what may be the problem here?
I have problem with importing data stored in excel file to a table in drafting. I have a spreadsheet containing around 50 rows and 6 columns in excel, when I'm trying to import it to a table instead of getting one 6 x 50 table I have 10 tables and information from my spreadsheet is divided between them :/. What is more NX is creating additional drawing sheets, each one of them is containing a part of the table. Anyone knows what may be the problem here?





RE: importing spreadsheet to drafting table
When you create the original table object, before importing the spreadsheet data, stop and select the table, press MB3 and select the 'Style' option. When the dialog comes up you'll find a setting that determines the 'Maximum Height'. What I suspect is happening is that with 50 roes of data you're exceeding the this value so the software is creating multiple tables to accommodate your 50 rows of data. Note that this height value is in the units of your drawing so just set it to something large enough so that all the rows fit.
John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Digital Factory
Cypress, CA
Siemens PLM:
UG/NX Museum:
To an Engineer, the glass is twice as big as it needs to be.