Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How Can I Use the Data in a Spreadsheet with Matrix Functions? (How Do I Copy Data Efficiently from Spreadsheets to Matrices, and Back?

April 26, 2017copy Data efficiently functions matrices matrix spreadsheet Spreadsheets

0

Posted

How Can I Use the Data in a Spreadsheet with Matrix Functions? (How Do I Copy Data Efficiently from Spreadsheets to Matrices, and Back?

1 Answer

0

Posted

STATISTICA Visual Basic contains several functions to quickly move columns (variables), rows (cases), or the entire data matrix from spreadsheets to dimensioned arrays, and back. The following example shows how you can use the .VData(variable), CData(case), and .Data properties of the spreadsheet object to retrieve particular columns (variables) or rows (cases) of data from the respective spreadsheet, or to copy the entire data matrix.