How You Open Dialog Box To Upload Excel File Using X++ Code ?

dialog = new Dialog("Excel Upoad");

dialogFilename = dialog.addField(typeId(FilenameOpen));

dialog.filenameLookupFilter(["@SYS28576",#XLSX,"@SYS28576",#XLS]);

dialog.filenameLookupTitle("Upload from Excel");

dialog.caption("Excel Upload");

dialogFilename.value(filename);

if(!dialog.run())

return;

filename = dialogFilename.value();

application = SysExcelApplication::construct();

workbooks = application.workbooks();

try

{

workbooks.open(filename);

}

catch (Exception::Error)

{

throw error("File cannot be opened.");

}