@ I van Veen: thanks for the update in MatrixForm.

@ Hi Narjes,

What have you tried? To understand you correctly, please post your code and Excel file in the future.

This should work: 1 = the first sheet, 7;;13 = from row 7 to row 13, 2 = column 2.

Import["C:\\Users\\.....Directory\\filename.xlsx"][[1, 7 ;; 13, 2]]

I hope this will help !

Best Regards,..... Jos

Can we use these with an Excel file ? I want to extract and export elements from a specific range of a spreadsheet in an Excel file. I know that I can use "Import" and "Export" but I would like to put them in a specific case (for example, from B7 to B13)

Hi, it actually helped me, thank you. Now to export. Well here is my code :

Module[
 {
  \[Alpha] = 50,
  \[Beta] = 100,
  c = 10,
  b = 0.05,
  e = 100,
  k = 100,
  a = 10000,
  s = Import[
     "C:\Users\User\Desktop\PFE\31instances de Tmoy\emissions \
adjustment\Classeur1.xlsx"][[1, 7 ;; 13, 2]],
  t = 0.01*s,
  m,
  f
  },
 (*m=(a+ \[Alpha] p[[n-1]]- \[Alpha] c - (Length[t]-n) \
a)/(\[Alpha](b+(Length[t]-n+1)t[n]- Sum[t[[i]],{i,n+1, Length[t]}]));*)


 f[x0_, pList_] := (pList[[1]] - 
      c - (b + t[[1]]) x0) (a - \[Alpha] pList[[1]]) +
   Sum[ (pList[[i]] - 
       c - (b + t[[i]]) x0) (a - \[Beta]  pList[[
         i]] + \[Beta]  pList[[i - 1]] - \[Alpha] pList[[i]]), {i, 2, 
     Length[t]}] - k (e - x0)^2;


 Maximize[
  {f[\[FormalX], Array[\[FormalP], Length[t]]],
   And @@ Thread[Array[\[FormalP], Length[t]] > 0] && 
    And @@ Table[
      a - \[Beta] (\[FormalP][i] + \[FormalP][
            i - 1]) - \[Alpha] \[FormalP][i] > 0, {i, 2, 5}]
    && (\[FormalX] > 0)
   },
  Flatten[{\[FormalX], Array[\[FormalP], Length[t]]}]
  ]
 ]

Now I want to export the results (values of f, x and p(n)) in the Excel file I have joined below, in specific rows. How do I do that ?

Attachments:

Hi, Actually no, it is not what i want. I think I can not assign the values I imported from the xls file to a variable I can use in the program. For the results, I would like to put them in the spreadsheets already in the file, in the columns where there is D2. In each spreadsheet I have results to put in many columns..

exportdata = Block[{cnt = 1}, Map[(# ->  data[[cnt++]]) &, sheetnames]];

You like to live dangerously ;-) I prefer a more succinct solution:

exportdata = MapThread[Rule, {sheetnames, data}]

You must correct an error in the second row - third column. It must be $b[[3]]$ instead of $b[{3]]$.

Thanks for sharing the overview. Other ways of accessing elements would be Extract, and a special case Diagonal. Last elements can also be obtained by Part using -1 as the index. Then there is also the special case: the index = 0 to get the head.