Exporting to Excel

building reports desktopintelligence
1

How do I export a report to excel ? Not using the view then export option, because the detail contains too many records. I want the summarized report exported to excel. Your input would be appreciated.

Thanks much,
Angela White-Parker
Sempra Energy

Listserv Archives (BOB member since 2002-06-25)

2

You can go to the summarized report and then hit File…Save As… and save it as a text file and then open in Excel.

Maria D. Carter
BusinessObjects Administrator
(336) 286-1860
mcarter@vcela.com

From: White-Parker, Angela - TPAWP [SMTP:awparker@PACENT.COM] Sent: Tuesday, June 02, 1998 1:18 AM

How do I export a report to excel ? Not using the view then export option, because the detail contains too many records. I want the summarized report exported to excel. Your input would be appreciated.

Thanks much,
Angela White-Parker
Sempra Energy

Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
For old 3.1 info:
Penn: Page not found
Search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’

Listserv Archives (BOB member since 2002-06-25)

3

Angela,
You can do a copy all and paste into Excel. You lose formating but it keeps the columns and rows for you.

Brian Peterson
Manager - Braun Technology Group

How do I export a report to excel ? Not using the view then export option, because the detail contains too many records. I want the summarized report exported to excel. Your input would be appreciated.

Thanks much,
Angela White-Parker
Sempra Energy

Listserv Archives (BOB member since 2002-06-25)

4

How do I export a report to excel ? Not using the view then export option, because the detail contains too many records. I want the summarized report exported to excel. Your input would be appreciated.

You can also export with copy-paste, by choosing Edit|Copy All, which preserves the local aggregations and calculations.

HTH,
Harri Kinnunen
Consultant
Enator Group Oy, Finland

Thanks much,
Angela White-Parker
Sempra Energy

Listserv Archives (BOB member since 2002-06-25)

5

Although I prefer the copy all -> past solution best, there is another way. You can save a report as HTML and then open it up with Excel 97. I know this is not ideal, but I thought I’d share it anyway.

Steve Krandel
Reminder: Business Objects International User Conference * August 30 to September 2 * Lake Buena Vista, Florida

Listserv Archives (BOB member since 2002-06-25)

6

Angela,
How do I export a report to excel ? Not using the view then export
option, because the detail contains too many records. I want the summarized report exported to excel. Your input would be appreciated.

If you have a lot of data to copy, Using >>File>>Save As .txt will work better.
Also, as a note, if you do all your formatting of data in BusinessObjects, you can essentially have your layout complete when you open up the .txt file in excel. All the data must be in the same block (tabular or Crosstab). The top left cell in the block will be converted to cell A1 (if there isn’t any free form cells above the block). The rest of the cells in the table will flow accordingly. ed

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=
Edward P.K. Aw
Client Site Training Manager
BASE Consulting Group, LLC
510 - 466 - 5139 Voicemail
408 - 815 - 2196 Pager
eaw@baseconsulting.com
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=

Listserv Archives (BOB member since 2002-06-25)

7

I am sorry this has probably been asked before. If you try and export an object to Excel that has a special character in the name, the export fails. However I thought BusinessObjects had done something to get around this problem - like renaming the columns in the spreadsheet to use underscores for all special characters. I am using 4.1.3. Does anyone know anything about this? Am I all wet?

Greg Mills
Conoco Inc.
(580) 767-5597 ETN 442-5597
s-greg.mills@usa.conoco.com

Listserv Archives (BOB member since 2002-06-25)

8

X-cc: S-GREG.MILLS@usa.conoco.com

Greg,

Still a problem in 4.1.3…

Tim Heuer
PacifiCare Health Systems
(714) 825-5702
(800) 759-8888 pin 1251901 - pager
tim.heuer@phs.com

I am sorry this has probably been asked before. If you try and export an object to Excel that has a special character in the name, the export fails. However I thought BusinessObjects had done something to get around this problem - like renaming the columns in the spreadsheet to use underscores for all special characters. I am using 4.1.3. Does anyone know anything about this? Am I all wet?

Listserv Archives (BOB member since 2002-06-25)

9

I’ve found that this has not been fixed for all special characters. It was supposed
to be fixed with v4.1.3. Maybe next time.

Tim Rodine
trodine@tcrsolutions.com

Mills, S. Greg wrote:

I am sorry this has probably been asked before. If you try and export an object to Excel that has a special character in the name, the export fails. However I thought BusinessObjects had done something to get around this problem - like renaming the columns in the spreadsheet to use underscores for all special characters. I am using 4.1.3. Does anyone know anything about this? Am I all wet?

Listserv Archives (BOB member since 2002-06-25)

10

From the release notes from the 4.1.3 cd-rom:

Vantive case AP22506 Bug Number 22268
When exporting to Excel a data provider with special characters like # in the column name, you may get a syntax error in the field definition. There are no longer any problems with the following special characters: #, ., /, , ', _, (, ), {, }, +, ", $. They are changed to - (under line).

And yes, Greg, you are all wet…

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

In a message dated 98-09-30 18:27:32 EDT, you write:

I’ve found that this has not been fixed for all special characters. It was
supposed
to be fixed with v4.1.3. Maybe next time.

Tim Rodine
trodine@tcrsolutions.com

Mills, S. Greg wrote:

I am sorry this has probably been asked before. If you try and export an object to Excel that has a special character in the name, the export fails. However I thought BusinessObjects had done something to get around this problem - like renaming the columns in the spreadsheet to use underscores for all special characters. I am using 4.1.3. Does anyone know anything about this? Am I all wet?

Listserv Archives (BOB member since 2002-06-25)

11

Thanks for the help everyone.

Greg Mills
Conoco Inc.
(580) 767-5597 ETN 442-5597
s-greg.mills@usa.conoco.com

Listserv Archives (BOB member since 2002-06-25)

12

Hi,
If you don’t want to use macro for this then you may want to take a look at the Business Query product of BO, it is an add-in for excel and can be used to generate reports with the BO format and then the data can be used in excel.

Hope this helps…

Thanks
Amit Agarwal
Saama Technologies
408-371-1900

Right now if you export to Excel you get just a plain list of column. Is there a way that you can have the data in Excel formatted such as the report
looks without writing a MACRO.

thanks,
joe

_________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx

Listserv Archives (BOB member since 2002-06-25)

13

Right now if you export to Excel you get just a plain list of column. Is there a way that you can have the data in Excel formatted such as the report looks without writing a MACRO.

thanks,
joe

Listserv Archives (BOB member since 2002-06-25)

14

From the menu select edit, and then copy all, Paste into Excel, it should
keep the report format.

Hope this helps
Karen

From: Toscano, Joseph [SMTP:Joseph.Toscano@CHURCHDWIGHT.COM] Sent: 19 December 2001 16:29

Right now if you export to Excel you get just a plain list of column. Is there a way that you can have the data in Excel formatted such as the report
looks without writing a MACRO.

thanks,
joe

BUSOB-L BOTTOM BANNER (please delete this in your replies to the list) Subscription/vacation options, write to LISTSERV@LISTSERV.AOL.COM:

This electronic mail system is used for information purposes and is not intended to form any legal contract or binding agreement. The content is confidential and may be legally privileged. Access by anyone other than the addressee(s) is unauthorised and any disclosure, copying, distribution or any other action taken in reliance on it is prohibited and maybe unlawful ********************************************************************************

Listserv Archives (BOB member since 2002-06-25)

15

This probably an ugly solution, but it works, somewhat. What I do is File-Save As HTML, then open the report in my browser. Press Ctrl-A to select all. Then CTRL-C to copy. Then I go to Excel and paste. The format doesn’t copy perfectly, but it does retain much of the formatting. I hope this helps.

Michael Welter
Webi Administrator
949-286-6734
Verizon Wireless

Listserv Archives (BOB member since 2002-06-25)

16

Paste and copy from HTML file does not work well for large reports.

There is a company out there that offers an enhancement to webi (forgot the name…anyone else remember?); their product installs on the webi server and adds a button “Save as Excel spreadsheet” preserving the format of the original report) to WEBi.

Andreas

Listserv Archives (BOB member since 2002-06-25)

17

Andreas:
You shouldn’t have to do a copy and past from the HTML file. You should be able to open the HTML file in Excel. Open Excel, then open the HTML file from Excel. This should retain all the formatting but you will have to unmerge some cells to work with the file.

Kathy Mahler
Stanford University

At 11:46 AM 12/19/2001 -0500, you wrote:

Paste and copy from HTML file does not work well for large reports.

There is a company out there that offers an enhancement to webi (forgot the name…anyone else remember?); their product installs on the webi server and adds a button “Save as Excel spreadsheet” preserving the format of the original report) to WEBi.

Andreas

Right now if you export to Excel you get just a plain list of column. Is there a way that you can have the data in Excel formatted such as the report
looks without writing a MACRO.

Listserv Archives (BOB member since 2002-06-25)

18

May not be the one you are thinking of but Infoosol is the one I remember. http://www.infosol.com/bi/techtips/bo_tt17.html check this site

Listserv Archives (BOB member since 2002-06-25)