Looping increasing cellranges and importing to stata

[Recep Taskin]

Hi everyone
ı deeply searched about my problem but ı couldnt find a solution.
Here is my problem about importing from excel.

ı have 21 sectors and 132 monthly excel files. I want to import for every sector(j) with different cell range. cell range begins with cellrange(A15:I19) for the first sector and row increases by 7, column increases by 7. but ı cant put these increasing cell ranges to loop.
First sector j=1 cellrange(A15:I19)
Second sector j=2 cellrange(A22:I26)


forval j= 1/21{

forval i= 1/132{
import excel using C:\Users\a`i'.xls, sheet(blabla) cellrange(A15:I19) clear


gen sectorid = `j'
gen time = `i'
save s`j'`i'.dta,replace

}

}
thanks for your kindly response.

[Andrew Musau]

local cell 15
forval j= 1/21{
    forval i= 1/132{
        import excel using C:\Users\a`i'.xls, sheet(blabla) cellrange(A`cell':I`=`cell'+4') clear
        gen sectorid = `j'
        gen time = `i'
        save s`j'`i'.dta,replace
        local cell=cond(`cell'>925, 15, `cell'+7)
   }
}

CHECK:

local cell 15
forval j= 1/21{
    forval i= 1/132{
        di "`j'  - `i' -`cell'"
        local cell=cond(`cell'>925, 15, `cell'+7)
   }
}

Res.:

. forval j= 1/21{
  2. 
.     forval i= 1/132{
  3. 
.         di "`j'  - `i' -`cell'"
  4. 
.         local cell=cond(`cell'>925, 15, `cell'+7)
  5. 
.    }
  6. 
. }
1  - 1 -15
1  - 2 -22
1  - 3 -29
1  - 4 -36
1  - 5 -43
1  - 6 -50
1  - 7 -57
1  - 8 -64
1  - 9 -71
1  - 10 -78
1  - 11 -85
1  - 12 -92
1  - 13 -99
1  - 14 -106
1  - 15 -113
1  - 16 -120
1  - 17 -127
1  - 18 -134
1  - 19 -141
1  - 20 -148
1  - 21 -155
1  - 22 -162
1  - 23 -169
1  - 24 -176
1  - 25 -183
1  - 26 -190
1  - 27 -197
1  - 28 -204
1  - 29 -211
1  - 30 -218
1  - 31 -225
1  - 32 -232
1  - 33 -239
1  - 34 -246
1  - 35 -253
1  - 36 -260
1  - 37 -267
1  - 38 -274
1  - 39 -281
1  - 40 -288
1  - 41 -295
1  - 42 -302
1  - 43 -309
1  - 44 -316
1  - 45 -323
1  - 46 -330
1  - 47 -337
1  - 48 -344
1  - 49 -351
1  - 50 -358
1  - 51 -365
1  - 52 -372
1  - 53 -379
1  - 54 -386
1  - 55 -393
1  - 56 -400
1  - 57 -407
1  - 58 -414
1  - 59 -421
1  - 60 -428
1  - 61 -435
1  - 62 -442
1  - 63 -449
1  - 64 -456
1  - 65 -463
1  - 66 -470
1  - 67 -477
1  - 68 -484
1  - 69 -491
1  - 70 -498
1  - 71 -505
1  - 72 -512
1  - 73 -519
1  - 74 -526
1  - 75 -533
1  - 76 -540
1  - 77 -547
1  - 78 -554
1  - 79 -561
1  - 80 -568
1  - 81 -575
1  - 82 -582
1  - 83 -589
1  - 84 -596
1  - 85 -603
1  - 86 -610
1  - 87 -617
1  - 88 -624
1  - 89 -631
1  - 90 -638
1  - 91 -645
1  - 92 -652
1  - 93 -659
1  - 94 -666
1  - 95 -673
1  - 96 -680
1  - 97 -687
1  - 98 -694
1  - 99 -701
1  - 100 -708
1  - 101 -715
1  - 102 -722
1  - 103 -729
1  - 104 -736
1  - 105 -743
1  - 106 -750
1  - 107 -757
1  - 108 -764
1  - 109 -771
1  - 110 -778
1  - 111 -785
1  - 112 -792
1  - 113 -799
1  - 114 -806
1  - 115 -813
1  - 116 -820
1  - 117 -827
1  - 118 -834
1  - 119 -841
1  - 120 -848
1  - 121 -855
1  - 122 -862
1  - 123 -869
1  - 124 -876
1  - 125 -883
1  - 126 -890
1  - 127 -897
1  - 128 -904
1  - 129 -911
1  - 130 -918
1  - 131 -925
1  - 132 -932
2  - 1 -15
2  - 2 -22
2  - 3 -29
2  - 4 -36
2  - 5 -43
2  - 6 -50
2  - 7 -57
2  - 8 -64
2  - 9 -71
2  - 10 -78
2  - 11 -85
2  - 12 -92
2  - 13 -99
2  - 14 -106
2  - 15 -113
2  - 16 -120
2  - 17 -127
2  - 18 -134
2  - 19 -141
2  - 20 -148
2  - 21 -155
2  - 22 -162
2  - 23 -169
2  - 24 -176
2  - 25 -183
2  - 26 -190
2  - 27 -197
2  - 28 -204
2  - 29 -211
2  - 30 -218
2  - 31 -225
2  - 32 -232
2  - 33 -239
2  - 34 -246
2  - 35 -253
2  - 36 -260
2  - 37 -267
2  - 38 -274
2  - 39 -281
2  - 40 -288
2  - 41 -295
2  - 42 -302
2  - 43 -309
2  - 44 -316
2  - 45 -323
2  - 46 -330
2  - 47 -337
2  - 48 -344
2  - 49 -351
2  - 50 -358
2  - 51 -365
2  - 52 -372
2  - 53 -379
2  - 54 -386
2  - 55 -393
2  - 56 -400
2  - 57 -407
2  - 58 -414
2  - 59 -421
2  - 60 -428
2  - 61 -435
2  - 62 -442
2  - 63 -449
2  - 64 -456
2  - 65 -463
2  - 66 -470
2  - 67 -477
2  - 68 -484
2  - 69 -491
2  - 70 -498
2  - 71 -505
2  - 72 -512
2  - 73 -519
2  - 74 -526
2  - 75 -533
2  - 76 -540
2  - 77 -547
2  - 78 -554
2  - 79 -561
2  - 80 -568
2  - 81 -575
2  - 82 -582
2  - 83 -589
2  - 84 -596
2  - 85 -603
2  - 86 -610
2  - 87 -617
2  - 88 -624
2  - 89 -631
2  - 90 -638
2  - 91 -645
2  - 92 -652
2  - 93 -659
2  - 94 -666
2  - 95 -673
2  - 96 -680
2  - 97 -687
2  - 98 -694
2  - 99 -701
2  - 100 -708
2  - 101 -715
2  - 102 -722
2  - 103 -729
2  - 104 -736
2  - 105 -743
2  - 106 -750
2  - 107 -757
2  - 108 -764
2  - 109 -771
2  - 110 -778
2  - 111 -785
2  - 112 -792
2  - 113 -799
2  - 114 -806
2  - 115 -813
2  - 116 -820
2  - 117 -827
2  - 118 -834
2  - 119 -841
2  - 120 -848
2  - 121 -855
2  - 122 -862
2  - 123 -869
2  - 124 -876
2  - 125 -883
2  - 126 -890
2  - 127 -897
2  - 128 -904
2  - 129 -911
2  - 130 -918
2  - 131 -925
2  - 132 -932
3  - 1 -15
3  - 2 -22
3  - 3 -29
3  - 4 -36
3  - 5 -43
3  - 6 -50
3  - 7 -57
3  - 8 -64
3  - 9 -71
3  - 10 -78
3  - 11 -85
3  - 12 -92
3  - 13 -99
3  - 14 -106
3  - 15 -113
3  - 16 -120
3  - 17 -127
3  - 18 -134
3  - 19 -141
3  - 20 -148
3  - 21 -155
3  - 22 -162
3  - 23 -169
3  - 24 -176
3  - 25 -183
3  - 26 -190
3  - 27 -197
3  - 28 -204
3  - 29 -211
3  - 30 -218
3  - 31 -225
3  - 32 -232
3  - 33 -239
3  - 34 -246
3  - 35 -253
3  - 36 -260
3  - 37 -267
3  - 38 -274
3  - 39 -281
3  - 40 -288
3  - 41 -295
3  - 42 -302
3  - 43 -309
3  - 44 -316
3  - 45 -323
3  - 46 -330
3  - 47 -337
3  - 48 -344
3  - 49 -351
3  - 50 -358
3  - 51 -365
3  - 52 -372
3  - 53 -379
3  - 54 -386
3  - 55 -393
3  - 56 -400
3  - 57 -407
3  - 58 -414
3  - 59 -421
3  - 60 -428
3  - 61 -435
3  - 62 -442
3  - 63 -449
3  - 64 -456
3  - 65 -463
3  - 66 -470
3  - 67 -477
3  - 68 -484
3  - 69 -491
3  - 70 -498
3  - 71 -505
3  - 72 -512
3  - 73 -519
3  - 74 -526
3  - 75 -533
3  - 76 -540
3  - 77 -547
3  - 78 -554
3  - 79 -561
3  - 80 -568
3  - 81 -575
3  - 82 -582
3  - 83 -589
3  - 84 -596
3  - 85 -603
3  - 86 -610
3  - 87 -617
3  - 88 -624
3  - 89 -631
3  - 90 -638
3  - 91 -645
3  - 92 -652
3  - 93 -659
3  - 94 -666
3  - 95 -673
3  - 96 -680
3  - 97 -687
3  - 98 -694
3  - 99 -701
3  - 100 -708
3  - 101 -715
3  - 102 -722
3  - 103 -729
3  - 104 -736
3  - 105 -743
3  - 106 -750
3  - 107 -757
3  - 108 -764
3  - 109 -771
3  - 110 -778
3  - 111 -785
3  - 112 -792
3  - 113 -799
3  - 114 -806
3  - 115 -813
3  - 116 -820
3  - 117 -827
3  - 118 -834
3  - 119 -841
3  - 120 -848
3  - 121 -855
3  - 122 -862
3  - 123 -869
3  - 124 -876
3  - 125 -883
3  - 126 -890
3  - 127 -897
3  - 128 -904
3  - 129 -911
3  - 130 -918
3  - 131 -925
3  - 132 -932
4  - 1 -15
4  - 2 -22
4  - 3 -29
4  - 4 -36
4  - 5 -43
4  - 6 -50
4  - 7 -57
4  - 8 -64
4  - 9 -71
4  - 10 -78
4  - 11 -85
4  - 12 -92
4  - 13 -99
4  - 14 -106
4  - 15 -113
4  - 16 -120
4  - 17 -127
4  - 18 -134
4  - 19 -141
4  - 20 -148
4  - 21 -155
4  - 22 -162
4  - 23 -169
4  - 24 -176
4  - 25 -183
4  - 26 -190
4  - 27 -197
4  - 28 -204
4  - 29 -211
4  - 30 -218
4  - 31 -225
4  - 32 -232
4  - 33 -239
4  - 34 -246
4  - 35 -253
4  - 36 -260
4  - 37 -267
4  - 38 -274
4  - 39 -281
4  - 40 -288
4  - 41 -295
4  - 42 -302
4  - 43 -309
4  - 44 -316
4  - 45 -323
4  - 46 -330
4  - 47 -337
4  - 48 -344
4  - 49 -351
4  - 50 -358
4  - 51 -365
4  - 52 -372
4  - 53 -379
4  - 54 -386
4  - 55 -393
4  - 56 -400
4  - 57 -407
4  - 58 -414
4  - 59 -421
4  - 60 -428
4  - 61 -435
4  - 62 -442
4  - 63 -449
4  - 64 -456
4  - 65 -463
4  - 66 -470
4  - 67 -477
4  - 68 -484
4  - 69 -491
4  - 70 -498
4  - 71 -505
4  - 72 -512
4  - 73 -519
4  - 74 -526
4  - 75 -533
4  - 76 -540
4  - 77 -547
4  - 78 -554
4  - 79 -561
4  - 80 -568
4  - 81 -575
4  - 82 -582
4  - 83 -589
4  - 84 -596
4  - 85 -603
4  - 86 -610
4  - 87 -617
4  - 88 -624
4  - 89 -631
4  - 90 -638
4  - 91 -645
4  - 92 -652
4  - 93 -659
4  - 94 -666
4  - 95 -673
4  - 96 -680
4  - 97 -687
4  - 98 -694
4  - 99 -701
4  - 100 -708
4  - 101 -715
4  - 102 -722
4  - 103 -729
4  - 104 -736
4  - 105 -743
4  - 106 -750
4  - 107 -757
4  - 108 -764
4  - 109 -771
4  - 110 -778
4  - 111 -785
4  - 112 -792
4  - 113 -799
4  - 114 -806
4  - 115 -813
4  - 116 -820
4  - 117 -827
4  - 118 -834
4  - 119 -841
4  - 120 -848
4  - 121 -855
4  - 122 -862
4  - 123 -869
4  - 124 -876
4  - 125 -883
4  - 126 -890
4  - 127 -897
4  - 128 -904
4  - 129 -911
4  - 130 -918
4  - 131 -925
4  - 132 -932

[Recep Taskin]

Thanks a lot Andrew
But ı am misundertood. cell range changes only according to the sectors(j) not also according to time(i). But you gave me the idea of using cellrange(A`cell':I`=`cell'+4').

So ı corrected mine. and it is

forval j= 1/21{

forval i= 1/132{
import excel using C:\Users\a`i'.xls, sheet(blabla) cellrange(A`=8+7*`j'':G`=8+7*`j'+4') clear


gen sectorid = `j'
gen time = `i'
save s`j'`i'.dta,replace

}

}

and it worked.