Search for answers here or ask a question
0

Send Multiple discovery in single Excel sheet

Hi,

I'm working on a publication, in which I have multiple discovery reports. When I try to export to excel, the generated excel creates multiple sheets for each discovery. I'm using repeater in the page for different sales channel so it creating more sheets in the Excel. For example, I have 8 discovery in the publication, repeating that for 7 different sales channel so when I export to Excel, its creating 8*7 = 56 sheets.

I want one sheet per sales channel, is there a way to achieve this?

Please let me know.

Kind Regards,

Viji

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Viji_v
    • Viji_v
    • 3 wk ago
    • Reported - view

    Pyramid Version I'm using is 2020.22

    Like
    • Ian MacdonaldAdmin
    • Team Lead - Product Management
    • Ian_Macdonald
    • 3 wk ago
    • Reported - view

    Hi Viji,

    No, this is the way it works by design. It is designed as a "Data Export" rather then a formatted Excel report export. It is expected that the data tables produced will in some way be used to drive further Excel business logic through formulas etc. In which case it doesn't really matter which sheet they are on and in fact makes it easier to organise.

    May I ask why you are exporting to Excel? What are you doing in Excel that cannot be done  in Pyramid?

    Hope that helps.

    Ian

    Like
Like Follow
  • Status Answered
  • 3 wk agoLast active
  • 2Replies
  • 25Views
  • 2 Following