|
View previous topic :: View next topic
|
| Author |
Message |
Robert Isaac
Joined: 21 Apr 2004
Posts: 17
Location: Chicago, IL
|
 Posted: Fri Jun 18, 2004 5:48 am Post subject: Excel Spreadsheets |
    |
|
I'm having problems getting formatted spreadsheet info into PowerCADD
(schedules, etc.)
I'm running the latest and greatest of everything.
When I do a Paste Special, the information is pasted into a single long line of text unformatted.
Any help wpuld be appreciated
Bob |
|
| Back to top |
|
 |
Mike C
Joined: 15 Apr 2004
Posts: 119
Location: Greensboro, NC
|
| Posted: Fri Jun 18, 2004 6:24 am Post subject: |
|
|
Bob,
You need to copy as a picture from Excel. Hold down the Shift key while accessing the Edit menu in Excel and you will get a dialog with settings of how to copy.
Mike Cleveland
ES |
|
| Back to top |
|
|
JohnMorse
Joined: 14 Apr 2004
Posts: 291
Location: Birmingham, AL
|
| Posted: Fri Jun 18, 2004 6:31 am Post subject: |
|
|
| This might not pertain to what you need to do with the spreadsheet in PowerCADD, but for most of the schedules that I insert into drawings, I just print to PDF from Excel and place the PDF in PowerCADD. That forces me to update the actual spreadsheet instead of letting obsolete excel files inhabit my job folders and also saves any trouble "fixing" formatting casualties during translation. |
|
| Back to top |
|
|
huc
Joined: 13 Apr 2004
Posts: 660
Location: ::caddpower.com:: (Aurora, CO)
|
| Posted: Fri Jun 18, 2004 7:36 am Post subject: Re: Excel Spreadsheets |
|
|
| Robert Isaac wrote: | | I'm having problems getting formatted spreadsheet info into PowerCADD |
Bob,
As MikeC noted, Copy picture works, here is a caddpower.com article which describes the process in detail. It breaks the process into two stages (stage one is where you'd likely stop) as the article discusses converting the data to real editable objects for export via dwg or dxf.
The alternative is to print to pdf, then place the pdf in PowerCADD
Cheers
Brian |
|
| Back to top |
|
|
Robert Isaac
Joined: 21 Apr 2004
Posts: 17
Location: Chicago, IL
|
| Posted: Fri Jun 18, 2004 8:04 am Post subject: Thanks |
|
|
Thanks My Brotha's
I am now spreadsheet capable
Bob |
|
| Back to top |
|
|
Jeffrey Jakucyk
Joined: 15 Apr 2004
Posts: 100
Location: Cincinnati, OH
|
| Posted: Fri Jun 18, 2004 10:26 am Post subject: |
|
|
I recently had great success getting an Excel formatted document into PowerCADD. The hitch is that you need Adobe Illustrator to do it.
1. Set the page setup for the Excel file so that it will print on only one page. In my case, I had to use a 36x48 sheet, since if it scales the text down too much it will mess up the text kerning.
2. Save a PDF of the Excel file using the Print command.
3. Open the PDF file in Illustrator and export it as an AutoCAD DWG or DXF file.
4. Open the DWG or DXF file in PowerCADD* and ungroup/group any of the text as necessary.
This technique preserves the text formatting, and it's turned into normal PowerCADD text that you can edit however you want. This process creates some odd groups, but I normally just ungroup everything and then rearrange it as I want. Text color doesn't come through, although underlined text will show the correct color, but the underlining itself becomes a line object. Italics and different fonts do not come through either, as it all appears to be converted to Arial, but font size and positioning is preserved.
*Note that only PowerCADD 6 can import DWG or DXF files from Illustrator. |
|
| Back to top |
|
|
|
blogger
del.icio.us
digg
slashdot
