The dean's office of the faculty every week lays out xlsx file with a schedule of classes for each group.

I want to write a program that, upon request, will issue a schedule for the selected day for the selected group.

The problem is that they format the schedule is not quite static, so, for one course, the cells are filled from D2, for another course, from D7. Statically blocking the location of cells with the necessary data into a program is somehow not a good idea. I came to the decision to look for cells in the A1: D7 range to determine the group to which the schedule is needed, to have a key entry, and search for the day of the week. From it you can already calculate everything and find out the location of the lectures.

enter image description here

** for row in range(1,8): for cell in range (1,15): a1= sheet.cell(row=rw, column=col).value if (a1==str(group)): startrowgroup=rw startcolgroup=col col=col+1 break rw=rw+1 **

(the idea is to preserve the position of the first record in the buffer of variables and already from this to dance with the findings).

The problem is that with revenue up to a1 = sheet.cell (row = rw, column = col) .value a1 does not get the value of the cell. (if you add the output value, it will be None)

  • can you put an example excel file somewhere? - MaxU
  • Well, skip it and take the following (plus a limit on the number of passes) - nick_n_a
  • fex.net/#!010826555166 - Sergey
  • with such formatting - this is still a task ... - MaxU
  • the actual problem is indicated in the header (“does not get value”). To understand what the problem is, create an artificial example excel file, and a complete, but minimal code example, which A1 cell is trying to read from it. The minimum reproducible example is jfs

0