Hello all,
I am trying to write a script that opens an xls file, but, I am stuck on the first step.
How to open a file using a dialog box. The usual Dialogs.getFilePath() doesnt work with ARIS Connect.
Any help will be greatly appreciated and qualifies for a coffee.. :)
Regards,
Sumit
Hi,
Use Dialogs.BrowseForFiles instead of Dialogs.getFilePath()
var aFileBytes = getImportFileAsByteArray();
var oWorkbook = Context.createExcelWorkbook("MyResult.xlsx", aFileBytes);
oWorkbook.write();
/****************************************************************************************************************
Import File
****************************************************************************************************************/
function getImportFileAsByteArray(){
var a_Bytes = null;
if(a_Bytes == null){
var a_Files = Dialogs.BrowseForFiles("", "*.xlsx!!Excel|*.xlsx||", null, "Select Import File", 0);
if(a_Files != null){
a_Bytes = a_Files[0].getData();
}
}
return a_Bytes;
}