I am trying to write the code for doing the following:
- by clicking a button, import specific data from an Excel file which I select through a dialog window;
- input a name for the imported data set through an input field;
- store the imported data permanently under the given name (for example a variable with that name), so that I don't have to import it again next time I open Mathematica;
- repeat 1. - 3. , etc.
The idea is to be able to have several data sets imported from several Excel files, assign specific names to them and store all of them inside the notebook permanently.
Could someone please guide me to achieve this?
ClearAll; InitializationCell; ExcelFile = SystemDialogInput["FileOpen"] impdatas = {}; AppendTo[impdatas, Import[ExcelFile, {"Data", 5, Table[i, {i, 4, 24}], {1, 2}}]]
$\endgroup$Put
andGet
. $\endgroup$