I want to upload data into aris from an excel file.I know there is a process generator where I can extract data from aris , modify and then upload back into aris.
But is there any other way of mass upload data in aris?
Please help me in this.
Thanks to respond.
1 Reply
-
RG
Hello,
well sure, you can do this via scripting:
var g_vImportFile = new __holder("");
var asFileNames = Dialogs.BrowseForFiles("", "*.xls", "", "", 0)
g_vImportFile.value = asFileNames[0];oImportExcel = Context.getExcelReader(g_vImportFile.value.getData());
oImportSheetList = oImportExcel.getSheets();
g_oSheet = oImportSheetList[1];while (g_oSheet.getCell(1 + lCount, 3) != null && g_oSheet.getCell(1 + lCount, 4) != null) {
sVal1 = g_oSheet.getCell(1 + lCount, 3).getCellValue().toString();
sVal2 = g_oSheet.getCell(1 + lCount, 4).getCellValue().toString();
lCount++;
...
}BR Robert