jarvisdictionary
by Tim C. Lueth, SG-Lib Toolbox: SolidGeometry 5.6 - User interface
Introduced first in SolidGeometry 5.1, Creation date: 2022-01-27, Last change: 2025-09-15
reads writes a excel sheet containing string to replace and code to execute
Description
Used to modify the language interface jarvis during runtime
currently the dictinoary used only for translating. It is also possible to use it as matlab function execution system
SGwritetable(fname,array2tableTL(a,b{:}),c);
See Also: siri2jarvis
, SGwritetable
, SGreadtable
Example Illustration
Syntax
[fulltab,b,c]=jarvisdictionary([fname])
Input Parameter
fname: | | file name of the excel-sheet to use |
Output Parameter
fulltab: | | Table |
b: | | names |
c: | | comment lines |
Copyright 2022-2025 Tim C. Lueth. All rights reserved. The code is the property of Tim C. Lueth and may not be redistributed or modified without explicit written permission. This software may be used free of charge for academic research and teaching purposes only. Commercial use, redistribution, modification, or reverse engineering is strictly prohibited. Access to source code is restricted and granted only under specific agreements. For licensing inquiries or commercial use, please contact: Tim C. Lueth
Algorithm (Workflow)
This function, jarvisdictionary, is designed to read and modify an Excel sheet used for language translation and potentially for executing MATLAB functions. It is part of the SolidGeometry library and was introduced in version 5.1.
Input Parameters
- fname: The file name of the Excel sheet to be used. If not provided, a default path is used.
- excel: A boolean indicating whether to open the Excel file after processing. Default is
false.
Output Results
- fulltab: The processed table from the Excel sheet.
- b: Names extracted from the table.
- c: Comment lines from the table.
Algorithm Steps
- Retrieve the file name
fname and the excel flag from the input parameters using getfuncparams.
- Read the table from the Excel file using
SGreadtable, which returns three outputs: a, b, and c.
- Iterate over each element in
a:
- If an element is
NaN, replace it with an empty string.
- If an element is numeric, convert it to a string using
num2str.
- Convert all elements in
a to lowercase.
- Write the modified table back to the Excel file using
SGwritetable and array2tableTL, ensuring the table is not sorted.
- If the
excel flag is true, open the Excel file using openbydoubleclick.
- Extract unique vocabulary terms from the first column of
a, trimming whitespace and removing empty cells and lines starting with '==='.
- Assign the processed table
a to fulltab.
Algorithm explaination created using ChatGPT on 2025-08-19 07:38. (Please note: No guarantee for the correctness of this explanation)
Last html export of this page out of FM database by TL: 2025-09-21