在NetSuite的SuiteScript中创建Excel文件 [英] Create Excel File in NetSuite's SuiteScript

问题描述

我目前正在尝试使用NetSuite基于JavaScript的SuiteScript API为电子邮件附件生成Excel文件.现在，我生成一个CSV文件没有问题.这很容易.但是，需要的是Excel文件，但除了麻烦之外，我什么都没有.总是给我带来麻烦的代码行如下:

I'm currently trying to generate an Excel file for an e-mail attachment using NetSuite's JavaScript-based SuiteScript APIs. Now, I have no problem generating a CSV file. That's easy. But an Excel file is what is requested and I'm having nothing but trouble with it. The line of code that always gives me trouble is the following:

var dataFile = nlapiCreateFile(dataFilename, "EXCEL", fileData);

它总是导致脚本崩溃.到目前为止，我已经尝试了简单的CSV样式的数据格式化，并且还尝试了将XML格式用于数据，但是这两种方法均无效.同时，我们将踢出一个CSV文件并将其转换为XLS，但是如果有人知道NetSuite的知识足以帮助您，将不胜感激.如果有人希望看到XML生成的代码，我可以添加它.

It always causes the script to crash. So far I've tried simple CSV style data formatting and I've also tried to utilize an XML format to the data, but neither method works. In the meantime, we're going to just kick out a CSV file and have them convert it to XLS, but if anyone knows the NetSuite stuff well enough to help, it would be greatly appreciated. If anyone would like to see the code for the XML generation, I can add that.

这是为测试文件生成的XML的示例...

Here's a sample of the XML generated for the test file...

<?xml version="1.0"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
    <ss:Worksheet ss:Name="Sheet1">
        <ss:Table>
            <ss:Row>
                <ss:Cell>
                    <ss:Data ss:Type="String">Booth Number</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Company</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Address</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">City</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">State</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Zip</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Country</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Telephone</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Fax</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Contact Name</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Email</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Booth Length</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Booth Width</ss:Data>
                </ss:Cell>
            </ss:Row>
        </ss:Table>
    </ss:Worksheet>
</ss:Workbook>

推荐答案

尝试一下:

var xlsFile = nlapiCreateFile('filename.xls', 'EXCEL', nlapiEncrypt(xmlString, 'base64'));
xlsFile.setFolder(folderID);

var fileID = nlapiSubmitFile(xlsFile);  

这篇关于在NetSuite的SuiteScript中创建Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！