Export data to excel file

To export data to an excel file, we can use the SysExcelWorksheetHelper. Here an example: static void exportExcelFile(Args _args) { SysExcelApplication xlsApplication; SysExcelWorkBooks xlsWorkBookCollection; SysExcelWorkBook xlsWorkBook; SysExcelWorkSheets xlsWorkSheetCollection; SysExcelWorkSheet xlsWorkSheet; SysExcelWorksheetHelper worksheetHelper; SysExcelHelper sysExcelHelper; VendRFQJour vendRFQJour; int row = 1; str fileName; str worksheetName; Date deliveryDate; fileName = "Path\\Test.xlsx"; vendRFQJour = VendRFQJour::find("000103"); worksheetName = "Worksheet … Continue reading Export data to excel file