Quintiq file version 2.0
|
#parent: #root
|
Method GetDataFromXLS () as BinaryValue id:Method_LibCal_GlobalState_GetDataFromXLS
|
{
|
#keys: '[146730.0.1413910579]'
|
Body:
|
[*
|
// Import calendar data from XLS.
|
binValue := BinaryValue::Construct();
|
|
// Let the user select a file.
|
// The contents of the XML-file is 'wrapped' in JSON.
|
fileAsJSON := Application.GetFile( "xlsx" );
|
|
// When the user cancels the action it ends here,
|
// i.e. the code below is not executed.
|
|
if( fileAsJSON <> "" )
|
{
|
// Make sure that the ImportExport-dataset is selected.
|
if( this.EnsureImportExportDataset() )
|
{
|
// Get the data from the file.
|
// The data-section of the JSON contains the contents of the XLS-file.
|
json := JSON::Parse( fileAsJSON );
|
data := json.Get( "data" ).GetString();
|
|
// Convert the data to a BinaryValue.
|
binValue := BinaryValue::FromBase64EncodedString( data );
|
}
|
}
|
|
return binValue;
|
*]
|
}
|
