How to use R2020a import tool to upload multiple excel files

1 view (last 30 days)
I used the import tool in the new R2020a version to generate code to selectively import signal data and error data from an Excel file. The data is then output into a cell array (to capture both the numerical and text data). The problem is I need to upload data the same way from another 120 files. Each file name is named after a chemical element and their mass (e.g., Be9Round2, B10Round2, Mg26Rounde, etc) and is output into one cell array for the signal and one cell array for the error (e.g., Be9CPS, Be9Error; Mg6CPS, Mg6Error). Is there a smarter way to import the data in this method without using copy and paste for each file? I have the generated code pasted below:
%% Setup the Import Options and import the data
opts = spreadsheetImportOptions("NumVariables", 530);
% Specify sheet
opts.Sheet = "Sheet1";
% Specify column names and types
opts.VariableNames = ["Var1", "Var2", "Var3", "Var4", "Var5", "Var6", "Var7", "Var8", "Var9", "CPS", "Var11", "CPS_1", "Var13", "CPS_2", "Var15", "CPS_3", "Var17", "CPS_4", "Var19", "CPS_5", "Var21", "CPS_6", "Var23", "CPS_7", "Var25", "CPS_8", "Var27", "CPS_9", "Var29", "CPS_10", "Var31", "CPS_11", "Var33", "CPS_12", "Var35", "CPS_13", "Var37", "CPS_14", "Var39", "CPS_15", "Var41", "CPS_16", "Var43", "CPS_17", "Var45", "CPS_18", "Var47", "CPS_19", "Var49", "CPS_20", "Var51", "CPS_21", "Var53", "CPS_22", "Var55", "CPS_23", "Var57", "CPS_24", "Var59", "CPS_25", "Var61", "CPS_26", "Var63", "CPS_27", "Var65", "CPS_28", "Var67", "CPS_29", "Var69", "CPS_30", "Var71", "CPS_31", "Var73", "CPS_32", "Var75", "CPS_33", "Var77", "CPS_34", "Var79", "CPS_35", "Var81", "CPS_36", "Var83", "CPS_37", "Var85", "CPS_38", "Var87", "CPS_39", "Var89", "CPS_40", "Var91", "CPS_41", "Var93", "CPS_42", "Var95", "CPS_43", "Var97", "CPS_44", "Var99", "CPS_45", "Var101", "CPS_46", "Var103", "CPS_47", "Var105", "CPS_48", "Var107", "CPS_49", "Var109", "CPS_50", "Var111", "CPS_51", "Var113", "CPS_52", "Var115", "CPS_53", "Var117", "CPS_54", "Var119", "CPS_55", "Var121", "CPS_56", "Var123", "CPS_57", "Var125", "CPS_58", "Var127", "CPS_59", "Var129", "CPS_60", "Var131", "CPS_61", "Var133", "CPS_62", "Var135", "CPS_63", "Var137", "CPS_64", "Var139", "CPS_65", "Var141", "CPS_66", "Var143", "CPS_67", "Var145", "CPS_68", "Var147", "CPS_69", "Var149", "CPS_70", "Var151", "CPS_71", "Var153", "CPS_72", "Var155", "CPS_73", "Var157", "CPS_74", "Var159", "CPS_75", "Var161", "CPS_76", "Var163", "CPS_77", "Var165", "CPS_78", "Var167", "CPS_79", "Var169", "CPS_80", "Var171", "CPS_81", "Var173", "CPS_82", "Var175", "CPS_83", "Var177", "CPS_84", "Var179", "CPS_85", "Var181", "CPS_86", "Var183", "CPS_87", "Var185", "CPS_88", "Var187", "CPS_89", "Var189", "CPS_90", "Var191", "CPS_91", "Var193", "CPS_92", "Var195", "CPS_93", "Var197", "CPS_94", "Var199", "CPS_95", "Var201", "CPS_96", "Var203", "CPS_97", "Var205", "CPS_98", "Var207", "CPS_99", "Var209", "CPS_100", "Var211", "CPS_101", "Var213", "CPS_102", "Var215", "CPS_103", "Var217", "CPS_104", "Var219", "CPS_105", "Var221", "CPS_106", "Var223", "CPS_107", "Var225", "CPS_108", "Var227", "CPS_109", "Var229", "CPS_110", "Var231", "CPS_111", "Var233", "CPS_112", "Var235", "CPS_113", "Var237", "CPS_114", "Var239", "CPS_115", "Var241", "CPS_116", "Var243", "CPS_117", "Var245", "CPS_118", "Var247", "CPS_119", "Var249", "CPS_120", "Var251", "CPS_121", "Var253", "CPS_122", "Var255", "CPS_123", "Var257", "CPS_124", "Var259", "CPS_125", "Var261", "CPS_126", "Var263", "CPS_127", "Var265", "CPS_128", "Var267", "CPS_129", "Var269", "CPS_130", "Var271", "CPS_131", "Var273", "CPS_132", "Var275", "CPS_133", "Var277", "CPS_134", "Var279", "CPS_135", "Var281", "CPS_136", "Var283", "CPS_137", "Var285", "CPS_138", "Var287", "CPS_139", "Var289", "CPS_140", "Var291", "CPS_141", "Var293", "CPS_142", "Var295", "CPS_143", "Var297", "CPS_144", "Var299", "CPS_145", "Var301", "CPS_146", "Var303", "CPS_147", "Var305", "CPS_148", "Var307", "CPS_149", "Var309", "CPS_150", "Var311", "CPS_151", "Var313", "CPS_152", "Var315", "CPS_153", "Var317", "CPS_154", "Var319", "CPS_155", "Var321", "CPS_156", "Var323", "CPS_157", "Var325", "CPS_158", "Var327", "CPS_159", "Var329", "CPS_160", "Var331", "CPS_161", "Var333", "CPS_162", "Var335", "CPS_163", "Var337", "CPS_164", "Var339", "CPS_165", "Var341", "CPS_166", "Var343", "CPS_167", "Var345", "CPS_168", "Var347", "CPS_169", "Var349", "CPS_170", "Var351", "CPS_171", "Var353", "CPS_172", "Var355", "CPS_173", "Var357", "CPS_174", "Var359", "CPS_175", "Var361", "CPS_176", "Var363", "CPS_177", "Var365", "CPS_178", "Var367", "CPS_179", "Var369", "CPS_180", "Var371", "CPS_181", "Var373", "CPS_182", "Var375", "CPS_183", "Var377", "CPS_184", "Var379", "CPS_185", "Var381", "CPS_186", "Var383", "CPS_187", "Var385", "CPS_188", "Var387", "CPS_189", "Var389", "CPS_190", "Var391", "CPS_191", "Var393", "CPS_192", "Var395", "CPS_193", "Var397", "CPS_194", "Var399", "CPS_195", "Var401", "CPS_196", "Var403", "CPS_197", "Var405", "CPS_198", "Var407", "CPS_199", "Var409", "CPS_200", "Var411", "CPS_201", "Var413", "CPS_202", "Var415", "CPS_203", "Var417", "CPS_204", "Var419", "CPS_205", "Var421", "CPS_206", "Var423", "CPS_207", "Var425", "CPS_208", "Var427", "CPS_209", "Var429", "CPS_210", "Var431", "CPS_211", "Var433", "CPS_212", "Var435", "CPS_213", "Var437", "CPS_214", "Var439", "CPS_215", "Var441", "CPS_216", "Var443", "CPS_217", "Var445", "CPS_218", "Var447", "CPS_219", "Var449", "CPS_220", "Var451", "CPS_221", "Var453", "CPS_222", "Var455", "CPS_223", "Var457", "CPS_224", "Var459", "CPS_225", "Var461", "CPS_226", "Var463", "CPS_227", "Var465", "CPS_228", "Var467", "CPS_229", "Var469", "CPS_230", "Var471", "CPS_231", "Var473", "CPS_232", "Var475", "CPS_233", "Var477", "CPS_234", "Var479", "CPS_235", "Var481", "CPS_236", "Var483", "CPS_237", "Var485", "CPS_238", "Var487", "CPS_239", "Var489", "CPS_240", "Var491", "CPS_241", "Var493", "CPS_242", "Var495", "CPS_243", "Var497", "CPS_244", "Var499", "CPS_245", "Var501", "CPS_246", "Var503", "CPS_247", "Var505", "CPS_248", "Var507", "CPS_249", "Var509", "CPS_250", "Var511", "CPS_251", "Var513", "CPS_252", "Var515", "CPS_253", "Var517", "CPS_254", "Var519", "CPS_255", "Var521", "CPS_256", "Var523", "CPS_257", "Var525", "CPS_258", "Var527", "CPS_259", "Var529", "CPS_260"];
opts.SelectedVariableNames = ["CPS", "CPS_1", "CPS_2", "CPS_3", "CPS_4", "CPS_5", "CPS_6", "CPS_7", "CPS_8", "CPS_9", "CPS_10", "CPS_11", "CPS_12", "CPS_13", "CPS_14", "CPS_15", "CPS_16", "CPS_17", "CPS_18", "CPS_19", "CPS_20", "CPS_21", "CPS_22", "CPS_23", "CPS_24", "CPS_25", "CPS_26", "CPS_27", "CPS_28", "CPS_29", "CPS_30", "CPS_31", "CPS_32", "CPS_33", "CPS_34", "CPS_35", "CPS_36", "CPS_37", "CPS_38", "CPS_39", "CPS_40", "CPS_41", "CPS_42", "CPS_43", "CPS_44", "CPS_45", "CPS_46", "CPS_47", "CPS_48", "CPS_49", "CPS_50", "CPS_51", "CPS_52", "CPS_53", "CPS_54", "CPS_55", "CPS_56", "CPS_57", "CPS_58", "CPS_59", "CPS_60", "CPS_61", "CPS_62", "CPS_63", "CPS_64", "CPS_65", "CPS_66", "CPS_67", "CPS_68", "CPS_69", "CPS_70", "CPS_71", "CPS_72", "CPS_73", "CPS_74", "CPS_75", "CPS_76", "CPS_77", "CPS_78", "CPS_79", "CPS_80", "CPS_81", "CPS_82", "CPS_83", "CPS_84", "CPS_85", "CPS_86", "CPS_87", "CPS_88", "CPS_89", "CPS_90", "CPS_91", "CPS_92", "CPS_93", "CPS_94", "CPS_95", "CPS_96", "CPS_97", "CPS_98", "CPS_99", "CPS_100", "CPS_101", "CPS_102", "CPS_103", "CPS_104", "CPS_105", "CPS_106", "CPS_107", "CPS_108", "CPS_109", "CPS_110", "CPS_111", "CPS_112", "CPS_113", "CPS_114", "CPS_115", "CPS_116", "CPS_117", "CPS_118", "CPS_119", "CPS_120", "CPS_121", "CPS_122", "CPS_123", "CPS_124", "CPS_125", "CPS_126", "CPS_127", "CPS_128", "CPS_129", "CPS_130", "CPS_131", "CPS_132", "CPS_133", "CPS_134", "CPS_135", "CPS_136", "CPS_137", "CPS_138", "CPS_139", "CPS_140", "CPS_141", "CPS_142", "CPS_143", "CPS_144", "CPS_145", "CPS_146", "CPS_147", "CPS_148", "CPS_149", "CPS_150", "CPS_151", "CPS_152", "CPS_153", "CPS_154", "CPS_155", "CPS_156", "CPS_157", "CPS_158", "CPS_159", "CPS_160", "CPS_161", "CPS_162", "CPS_163", "CPS_164", "CPS_165", "CPS_166", "CPS_167", "CPS_168", "CPS_169", "CPS_170", "CPS_171", "CPS_172", "CPS_173", "CPS_174", "CPS_175", "CPS_176", "CPS_177", "CPS_178", "CPS_179", "CPS_180", "CPS_181", "CPS_182", "CPS_183", "CPS_184", "CPS_185", "CPS_186", "CPS_187", "CPS_188", "CPS_189", "CPS_190", "CPS_191", "CPS_192", "CPS_193", "CPS_194", "CPS_195", "CPS_196", "CPS_197", "CPS_198", "CPS_199", "CPS_200", "CPS_201", "CPS_202", "CPS_203", "CPS_204", "CPS_205", "CPS_206", "CPS_207", "CPS_208", "CPS_209", "CPS_210", "CPS_211", "CPS_212", "CPS_213", "CPS_214", "CPS_215", "CPS_216", "CPS_217", "CPS_218", "CPS_219", "CPS_220", "CPS_221", "CPS_222", "CPS_223", "CPS_224", "CPS_225", "CPS_226", "CPS_227", "CPS_228", "CPS_229", "CPS_230", "CPS_231", "CPS_232", "CPS_233", "CPS_234", "CPS_235", "CPS_236", "CPS_237", "CPS_238", "CPS_239", "CPS_240", "CPS_241", "CPS_242", "CPS_243", "CPS_244", "CPS_245", "CPS_246", "CPS_247", "CPS_248", "CPS_249", "CPS_250", "CPS_251", "CPS_252", "CPS_253", "CPS_254", "CPS_255", "CPS_256", "CPS_257", "CPS_258", "CPS_259", "CPS_260"];
opts.VariableTypes = ["char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char", "char"];
% Specify variable properties
opts = setvaropts(opts, ["Var1", "Var2", "Var3", "Var4", "Var5", "Var6", "Var7", "Var8", "Var9", "CPS", "Var11", "CPS_1", "Var13", "CPS_2", "Var15", "CPS_3", "Var17", "CPS_4", "Var19", "CPS_5", "Var21", "CPS_6", "Var23", "CPS_7", "Var25", "CPS_8", "Var27", "CPS_9", "Var29", "CPS_10", "Var31", "CPS_11", "Var33", "CPS_12", "Var35", "CPS_13", "Var37", "CPS_14", "Var39", "CPS_15", "Var41", "CPS_16", "Var43", "CPS_17", "Var45", "CPS_18", "Var47", "CPS_19", "Var49", "CPS_20", "Var51", "CPS_21", "Var53", "CPS_22", "Var55", "CPS_23", "Var57", "CPS_24", "Var59", "CPS_25", "Var61", "CPS_26", "Var63", "CPS_27", "Var65", "CPS_28", "Var67", "CPS_29", "Var69", "CPS_30", "Var71", "CPS_31", "Var73", "CPS_32", "Var75", "CPS_33", "Var77", "CPS_34", "Var79", "CPS_35", "Var81", "CPS_36", "Var83", "CPS_37", "Var85", "CPS_38", "Var87", "CPS_39", "Var89", "CPS_40", "Var91", "CPS_41", "Var93", "CPS_42", "Var95", "CPS_43", "Var97", "CPS_44", "Var99", "CPS_45", "Var101", "CPS_46", "Var103", "CPS_47", "Var105", "CPS_48", "Var107", "CPS_49", "Var109", "CPS_50", "Var111", "CPS_51", "Var113", "CPS_52", "Var115", "CPS_53", "Var117", "CPS_54", "Var119", "CPS_55", "Var121", "CPS_56", "Var123", "CPS_57", "Var125", "CPS_58", "Var127", "CPS_59", "Var129", "CPS_60", "Var131", "CPS_61", "Var133", "CPS_62", "Var135", "CPS_63", "Var137", "CPS_64", "Var139", "CPS_65", "Var141", "CPS_66", "Var143", "CPS_67", "Var145", "CPS_68", "Var147", "CPS_69", "Var149", "CPS_70", "Var151", "CPS_71", "Var153", "CPS_72", "Var155", "CPS_73", "Var157", "CPS_74", "Var159", "CPS_75", "Var161", "CPS_76", "Var163", "CPS_77", "Var165", "CPS_78", "Var167", "CPS_79", "Var169", "CPS_80", "Var171", "CPS_81", "Var173", "CPS_82", "Var175", "CPS_83", "Var177", "CPS_84", "Var179", "CPS_85", "Var181", "CPS_86", "Var183", "CPS_87", "Var185", "CPS_88", "Var187", "CPS_89", "Var189", "CPS_90", "Var191", "CPS_91", "Var193", "CPS_92", "Var195", "CPS_93", "Var197", "CPS_94", "Var199", "CPS_95", "Var201", "CPS_96", "Var203", "CPS_97", "Var205", "CPS_98", "Var207", "CPS_99", "Var209", "CPS_100", "Var211", "CPS_101", "Var213", "CPS_102", "Var215", "CPS_103", "Var217", "CPS_104", "Var219", "CPS_105", "Var221", "CPS_106", "Var223", "CPS_107", "Var225", "CPS_108", "Var227", "CPS_109", "Var229", "CPS_110", "Var231", "CPS_111", "Var233", "CPS_112", "Var235", "CPS_113", "Var237", "CPS_114", "Var239", "CPS_115", "Var241", "CPS_116", "Var243", "CPS_117", "Var245", "CPS_118", "Var247", "CPS_119", "Var249", "CPS_120", "Var251", "CPS_121", "Var253", "CPS_122", "Var255", "CPS_123", "Var257", "CPS_124", "Var259", "CPS_125", "Var261", "CPS_126", "Var263", "CPS_127", "Var265", "CPS_128", "Var267", "CPS_129", "Var269", "CPS_130", "Var271", "CPS_131", "Var273", "CPS_132", "Var275", "CPS_133", "Var277", "CPS_134", "Var279", "CPS_135", "Var281", "CPS_136", "Var283", "CPS_137", "Var285", "CPS_138", "Var287", "CPS_139", "Var289", "CPS_140", "Var291", "CPS_141", "Var293", "CPS_142", "Var295", "CPS_143", "Var297", "CPS_144", "Var299", "CPS_145", "Var301", "CPS_146", "Var303", "CPS_147", "Var305", "CPS_148", "Var307", "CPS_149", "Var309", "CPS_150", "Var311", "CPS_151", "Var313", "CPS_152", "Var315", "CPS_153", "Var317", "CPS_154", "Var319", "CPS_155", "Var321", "CPS_156", "Var323", "CPS_157", "Var325", "CPS_158", "Var327", "CPS_159", "Var329", "CPS_160", "Var331", "CPS_161", "Var333", "CPS_162", "Var335", "CPS_163", "Var337", "CPS_164", "Var339", "CPS_165", "Var341", "CPS_166", "Var343", "CPS_167", "Var345", "CPS_168", "Var347", "CPS_169", "Var349", "CPS_170", "Var351", "CPS_171", "Var353", "CPS_172", "Var355", "CPS_173", "Var357", "CPS_174", "Var359", "CPS_175", "Var361", "CPS_176", "Var363", "CPS_177", "Var365", "CPS_178", "Var367", "CPS_179", "Var369", "CPS_180", "Var371", "CPS_181", "Var373", "CPS_182", "Var375", "CPS_183", "Var377", "CPS_184", "Var379", "CPS_185", "Var381", "CPS_186", "Var383", "CPS_187", "Var385", "CPS_188", "Var387", "CPS_189", "Var389", "CPS_190", "Var391", "CPS_191", "Var393", "CPS_192", "Var395", "CPS_193", "Var397", "CPS_194", "Var399", "CPS_195", "Var401", "CPS_196", "Var403", "CPS_197", "Var405", "CPS_198", "Var407", "CPS_199", "Var409", "CPS_200", "Var411", "CPS_201", "Var413", "CPS_202", "Var415", "CPS_203", "Var417", "CPS_204", "Var419", "CPS_205", "Var421", "CPS_206", "Var423", "CPS_207", "Var425", "CPS_208", "Var427", "CPS_209", "Var429", "CPS_210", "Var431", "CPS_211", "Var433", "CPS_212", "Var435", "CPS_213", "Var437", "CPS_214", "Var439", "CPS_215", "Var441", "CPS_216", "Var443", "CPS_217", "Var445", "CPS_218", "Var447", "CPS_219", "Var449", "CPS_220", "Var451", "CPS_221", "Var453", "CPS_222", "Var455", "CPS_223", "Var457", "CPS_224", "Var459", "CPS_225", "Var461", "CPS_226", "Var463", "CPS_227", "Var465", "CPS_228", "Var467", "CPS_229", "Var469", "CPS_230", "Var471", "CPS_231", "Var473", "CPS_232", "Var475", "CPS_233", "Var477", "CPS_234", "Var479", "CPS_235", "Var481", "CPS_236", "Var483", "CPS_237", "Var485", "CPS_238", "Var487", "CPS_239", "Var489", "CPS_240", "Var491", "CPS_241", "Var493", "CPS_242", "Var495", "CPS_243", "Var497", "CPS_244", "Var499", "CPS_245", "Var501", "CPS_246", "Var503", "CPS_247", "Var505", "CPS_248", "Var507", "CPS_249", "Var509", "CPS_250", "Var511", "CPS_251", "Var513", "CPS_252", "Var515", "CPS_253", "Var517", "CPS_254", "Var519", "CPS_255", "Var521", "CPS_256", "Var523", "CPS_257", "Var525", "CPS_258", "Var527", "CPS_259", "Var529", "CPS_260"], "WhitespaceRule", "preserve");
opts = setvaropts(opts, ["Var1", "Var2", "Var3", "Var4", "Var5", "Var6", "Var7", "Var8", "Var9", "CPS", "Var11", "CPS_1", "Var13", "CPS_2", "Var15", "CPS_3", "Var17", "CPS_4", "Var19", "CPS_5", "Var21", "CPS_6", "Var23", "CPS_7", "Var25", "CPS_8", "Var27", "CPS_9", "Var29", "CPS_10", "Var31", "CPS_11", "Var33", "CPS_12", "Var35", "CPS_13", "Var37", "CPS_14", "Var39", "CPS_15", "Var41", "CPS_16", "Var43", "CPS_17", "Var45", "CPS_18", "Var47", "CPS_19", "Var49", "CPS_20", "Var51", "CPS_21", "Var53", "CPS_22", "Var55", "CPS_23", "Var57", "CPS_24", "Var59", "CPS_25", "Var61", "CPS_26", "Var63", "CPS_27", "Var65", "CPS_28", "Var67", "CPS_29", "Var69", "CPS_30", "Var71", "CPS_31", "Var73", "CPS_32", "Var75", "CPS_33", "Var77", "CPS_34", "Var79", "CPS_35", "Var81", "CPS_36", "Var83", "CPS_37", "Var85", "CPS_38", "Var87", "CPS_39", "Var89", "CPS_40", "Var91", "CPS_41", "Var93", "CPS_42", "Var95", "CPS_43", "Var97", "CPS_44", "Var99", "CPS_45", "Var101", "CPS_46", "Var103", "CPS_47", "Var105", "CPS_48", "Var107", "CPS_49", "Var109", "CPS_50", "Var111", "CPS_51", "Var113", "CPS_52", "Var115", "CPS_53", "Var117", "CPS_54", "Var119", "CPS_55", "Var121", "CPS_56", "Var123", "CPS_57", "Var125", "CPS_58", "Var127", "CPS_59", "Var129", "CPS_60", "Var131", "CPS_61", "Var133", "CPS_62", "Var135", "CPS_63", "Var137", "CPS_64", "Var139", "CPS_65", "Var141", "CPS_66", "Var143", "CPS_67", "Var145", "CPS_68", "Var147", "CPS_69", "Var149", "CPS_70", "Var151", "CPS_71", "Var153", "CPS_72", "Var155", "CPS_73", "Var157", "CPS_74", "Var159", "CPS_75", "Var161", "CPS_76", "Var163", "CPS_77", "Var165", "CPS_78", "Var167", "CPS_79", "Var169", "CPS_80", "Var171", "CPS_81", "Var173", "CPS_82", "Var175", "CPS_83", "Var177", "CPS_84", "Var179", "CPS_85", "Var181", "CPS_86", "Var183", "CPS_87", "Var185", "CPS_88", "Var187", "CPS_89", "Var189", "CPS_90", "Var191", "CPS_91", "Var193", "CPS_92", "Var195", "CPS_93", "Var197", "CPS_94", "Var199", "CPS_95", "Var201", "CPS_96", "Var203", "CPS_97", "Var205", "CPS_98", "Var207", "CPS_99", "Var209", "CPS_100", "Var211", "CPS_101", "Var213", "CPS_102", "Var215", "CPS_103", "Var217", "CPS_104", "Var219", "CPS_105", "Var221", "CPS_106", "Var223", "CPS_107", "Var225", "CPS_108", "Var227", "CPS_109", "Var229", "CPS_110", "Var231", "CPS_111", "Var233", "CPS_112", "Var235", "CPS_113", "Var237", "CPS_114", "Var239", "CPS_115", "Var241", "CPS_116", "Var243", "CPS_117", "Var245", "CPS_118", "Var247", "CPS_119", "Var249", "CPS_120", "Var251", "CPS_121", "Var253", "CPS_122", "Var255", "CPS_123", "Var257", "CPS_124", "Var259", "CPS_125", "Var261", "CPS_126", "Var263", "CPS_127", "Var265", "CPS_128", "Var267", "CPS_129", "Var269", "CPS_130", "Var271", "CPS_131", "Var273", "CPS_132", "Var275", "CPS_133", "Var277", "CPS_134", "Var279", "CPS_135", "Var281", "CPS_136", "Var283", "CPS_137", "Var285", "CPS_138", "Var287", "CPS_139", "Var289", "CPS_140", "Var291", "CPS_141", "Var293", "CPS_142", "Var295", "CPS_143", "Var297", "CPS_144", "Var299", "CPS_145", "Var301", "CPS_146", "Var303", "CPS_147", "Var305", "CPS_148", "Var307", "CPS_149", "Var309", "CPS_150", "Var311", "CPS_151", "Var313", "CPS_152", "Var315", "CPS_153", "Var317", "CPS_154", "Var319", "CPS_155", "Var321", "CPS_156", "Var323", "CPS_157", "Var325", "CPS_158", "Var327", "CPS_159", "Var329", "CPS_160", "Var331", "CPS_161", "Var333", "CPS_162", "Var335", "CPS_163", "Var337", "CPS_164", "Var339", "CPS_165", "Var341", "CPS_166", "Var343", "CPS_167", "Var345", "CPS_168", "Var347", "CPS_169", "Var349", "CPS_170", "Var351", "CPS_171", "Var353", "CPS_172", "Var355", "CPS_173", "Var357", "CPS_174", "Var359", "CPS_175", "Var361", "CPS_176", "Var363", "CPS_177", "Var365", "CPS_178", "Var367", "CPS_179", "Var369", "CPS_180", "Var371", "CPS_181", "Var373", "CPS_182", "Var375", "CPS_183", "Var377", "CPS_184", "Var379", "CPS_185", "Var381", "CPS_186", "Var383", "CPS_187", "Var385", "CPS_188", "Var387", "CPS_189", "Var389", "CPS_190", "Var391", "CPS_191", "Var393", "CPS_192", "Var395", "CPS_193", "Var397", "CPS_194", "Var399", "CPS_195", "Var401", "CPS_196", "Var403", "CPS_197", "Var405", "CPS_198", "Var407", "CPS_199", "Var409", "CPS_200", "Var411", "CPS_201", "Var413", "CPS_202", "Var415", "CPS_203", "Var417", "CPS_204", "Var419", "CPS_205", "Var421", "CPS_206", "Var423", "CPS_207", "Var425", "CPS_208", "Var427", "CPS_209", "Var429", "CPS_210", "Var431", "CPS_211", "Var433", "CPS_212", "Var435", "CPS_213", "Var437", "CPS_214", "Var439", "CPS_215", "Var441", "CPS_216", "Var443", "CPS_217", "Var445", "CPS_218", "Var447", "CPS_219", "Var449", "CPS_220", "Var451", "CPS_221", "Var453", "CPS_222", "Var455", "CPS_223", "Var457", "CPS_224", "Var459", "CPS_225", "Var461", "CPS_226", "Var463", "CPS_227", "Var465", "CPS_228", "Var467", "CPS_229", "Var469", "CPS_230", "Var471", "CPS_231", "Var473", "CPS_232", "Var475", "CPS_233", "Var477", "CPS_234", "Var479", "CPS_235", "Var481", "CPS_236", "Var483", "CPS_237", "Var485", "CPS_238", "Var487", "CPS_239", "Var489", "CPS_240", "Var491", "CPS_241", "Var493", "CPS_242", "Var495", "CPS_243", "Var497", "CPS_244", "Var499", "CPS_245", "Var501", "CPS_246", "Var503", "CPS_247", "Var505", "CPS_248", "Var507", "CPS_249", "Var509", "CPS_250", "Var511", "CPS_251", "Var513", "CPS_252", "Var515", "CPS_253", "Var517", "CPS_254", "Var519", "CPS_255", "Var521", "CPS_256", "Var523", "CPS_257", "Var525", "CPS_258", "Var527", "CPS_259", "Var529", "CPS_260"], "EmptyFieldRule", "auto");
% Import the data
Be9Round2_CPS = table;
ranges = ["A1:TJ1", "A3:TJ7"];
for idx = 1:length(ranges)
opts.DataRange = ranges(idx);
tb = readtable("H:\mq N2O\round 2 RAW data for coding\Be9 Round 2.xlsx", opts, "UseExcel", false);
Be9Round2_CPS = [Be9Round2_CPS; tb]; %#ok<AGROW>
end
%% Convert to output type
Be9Round2_CPS = table2cell(Be9Round2_CPS);
numIdx = cellfun(@(x) ~isnan(str2double(x)), Be9Round2_CPS);
Be9Round2_CPS(numIdx) = cellfun(@(x) {str2double(x)}, Be9Round2_CPS(numIdx));
Be9CPS = Be9Round2_CPS;
%% Clear temporary variables
clear idx opts ranges tb
%% Setup the Import Options and import the data
opts = spreadsheetImportOptions("NumVariables", 531);
% Import the data
Be9Round2_RSD = table;
ranges = ["A1:TK1", "A3:TK7"];
for idx = 1:length(ranges)
opts.DataRange = ranges(idx);
tb = readtable("H:\mq N2O\round 2 RAW data for coding\Be9 Round 2.xlsx", opts, "UseExcel", false);
Be9Round2_RSD = [Be9Round2_RSD; tb]; %#ok<AGROW>
end
%% Convert to output type
Be9Round2_RSD = table2cell(Be9Round2_RSD);
numIdx = cellfun(@(x) ~isnan(str2double(x)), Be9Round2_RSD);
Be9Round2_RSD(numIdx) = cellfun(@(x) {str2double(x)}, Be9Round2_RSD(numIdx));
Be9Error = Be9Round2_RSD;
%% Clear temporary variables
clear idx opts ranges tb

Accepted Answer

Cris LaPierre
Cris LaPierre on 9 May 2020
Edited: Cris LaPierre on 9 May 2020
Yes. Is the format of your data the same in all your files? If yes, then use the import tool to generate a function instead of a script. That function can be used to automate the import process of all files with the same formatting. It appears you are already familiar with the Import Tool. If you do want to create an importing function, this video shows you how to generate and reuse your code.
And if you have a lot of files, this video shows you how to use the import function you have created in conjunction with a datastore to import multiple files.
I'd suggest reading your data in as a table instead of a cell array. This short video shows how to access data in a table.
  2 Comments
Khadouja Harouaka
Khadouja Harouaka on 11 May 2020
Thank you, that was all very helpful! I have a quick follow up question: Once the data has been uploaded and tabulated (I want to keep each datafile in a separate table for now), is there a way to call up the filename of the source data? Unfortunately the element measured is only specified in the file name and not in the data.
Cris LaPierre
Cris LaPierre on 11 May 2020
That information is not stored automatically. You could add a variable to the table to store the filename

Sign in to comment.

More Answers (1)

per isakson
per isakson on 9 May 2020

Categories

Find more on Powertrain in Help Center and File Exchange

Products


Release

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!