使用X++代码调用Resocues中的文件


前言

以下示例为使用X++代码调用Resources中的xlsx文件,并另存到电脑的指定位置


一、获取Resources

FilePath    resourcesFile

resourcesFile = SysResource::saveToTempFile(SysResource::getResourceNode(resourcestr('Resources_name')));

二、导出文件到本地

在D365中和AX2012中的导出方法是不一样的,示例如下:

1.AX2012示例

    ResourceNode            resourceNode;
    SysExcelApplication     application;
    SysExcelWorkbooks       workbooks;
    SysExcelWorkbook        workbook;
    SysExcelWorksheets      worksheets;
    SysExcelWorksheet       worksheet;
    SysExcelCells           cells;
    COMVariantType          type;
    int                     row =1;
    FileName                origenfilename;


    origenfilename = resourcesFile;

    application = SysExcelApplication::construct();

    application.displayAlerts(false);
    workbooks = application.workbooks();
     workbooks.open(origenfilename);
    workbook = workbooks.item(1);
    worksheets = workbook.worksheets();
    worksheet = worksheets.itemFromNum(1);
    cells = worksheet.cells();

    cells.item(4,1).value('test1');
    cells.item(4,2).value('test2');
    cells.item(4,3).value('test3');

    workbook.saveAs("C:\\Temp\\Test\\TestExcel.xlsx");
    application.quit();
    info('import succeed');

2.D365

using System.IO;
using OfficeOpenXml;
using OfficeOpenXml.Style;
using OfficeOpenXml.Table;
class RunnableClass1
{
    /// <summary>
    /// Runs the class with the specified arguments.
    /// </summary>
    /// <param name = "_args">The specified arguments.</param>
    public static void main(Args _args)
    {
        str                 tmpfile;
        str                 value;
        CustTable           custTable;
        FileInfo            templateFile;
        ExcelRange          cells,cell;
        MemoryStream        memoryStream = new MemoryStream();

        //Get Resource temPlate
        tmpfile = SysResource::saveToTempFile(SysResource::getResourceNode(resourcestr('GLOB_CEC_HensiveIncomeReportTemplate')));
        //convent temPlate type as File Fileinfo
        //将resource文件转换为IO流
        templateFile = new System.IO.FileInfo(tmpfile);
        //将IO流传递给excelpackage
        using (ExcelPackage filepackage = new ExcelPackage(templateFile))
        {
            int currentRow = 1;
            
            // 获取模板第一个sheet
            cells = filepackage.Workbook.Worksheets.get_Item(1).get_Cells();
            // 获取内存流
            memoryStream = filepackage.Stream;
            
           	cells.get_Item(currentRow, 1)value = '1' ;
           	
            filepackage.Save();
            file::SendFileToUser(memoryStream,'test_voucher.xlsx');     
        }
      
    }

}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值