AutoCAD Electrical Forum
Welcome to Autodesk’s AutoCAD Electrical Forums. Share your knowledge, ask questions, and explore popular AutoCAD Electrical topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

"spreadsheet to table" not working

14 REPLIES 14
Reply
Message 1 of 15
Anonymous
365 Views, 14 Replies

"spreadsheet to table" not working

I have been using the "insert spreadsheet data to table" command since the via wd days. It was always a guessing game as to what the table would look like when I was done. I could always go back and re-insert the table using different text heights etc. to achieve the look I was after because it only took a couple of seconds to re-insert the table. With electrical 2006, it now takes 2 to 3 minutes for a table to insert and then another 2 to 3 minutes for the insert dialog box to reappear. When the table finally does appear there is way too much margin space above and below the text and there seems to be no way of adjusting for it now, or at least it is not working for me. I am on my second install of 2006 because of plotting issues from an apparent bad first install. This table problem was an issue in both installs. What happened to this command between 2005 and 2006, and what do I have to do to work around this? P.S. I have'nt changed my report format in excel since the wd days, so this shouldn't cause the margin issue.
14 REPLIES 14
Message 2 of 15
Anonymous
in reply to: Anonymous

The report tables use the AutoCAD table object. A Tablestyle is created for
the report tables based on the Standard table style. You can set up this
Tablestyle on your drawing before creating your report tables or on the
template used for creating new drawings. If the tables already exist then
you would look at the table properties to see its tablestyle name and modify
that tablestyle. Or you can modifiy the properties of the table itself to
modify just one table object.

As far as the speed issue I haven't seen this reported previously. Are they
very large tables containing a lot of data?

Pat Murnen


wrote in message news:5036229@discussion.autodesk.com...
I have been using the "insert spreadsheet data to table" command since the
via wd days. It was always a guessing game as to what the table would look
like when I was done. I could always go back and re-insert the table using
different text heights etc. to achieve the look I was after because it only
took a couple of seconds to re-insert the table. With electrical 2006, it
now takes 2 to 3 minutes for a table to insert and then another 2 to 3
minutes for the insert dialog box to reappear. When the table finally does
appear there is way too much margin space above and below the text and there
seems to be no way of adjusting for it now, or at least it is not working
for me. I am on my second install of 2006 because of plotting issues from an
apparent bad first install. This table problem was an issue in both
installs. What happened to this command between 2005 and 2006, and what do I
have to do to work around this? P.S. I have'nt changed my report format in
excel since the wd days, so this shouldn't cause the margin issue.
Message 3 of 15
Anonymous
in reply to: Anonymous

No, the xls file is actually very small. I tried to use the demoplc.xls file that's included with the program, and it too took about 5 minutes to insert, not to mention another 3 or 4 minutes after the insertion for the dialog box to reappear as it normally does. As I noted earlier, this is the second install, and both the installs had this behavior.
Message 4 of 15
DStitz
in reply to: Anonymous

Do you meet the minimum system requirements? (link below)

http://usa.autodesk.com/adsk/servlet/index?siteID=123112&id=5148577
Message 5 of 15
Anonymous
in reply to: Anonymous

YES
Message 6 of 15
Anonymous
in reply to: Anonymous

I'm afraid I don't have an explanation for the slow speed. I can insert the
demoplc.xls as a table in a couple seconds. If you post your hardware,
operating system, and version of AcadE I can pass it along to someone who
could try and reproduce this.

Pat Murnen


wrote in message news:5037208@discussion.autodesk.com...
YES
Message 7 of 15
Anonymous
in reply to: Anonymous

AUTOCAD 2006 SP2A, PENTIUM 3, 1 GHZ, 512 MB RAM, 20 GIG+ FREE DISK SPACE. I have been able to reproduce this problem over and over again. I even tried the demoplc.xls file that is included with 2006. Try this on your computer and see if you can reproduce it. Pick a drawing out of a project and try to insert demoplc.xls, for me this works correctly the very first time after starting autocad. Now open a second drawing out of the same project and try to insert it again, or any other spreadsheet. this is where it all slows to a snails pace for me. the second insert after rebooting and starting autocad always slows down drastically or causes the computer to hang.
Message 8 of 15
Anonymous
in reply to: Anonymous

p.s. operating system is xp professional version 2002 sp1 with all the latest updates as of dec. 13 2005
Message 9 of 15
DStitz
in reply to: Anonymous

I have reproduced this, but cannot explain WHY it does this.
(I'm just another user)

As you stated, I pasted in the table from spreadsheet on one drawing ... saved it ... went to another drawing in the active project ... then tried to put the same spreadsheet to table into the drawing with frustrating results.

I exploded the table on the first drawing and could then paste the spreadsheet again on another drawing.

Anyone have any ideas???
Message 10 of 15
DStitz
in reply to: Anonymous

I tried posting the second time with out exploding the first table and it is UPDATING the first drawing form the spreadsheet. Maybe that is what it is trying to do in the background when you are locking up.

Also check if you are in SDI mode .... seems that a number of the functions work better with SDI mode turned off (SDI=0).
Message 11 of 15
Anonymous
in reply to: Anonymous

I do not see the speed issue that you describe. But from the other postings
in this thread I think that the problem is related to AcadE thinking you are
running the same "report" and trying to update the existing table instead of
inserting a new table the second time.

Report tables carry some intelligence so that AcadE can determine if a table
should be updated when a report is rerun. In this case it is incorrectly
determining that the table should be updated. This is a known issue. There
is a workaround that will keep AcadE from seeing the intelligence on the
table. You can use the xdata editor supplied with AcadE and remove the xdata
ACE_TABLE_TYPE. This should cause AcadE to ignore this table and not update
it.

If this was not the issue, let me know.
Pat Murnen


wrote in message news:5037332@discussion.autodesk.com...
AUTOCAD 2006 SP2A, PENTIUM 3, 1 GHZ, 512 MB RAM, 20 GIG+ FREE DISK SPACE. I
have been able to reproduce this problem over and over again. I even tried
the demoplc.xls file that is included with 2006. Try this on your computer
and see if you can reproduce it. Pick a drawing out of a project and try to
insert demoplc.xls, for me this works correctly the very first time after
starting autocad. Now open a second drawing out of the same project and try
to insert it again, or any other spreadsheet. this is where it all slows to
a snails pace for me. the second insert after rebooting and starting autocad
always slows down drastically or causes the computer to hang.
Message 12 of 15
Anonymous
in reply to: Anonymous

I tried moving the project from our network drive to my local machine and the problems went away. Try running your entire project from a network drive and see if you can recreate this. I have also noticed a link between the names of the project vs. drawings vs. spreadsheet. My projects would have a naming convention such as PROJECT_A.WDP and drawings named PROJECT_A_1.DWG and a spreadsheet named PROJECT_A.XLS. This naming convention seems to cause errors when I go to insert the spreadsheet. If I change the name of the spreadsheet to something else, then the errors go away. Any help would be appreciated as it is a pain to have to move projects back and forth from the network to my local drive.
Message 13 of 15
jmburge
in reply to: Anonymous

I am experiencing a similar problem. I run ACE 2006 SP2a on WinXP Pro SP2 Pentium 4 2 GHZ processor with 1.5 GB ram.

When I manually insert a table ("Table" at command prompt), ACE bogs down after I enter text in a cell. Could this be related?

-John Burgess
Message 14 of 15
Anonymous
in reply to: Anonymous

This is also a symptom that I face each time I try to edit or enter cell text. I don't have to face it that often because I usually use the "insert spreadsheet data to table" command and I edit the spreadsheet instead of the table itself, but when I do need to edit the cell, it can be a long drawn out process.
Message 15 of 15
Anonymous
in reply to: Anonymous

Can you send me a drawing and the exact commands and steps you are using
(the more detail the better)? I can then pass this along to the appropriate
people as it sounds like it might be a table object issue and possibly not
an AcadE report table issue.

If you want to send me the drawing directly my email is
pat.murnen@autodesk.com.

Pat Murnen

wrote in message news:5049706@discussion.autodesk.com...
This is also a symptom that I face each time I try to edit or enter cell
text. I don't have to face it that often because I usually use the "insert
spreadsheet data to table" command and I edit the spreadsheet instead of the
table itself, but when I do need to edit the cell, it can be a long drawn
out process.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost