HR, Payroll, Attendance Software Forums Lenvica HRMS Ask a Question How to export report to single excel sheet…

Viewing 1 reply thread
  • Author
    Posts
    • Joshua George
      Participant
      Post count: 25

      Hi,

      When I export a report to excel, each page appears in a different excel sheet.

      Is it possible to export the whole report to a single excel sheet?

      Thanks in advance,
      Josh

    • natraj
      Member
      Post count: 54

      Hi Josh,

      I hope that you are speaking about 'Saving a report' as an 'Excel' file.

      There are two options available, for saving a report as an Excel file:

      1. All the pages of the report can be printed in one sheet of an excel file
      2. Every page of the report can be printed as different sheet in the excel file.

      This can be done by selecting 'Save as type' as either 'Excel file' (pt 2) or 'Excel file (one sheet)' (pt 1) in the 'save' dialog.

      A screeshot is attached for your reference.

      I hope this helps you…

      Regards,
      Natraj


      Attachments:

Viewing 1 reply thread
  • You must be logged in to reply to this topic.