// Set variables

// Download from https://github.com/SheetJS/sheetjs/blob/github/dist/xlsx.full.min.js
var sheetsJSFile = "D:/Temp/xlsx.full.min.js"; 
// Change to your file path/name
var workbookFile = "D:/Temp/Book1.ods";

var columnNumber = 0;         // Use first column (A)
var startRow     = 1;         // Row to start random selection
                              // use 0 for entire column
                              // use 1 to skip header row
var sheetName    = "Sheet1";  // Name of worksheet

//Load sheetsjs into script engine
eval(System.IO.File.ReadAllText(sheetsJSFile));

//Load workbook from file
var wb = XLSX.read(
    new Uint8Array(System.IO.File.ReadAllBytes(workbookFile)), 
    { type: 'array', raw: true, cellFormula: false }
);

//Get worksheet
var ws = wb.Sheets[sheetName];
//Get cell ranges
var cellRanges = XLSX.utils.decode_range(ws['!ref']);

var randomRow = Math.floor(Math.random() * cellRanges.e.r) + startRow;

//Create cell reference for columna and randomRow
var cellRef = XLSX.utils.encode_cell({c:columnNumber, r:randomRow});

//Get cell
var cell = ws[cellRef];

//Show value from cell
var info = new DisplayTextInfo();
info.Title = "";
info.Message = cell.v; // Cell value 
info.Duration = 1000; //1 second
info.Location = sp.GetCurrentMousePoint().X + ',' + sp.GetCurrentMousePoint().Y;
info.MessageFont = new Font("Segoe UI Semibold", 10);
info.BackColor = "black";
info.Padding = 0;
info.ClipToWorkingArea = false;
sp.DisplayText(info);

//Slight pause
sp.Sleep(100); 

//Send cell value as string to active window
sp.SendUnicodeString(cell.v);