How to call report in xlsx file format

Question

could you please help me how to call report Xlsx file format, i am tried to below code, but i am not get the result:

public class BatchUtilClass {
    @future(callout=true)
    public static void futureMethod() {
        list <Report> reportList = [SELECT Id,Name FROM Report WHERE Name = 'users logins' limit 1];
        system.debug('list'+reportList);
        String reportId = (String)reportList.get(0).get('Id');
        system.debug('reportids'+reportId);
        ApexPages.PageReference report = new ApexPages.PageReference('/00O3N000000097hg9v?csv=1&isdtp=p1');
        // ApexPages.PageReference report = new ApexPages.PageReference('/00O3N000000097hg9v?export=1&enc=UTF-8&xf=xls');
        system.debug('pagereport'+report);
        Messaging.EmailFileAttachment attachment = new Messaging.EmailFileAttachment();
        system.debug('atachment'+attachment);
        attachment.setFileName('Report.csv');
        // attachment.setFileName('Report.xlsx');
        attachment.setBody(report.getContent());
        attachment.setContentType('text/csv');
        // attachment.setContentType('text/xlsx');
        Messaging.SingleEmailMessage message = new Messaging.SingleEmailMessage();
        message.setFileAttachments(new Messaging.EmailFileAttachment[] { attachment } );
        message.setSubject('users logins Report');
        message.setPlainTextBody('The testing report is attached.');
        message.setToAddresses( new String[] { 'hkvts2@gmail.com' } );
        Messaging.sendEmail( new Messaging.SingleEmailMessage[] { message } );

    }
}

Answer 1

Your code is not asking for XLSX format. You're asking for either CSV or XLS format, depending on which lines are commented out. Changing the filename or MIME type on the attachment object has no effect on what file format is produced.

Inspecting the URL generated when exporting an XLSX-format report in Lightning yields the URL format

https://<mydomain>.my.salesforce.com/servlet/PrintableViewDownloadServlet?isdtp=p1&reportId=<report id>

Presumably, you'd need to ask for that URL to obtain the desired format.

Answer 2

Based on this answer, the correct way to set the Content Type for an xlsx file is to use application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, not text/xlsx.