Skip to Content
author's profile photo Former Member
Former Member

Remove gridlines while exporting to excel

Hi All,

I have a report which we have autoscheduled.

While exporting it to excel , we see gridlines after the report data.

Is their any way to remove gridlines after exporting?

attached sample output

I searched for posts but didn't found any soln! 😔

1.PNG (20.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2016 at 05:47 AM

    Hello Akshat,

    Like others said its not possible from Webi to remove the grid lines and that's the beauty of Webi that it keeps the layout intact when exporting it to Excel.

    You can just try some workarounds in Excel(as I am not Excel expert) once its exported to remove the grid lines from all the cells in the spread sheet.

    Regards

    Niraj

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2016 at 10:50 PM

    I don't think you will be able to manage this inside BO. Its a Excel functionality which is out of scope from BO.

    Add a comment
    10|10000 characters needed characters exceeded

    • There is one way to remove the grid lines from the excel sheet only if you are scheduling the report to a file location. You can create a VBA script which will process the excel sheet to remove the grid lines from the excel.

      You can schedule the script to run using Task Scheduler provided by Windows. This is kind of a workaround.

      I found this link for a VBA script, hope it helps:

      Vba help remove gridlines

  • Posted on Jul 29, 2016 at 04:01 AM

    This is Excel functionality as Kuldeep said

    one way to do is to create a table which has some large data at the bottom of your table and then change the text\border appearance of the table to white, so it will look as a blank table.

    when you export you will get no grid after your table

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.