More output-to-Excel frustration
Locked
More output-to-Excel frustration
 
|
Hello All:
Regardless of whether I go through the File-->Export-->Excel -->Document route or run one of the ExporttoExcel scripts (Thanks to R. Leveque for those great contributions, by the way), the charts do not go into Excel (the tables go in fine, but nothing happens with the charts). If I use File-->Export-->Excel-->Charts Only, the charts end up as jpegs in the directory, not in Excel. The scripts all run fine with the pivot tables (except for data loss, which is annoying), but when each chart is selected by the script, an error message pops up from Sax Basic: 10091ActiveX Automation: no such property or method. I am running WXP with SP2, SPSS 14.0.2, Excel 2000, lotsa memory, etc. If I recall correctly, the scripts all ran fine with SPSS 13. Example of data loss: ID 123456 should only have 1, 2, Total. The following 1, 2, 3, Total belong to another ID that has disappeared. This happens in every instance where an ID does not have all categories (i.e. 1, 2, 3, Total) associated with it. 123456 2 99.30899 3 92.32035 Total 96.97211 1 95.72808 2 71.87541 3 58.40051 Total 90.80941 Another annoyance is that IDs copy into Excel with commas, so instead of the ID being 123456, it shows as 123,456 or even 123,456.00. With lots of tables, with IDs in different columns, this takes a LOT of time to clean up. Any suggestions to enable getting the output into Excel would be appreciated. I have used the viewer-html-Excel route, but then the jpegs for the charts have to accompany the Excel file, which is a pain when i have dozens and dozens of charts. Control-K doesn't work for any more than 1 chart. Thanks in advance for any help. Mike |
Re: More output-to-Excel frustration
|
|
AFAIK, exporting charts to Excel has never been supported. The Export Output help topic says: "Charts are not included in Excel documents."
You can, however, copy and paste charts into Excel -- and if you export tables and charts to Word you can also copy and paste the entire contents of the Word document into Excel; so there may be some programmatic workaround using VBA methods in MS Office. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mike Marshall Sent: Thursday, January 11, 2007 5:19 PM To: [hidden email] Subject: More output-to-Excel frustration Hello All: Regardless of whether I go through the File-->Export-->Excel -->Document route or run one of the ExporttoExcel scripts (Thanks to R. Leveque for those great contributions, by the way), the charts do not go into Excel (the tables go in fine, but nothing happens with the charts). If I use File-->Export-->Excel-->Charts Only, the charts end up as jpegs in the directory, not in Excel. The scripts all run fine with the pivot tables (except for data loss, which is annoying), but when each chart is selected by the script, an error message pops up from Sax Basic: 10091ActiveX Automation: no such property or method. I am running WXP with SP2, SPSS 14.0.2, Excel 2000, lotsa memory, etc. If I recall correctly, the scripts all ran fine with SPSS 13. Example of data loss: ID 123456 should only have 1, 2, Total. The following 1, 2, 3, Total belong to another ID that has disappeared. This happens in every instance where an ID does not have all categories (i.e. 1, 2, 3, Total) associated with it. 123456 2 99.30899 3 92.32035 Total 96.97211 1 95.72808 2 71.87541 3 58.40051 Total 90.80941 Another annoyance is that IDs copy into Excel with commas, so instead of the ID being 123456, it shows as 123,456 or even 123,456.00. With lots of tables, with IDs in different columns, this takes a LOT of time to clean up. Any suggestions to enable getting the output into Excel would be appreciated. I have used the viewer-html-Excel route, but then the jpegs for the charts have to accompany the Excel file, which is a pain when i have dozens and dozens of charts. Control-K doesn't work for any more than 1 chart. Thanks in advance for any help. Mike |
|
|
I do have a script for exporting charts to Excel... got to findt it
----- Original Message ----- From: "Oliver, Richard" <[hidden email]> To: <[hidden email]> Sent: Thursday, January 11, 2007 10:03 PM Subject: Re: More output-to-Excel frustration > AFAIK, exporting charts to Excel has never been supported. The Export > Output help topic says: "Charts are not included in Excel documents." > > You can, however, copy and paste charts into Excel -- and if you export > tables and charts to Word you can also copy and paste the entire contents > of the Word document into Excel; so there may be some programmatic > workaround using VBA methods in MS Office. > > -----Original Message----- > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of > Mike Marshall > Sent: Thursday, January 11, 2007 5:19 PM > To: [hidden email] > Subject: More output-to-Excel frustration > > Hello All: > Regardless of whether I go through the File-->Export-->Excel -->Document > route or run one of the ExporttoExcel scripts (Thanks to R. Leveque for > those great contributions, by the way), the charts do not go into Excel > (the > tables go in fine, but nothing happens with the charts). > If I use File-->Export-->Excel-->Charts Only, the charts end up as jpegs > in > the directory, not in Excel. > > The scripts all run fine with the pivot tables (except for data loss, > which > is annoying), but when each chart is selected by the script, an error > message pops up from Sax Basic: > > 10091ActiveX Automation: no such property or method. > > I am running WXP with SP2, SPSS 14.0.2, Excel 2000, lotsa memory, etc. If > I > recall correctly, the scripts all ran fine with SPSS 13. > > Example of data loss: ID 123456 should only have 1, 2, Total. The > following > 1, 2, 3, Total belong to another ID that has disappeared. This happens in > every instance where an ID does not have all categories (i.e. 1, 2, 3, > Total) associated with it. > > 123456 2 99.30899 > 3 92.32035 > Total 96.97211 > 1 95.72808 > 2 71.87541 > 3 58.40051 > Total 90.80941 > > Another annoyance is that IDs copy into Excel with commas, so instead of > the > ID being 123456, it shows as 123,456 or even 123,456.00. With lots of > tables, with IDs in different columns, this takes a LOT of time to clean > up. > > Any suggestions to enable getting the output into Excel would be > appreciated. I have used the viewer-html-Excel route, but then the jpegs > for > the charts have to accompany the Excel file, which is a pain when i have > dozens and dozens of charts. Control-K doesn't work for any more than 1 > chart. > Thanks in advance for any help. > Mike > |
Re: More output-to-Excel frustration
|
|
In reply to this post by Mike Marshall-2
Excel has such wonderful charts and chart options, it seems to me that
you may be well served to create the charts in Excel. Melissa -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mike Marshall Sent: Thursday, January 11, 2007 5:19 PM To: [hidden email] Subject: [SPSSX-L] More output-to-Excel frustration Hello All: Regardless of whether I go through the File-->Export-->Excel -->Document route or run one of the ExporttoExcel scripts (Thanks to R. Leveque for those great contributions, by the way), the charts do not go into Excel (the tables go in fine, but nothing happens with the charts). If I use File-->Export-->Excel-->Charts Only, the charts end up as jpegs in the directory, not in Excel. The scripts all run fine with the pivot tables (except for data loss, which is annoying), but when each chart is selected by the script, an error message pops up from Sax Basic: 10091ActiveX Automation: no such property or method. I am running WXP with SP2, SPSS 14.0.2, Excel 2000, lotsa memory, etc. If I recall correctly, the scripts all ran fine with SPSS 13. Example of data loss: ID 123456 should only have 1, 2, Total. The following 1, 2, 3, Total belong to another ID that has disappeared. This happens in every instance where an ID does not have all categories (i.e. 1, 2, 3, Total) associated with it. 123456 2 99.30899 3 92.32035 Total 96.97211 1 95.72808 2 71.87541 3 58.40051 Total 90.80941 Another annoyance is that IDs copy into Excel with commas, so instead of the ID being 123456, it shows as 123,456 or even 123,456.00. With lots of tables, with IDs in different columns, this takes a LOT of time to clean up. Any suggestions to enable getting the output into Excel would be appreciated. I have used the viewer-html-Excel route, but then the jpegs for the charts have to accompany the Excel file, which is a pain when i have dozens and dozens of charts. Control-K doesn't work for any more than 1 chart. Thanks in advance for any help. Mike PRIVILEGED AND CONFIDENTIAL INFORMATION This transmittal and any attachments may contain PRIVILEGED AND CONFIDENTIAL information and is intended only for the use of the addressee. If you are not the designated recipient, or an employee or agent authorized to deliver such transmittals to the designated recipient, you are hereby notified that any dissemination, copying or publication of this transmittal is strictly prohibited. If you have received this transmittal in error, please notify us immediately by replying to the sender and delete this copy from your system. You may also call us at (309) 827-6026 for assistance. |
Charting in Excel...Why?
|
|
I would have agreed 3 or 4 years ago. However, SPSS now far exceeds Excel
in both the type of charts available and control of charts. The catch, as always, is knowing how to get SPSS to give you what you want. I used Excel for charting only before SPSS upgraded its chart resolution. My only crticism of SPSS, and this extends to Excel and most other charting platforms is that they still allow 3-d charts. By far the most offensive (obfuscating if not downright deceptive) are those damned 3-d cylinder, pyramid, and cone charts in Excel. My 2-cents worth. Mark *************************************************************************************************************************************************************** Mark A. Davenport Ph.D. Senior Research Analyst Office of Institutional Research The University of North Carolina at Greensboro 336.256.0395 [hidden email] 'An approximate answer to the right question is worth a good deal more than an exact answer to an approximate question.' --a paraphrase of J. W. Tukey (1962) Melissa Ives <[hidden email]> Sent by: "SPSSX(r) Discussion" <[hidden email]> 01/12/2007 09:32 AM Please respond to Melissa Ives <[hidden email]> To [hidden email] cc Subject Re: More output-to-Excel frustration Excel has such wonderful charts and chart options, it seems to me that you may be well served to create the charts in Excel. Melissa |
|
|
Not to mention that I have hundreds of charts. The thought of redoing all of
those in Excel when there are perfectly good ones sitting in the SPSS output is a bit off-putting, especially (as Mark points out) SPSS charts are now just fine for including in reports. I suppose a few VB macros would simplify the Excel route, but I am not particularly good with Visual Basic. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of Mark A Davenport MADAVENP Sent: Friday, January 12, 2007 7:05 AM To: [hidden email] Subject: Charting in Excel...Why? I would have agreed 3 or 4 years ago. However, SPSS now far exceeds Excel in both the type of charts available and control of charts. The catch, as always, is knowing how to get SPSS to give you what you want. I used Excel for charting only before SPSS upgraded its chart resolution. My only crticism of SPSS, and this extends to Excel and most other charting platforms is that they still allow 3-d charts. By far the most offensive (obfuscating if not downright deceptive) are those damned 3-d cylinder, pyramid, and cone charts in Excel. My 2-cents worth. Mark **************************************************************************** **************************************************************************** ******* Mark A. Davenport Ph.D. Senior Research Analyst Office of Institutional Research The University of North Carolina at Greensboro 336.256.0395 [hidden email] 'An approximate answer to the right question is worth a good deal more than an exact answer to an approximate question.' --a paraphrase of J. W. Tukey (1962) Melissa Ives <[hidden email]> Sent by: "SPSSX(r) Discussion" <[hidden email]> 01/12/2007 09:32 AM Please respond to Melissa Ives <[hidden email]> To [hidden email] cc Subject Re: More output-to-Excel frustration Excel has such wonderful charts and chart options, it seems to me that you may be well served to create the charts in Excel. Melissa -------------------------------------------- My mailbox is spam-free with ChoiceMail, the leader in personal and corporate anti-spam solutions. Download your free copy of ChoiceMail from www.digiportal.com |
|
|
Hi
One of my Sax Basic script exports tables and charts to Excel. See file #5 of the Excel section of http://www.spsstools.net/SampleScripts.htm#ImportExport Raynald Levesque [hidden email] Website: www.spsstools.net -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mike Marshall Sent: January 12, 2007 2:28 PM To: [hidden email] Subject: Re: Charting in Excel...Why? Not to mention that I have hundreds of charts. The thought of redoing all of those in Excel when there are perfectly good ones sitting in the SPSS output is a bit off-putting, especially (as Mark points out) SPSS charts are now just fine for including in reports. I suppose a few VB macros would simplify the Excel route, but I am not particularly good with Visual Basic. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of Mark A Davenport MADAVENP Sent: Friday, January 12, 2007 7:05 AM To: [hidden email] Subject: Charting in Excel...Why? I would have agreed 3 or 4 years ago. However, SPSS now far exceeds Excel in both the type of charts available and control of charts. The catch, as always, is knowing how to get SPSS to give you what you want. I used Excel for charting only before SPSS upgraded its chart resolution. My only crticism of SPSS, and this extends to Excel and most other charting platforms is that they still allow 3-d charts. By far the most offensive (obfuscating if not downright deceptive) are those damned 3-d cylinder, pyramid, and cone charts in Excel. My 2-cents worth. Mark **************************************************************************** **************************************************************************** ******* Mark A. Davenport Ph.D. Senior Research Analyst Office of Institutional Research The University of North Carolina at Greensboro 336.256.0395 [hidden email] 'An approximate answer to the right question is worth a good deal more than an exact answer to an approximate question.' --a paraphrase of J. W. Tukey (1962) Melissa Ives <[hidden email]> Sent by: "SPSSX(r) Discussion" <[hidden email]> 01/12/2007 09:32 AM Please respond to Melissa Ives <[hidden email]> To [hidden email] cc Subject Re: More output-to-Excel frustration Excel has such wonderful charts and chart options, it seems to me that you may be well served to create the charts in Excel. Melissa -------------------------------------------- My mailbox is spam-free with ChoiceMail, the leader in personal and corporate anti-spam solutions. Download your free copy of ChoiceMail from www.digiportal.com |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |