Blank Row/Column removal when exporting to Excel

building reports webintelligence
1

Hello All,

When I export a Webi report to MS Excel from either the Knowledge/ Webi Rich Client, I always have a blank Row (A) and Column (1) in the Excel document. By having these blanks, it causes issues with automatically exporting the data from excel into other programs.

Is there a setting within the actaul report which will eliminate this row and column from appearing and place my vertical or horizontal table in cell A1

I do know how to remove the Header and/or Title Block, but have been unsuccessful in my attempts to remove the blank row/column from the report result once imported to Excel.

I appreciate your time in answering this question.

Thanks,

Jason P.

plasj004 (BOB member since 2011-05-09)

2

The blank will be appearing because your table is not positioned at 0,0 on the page.

Select your block. Then go to page layout. Then set it to appear 0 from left and 0 from top. Now when you export your table will begin at cell A1 in Excel.

weaver (BOB member since 2008-10-17)

3

Weaver - Thank you!, that worked perfectly…my previous attempts had been limited to adjusting the position of the entire document/report instead of the block.

Thanks again for your advice!

plasj004 (BOB member since 2011-05-09)

4

Jason,

Please note that BO saves the report as an Excel-formatted file, not an Excel file outright. As such, you’ve seen one of the problems. Another one for you to avoid is splitting/merging cells. BO will do its best to represent the data as you have put it on your Webi report. If your section headers don’t align with your table cell edges, you’ll end up with extra unwanted columns. Your report title can always be moved into the page header to help avoid this :+1:

5

How does one remove the blank row at the bottom when exporting to Excel? I have tried setting the size of the footer to 0, not displaying the footer, etc., but no luck so far.

parrotheadcali (BOB member since 2011-10-12)

6

Edited to provide how I “fixed” it. No matter how many times I allowed the tool to move the table to “0” it still kept a blank column on the left. I manually moved the table to the right, manually placed it as far left and toward the top that I could and that removed the blank. I am still not sure why setting the positions to “0” did not work but at least I can move on.

Here is my issue and I wonder if anyone else has experienced it. I have a report that has multiple tabs and each tab has a cross tab type report.

Every cross tab’s location is set to 0 top and 0 left. Two of the tabs still put a blank column on the left and the other tabs do not.

Any idea why this is happening and how I might prevent it? :hb:
Roland

REB01 :us: (BOB member since 2004-11-29)