a question about datastore

조회 수: 3(최근 30일)
alpedhuez 2022년 6월 18일
댓글: alpedhuez 2022년 6월 28일
Would you help me understand the point of datastore?
Suppose I read an excel sheet with muliple sheets using datastore. I want to create a table that includes all variables in Sheet 1, Sheet 2, .... How can one do this?
  댓글 수: 3
alpedhuez 2022년 6월 19일
That is true.

댓글을 달려면 로그인하십시오.

채택된 답변

Pooja Kumari
Pooja Kumari 2022년 6월 28일
Dear Alpedhuez,
It is my understanding that you want to know about the point of Database and want to create a table from excel sheet with multiple sheet that include all variable stored in Sheet 1, Sheet 2.
Datastore is a repository for collection of data that are too large to fit in memory and datastore function builds one.
A datastore is an object for reading a single file or a collection of files or data.
You can refer to the following document to get a better understanding of the same:
You can read an excel sheet with multiple sheets using ‘spreadsheetDatastore’ function.
ssds = spreadsheetDatastore(location)
%This command will create a spreadsheet Datastore object from collection of data
You can store all the variable in the excel sheet in Sheet1, Sheet2 by using this piece of code:
ds = spreadsheetDatastore("your_excel_sheet.xlsx");
ds.Sheets = [1 2]; % if your excel sheet has 2 sheet as Sheet1 and Sheet2
% If you want to take all the sheets present in your excel sheet, you can pass " " (blank string)
You can refer to the given link below for more information on spreadsheetDatastore :
Pooja Kumari
  댓글 수: 1
alpedhuez 2022년 6월 28일
Thank you. Then how can one export ds.Sheets to a table?

댓글을 달려면 로그인하십시오.

추가 답변(0개)





Community Treasure Hunt

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

Start Hunting!

Translated by