Not able to open attached excel file to a record (xlsx format)

[Tanwir Singh11]

Hi All,

I am creating an excel and attaching to a record.

I am using the below code to attach the file:

var grRec = new GlideRecord("sc_task");
    grRec.addQuery("sys_id", current.sys_id + "");
    grRec.query();
    if (grRec.next()) {
        var grAttachment = new GlideSysAttachment();
        grAttachment.write(grRec, fileName, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', csvData);
    }

It works perfectly for application/csv but not for xlsx format and I need the .xlsx format. The file gets created and attached but when I try to open it, it says the file is corrupted.

Could anyone tell me what am i doing wrong here, please?

Thanks!!!

[Tanwir Singh11]

hey @Ankur Bawiskar , @Chuck Tomasi , @Robert Fedoruk 

Could you guys please help?

[Ankita Sarkar]

Hi,

Please have a look at this ServiceNow KB article which might help you.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0752391

Regards,

Ankita Sarkar

[Tanwir Singh11]

hey,

This is not a REST call. 

[Ankur Bawiskar · Accepted solution]

Hi,

it's not straight forward for xlsx file and it won't work

Either keep it csv or else you would require custom solution to create xlsx file and attach to record

Regards
Ankur