Matlab data pull and save [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 4 years ago.

Improve this question

What I'm attempting to do is simple: Given an excel dataset and user defined inputs, open the associated excel file, pull the associated information for the user inputted information and save this information in a separate excel file.

I've already developed a list of values and the program recognizes user input with associated checks. I'm stuck on getting Matlab to use this information to open the correct dataset, I don't know how to get Matlab to pull a row/column in excel with a silent open and I don't know how to get it to save that data into a separate excel file. Any help would be appreciated, thank you.

3 revs · Accepted Answer · 2021-03-27 14:13:28Z

1

Consider using the functions readtable, and writetable if you have a recent MATLAB (anything more recent than R2013b). The readtable function will 'silently' read data from a specific worksheet in an Excel file into a MATLAB table variable. From there you can 'query' the table to find the specific rows you want and write the result to a new excel table with writetable.

Using readtable, you can specify the range of data with the parameters sheet and range.

requested_data = readtable(excel_file, ...
    'sheet',input_sheet_name, ...
    'range',input_data_range);

and write the data to another Excel file with

writetable(requested_data,ouput_excel_file, ...
'sheet',output_sheet_name, ...
'range',output_data_range);

Note: Remember to set the values for excel_file, input_sheet_name, input_data_range, output_excel_file, output_sheet_name, and output_data_range before running above commands.

Querying the table to access data in your table. One way would be to use ismember as in this answer.

Finally, use writetable to store the values.

See also: sheetnames, detectImportOptions, and SpreadsheetImportOptions

edited Mar 27, 2021 at 14:13

community wiki

3 revs
Azim J

Sign up to request clarification or add additional context in comments.

6 Comments

aaron Over a year ago

Is there a way to associate a value lookup with read table?

Azim J Over a year ago

@aaron: Can you define what you mean by "associate a value lookup"? or explain the process you want?

aaron Over a year ago

Similar to vlookup in excel. I'm looking to take an input, open the excel file, find the correlating cell to the input and then pull the associated data for that input from another cell.

Azim J Over a year ago

@aaron see my edits to this answer. If they don't answer your queestion maybe refocus the question to be a bit more specific with regard to what you are trying to do what 'errors' you are encountering in your code.

aaron Over a year ago

I got another question regarding this. I'm attempting to read across columns as the input fields I created will put them horizontally into the table (i.e. A1 = CO, B1 = NO, C1 = NO2). I'm attempting to do a while function loop on this so that it will run multiple iterations where it will read A1, run the script using CO as the input and then rerun it with B1. What would be the while command? I attempted While c_locations_of_interest(1,i) ~= "" where c-Locations_of_interest is a user defined table with only inputs in the columns of the first row..

|

Collectives™ on Stack Overflow

Matlab data pull and save [closed]

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related