BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

import excel for few defined rows up to the end of spreadsheet for columns
import excel for few defined rows up to the end of spreadsheet for columns

Hi,

I am trying to import an excel spreadsheet for few defined rows up to the end of spreadsheet for columns (number of columns change of time).

For instance, I would like to import from cell A7 and the next 4 rows (B7, C7, D7, E7) along with all columns but not the rest of the spreadsheet. I am currently using the option "cellrange()" but I do not know the proper syntax:

Code:

* Not what I want because it imports the entire spreadsheet starting from A7
import excel "0.test.xlsx", clear firstrow sheet("Beta_Query") cellrange(A7)

Can someone help? Thanks.

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / import excel for few defined rows up to the end of spreadsheet for columns
import excel for few defined rows up to the end of spreadsheet for columns

0 Response to import excel for few defined rows up to the end of spreadsheet for columns

Post a Comment

Home / Data Cleaning / Data management / Data Processing / import excel for few defined rows up to the end of spreadsheet for columns import excel for few defined rows up to the end of spreadsheet for columns

Related Posts with import excel for few defined rows up to the end of spreadsheet for columns

0 Response to import excel for few defined rows up to the end of spreadsheet for columns