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 } );
}
}