How do you save a Business Objects report in an Excel format without losing the formatting? Whenever I open the file in Excel, the formatting that I did in Business Objects is lost?
Listserv Archives (BOB member since 2002-06-25)
Denise,
When you EXPORT to EXCEL, you are exporting the RAW DATA, not the formatted information. Much like any other product, the formatting that is saved is application specific and doesn’t mean much to the other applications. If you want to try to get your ‘formatted report’ over to Excel, you can SAVE the report as a CSV, or RTF and import it to Excel, or you can use the COPY ALL function and PASTE the results in Excel.
Thanks!
-rm
Listserv Archives (BOB member since 2002-06-25)
<<How do you save a Business Objects report in an Excel format without losing
<<the formatting? Whenever I open the file in Excel, the formatting that I
<<did in Business Objects is lost?
Denise,
try the below script. It’s exporting all your reports in the bo file as textfiles to c:\ . Which will keep own columns, sums, etc. You can then open the file in excel and press “finish” on the import wizard. Another good way is to use BOQuery. That’s the excel add-in for bo.
Hope that helps,
Mathias
Sub Main
dim BO_Report as BOReport
dim dp as BODataProvider
dim i as Integer
dim filenames
For i = 1 to ActiveDocument.Reports.Count
Set BO_Report = ActiveDocument.Reports.Item(i) BO_Report.ExportAsText(“c:”+BO_Report)
filenames = filenames + BO_Report+".txt," next i
Begin Dialog lastdlg 320, 120
OkButton 110, 100, 50, 14
Text 13, 30, 300, 70, “C:\DATA”+filenames+" ."
End Dialog
Dim dlgEnd As lastdlg
Dim lstAnswer As Integer
lstAnswer = Dialog ( dlgEnd )
End Sub
Listserv Archives (BOB member since 2002-06-25)