Not able to download Suitelet through suitescript 1.0

Question

I have created a button to export the form data to simple Excel. Everything is working file, even if i try to save this excel file in the file cabinet it gets saved correctly. But when i try to downlaod the excel file, downloads wierd single cell file with special characters or system gives either an error or saves an empty excel file. Can anyone help me in how to download the excel file from button click. I think i have issue in my responce.

My Code example is as follows:

  .
  .
  .
  xmlString += '</Table></Worksheet></Workbook>';// this is my xml string

  var xlsFile = nlapiCreateFile('test.xls', 'EXCEL', nlapiEncrypt(xmlString, 'base64'));
  response.writeFile(xmlFile);
}

error screenshot:

try to add some headers like `content-type` – gillyspy Mar 06 '22 at 19:44 — gillyspy, Mar 06 '22 at 19:44

score 0 · Answer 1 · answered Mar 10 '22 at 03:21

0

I think the reason for the response issue is because you are calling a non-existent variable "xmlFile" in writeFile();

try using this writeFile(xlsFile);

answered Mar 10 '22 at 03:21

Albert Fermo

1
3

My Bad, I copied the incorrect var but in production the issue i m facing is the same. – 4N335 Mar 10 '22 at 04:43
based on the image, "Cannot find function writefile". In your function: do you have two parameters? like this generateXMLFile ( request, response ). – Albert Fermo Mar 25 '22 at 09:43
1

writeFile method is always usable if you are using the correct variable here. – Albert Fermo Mar 25 '22 at 09:45

Not able to download Suitelet through suitescript 1.0

1 Answers1