Web I Report - Export to Excel

[former_member648413]

Hi All,

I am trying to export my huge data set to an Excel file. It created 2 tabs. However, I do not see column headers on the second tab. Is there a way to populate the column headers? I am trying to use this file within Tableau as the source and then Union 2 data sets.

Let me know if there is an option to populate the column headers in the 2nd tab which I am missing.

Thanks,

Amritha.

[MichaelGrackin]

That's a large Excel file. Are you using the XLSX output format? (not XLS). XLSX supports 1,048,576 rows so if you are not using XLSX I recommend using this format which might be able to fit all your data on a single tab.

I do not know how to get the headers on the second tab. MAYBE try setting the "repeat headers on every page" for the table holding the data.

[former_member648413]

I am using Microsoft Excel option. I dont see xls or xlsx. Let me know.

[MichaelGrackin]

What version of BusinessObjects are you using? Are you exporting manually while viewing the document? You should have the option to export as XLSX or XLS if manually exporting. There is only one Excel option (XLSX) when scheduling the document.

[former_member648413]

Yes, I am using 4.3 SP00. I am scheduling the report not manually exporting it. If i set up "Repeat Headers on Every page" , would my data not mess up on the excel sheet. I just want the headers to show up only in the second tab after exporting it i.e. after 1,048,576 rows. Let me know ..

[MichaelGrackin]

I do not have a data set large enough to test it so I am only guessing that this would fix the issue. I don't think it will put multiple header lines in the Excel file/tab but you will have to try it.

[MichaelGrackin]

I just did some testing using the old XLS format to force an Excel file with multiple tabs. The "Repeat Header on Every Page" did not resolve the issue. This may be something to discuss with SAP. I do not see a way to make it repeat the headers if it needs to create another tab in the Excel file.

[former_member648413]

Yes, I tried it too. It did not work. I have two tables in the report. I tried to export it via CSV / Text , only first table columns populate. Second table columns are not showing up even when i kept side by side.. Is there anything that i can do to get all the columns?

Thanks Mike.