Advertisement
eric11144

sheet value judgment

Jun 26th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. if (sheet['A'+row_str].value and
  2. sheet['B'+row_str].value and
  3. sheet['C'+row_str].value and
  4. sheet['D'+row_str].value and
  5. sheet['E'+row_str].value and
  6. sheet['F'+row_str].value and
  7. sheet['G'+row_str].value)
  8.  
  9. if (sheet['A'+row_str].value and
  10. sheet['B'+row_str].value and
  11. sheet['C'+row_str].value is None and
  12. sheet['D'+row_str].value is None and
  13. sheet['E'+row_str].value is None and
  14. sheet['F'+row_str].value is None):
  15.  
  16. elif (
  17. sheet['A'+row_str].value is None and
  18. sheet['B'+row_str].value is None and
  19. sheet['C'+row_str].value and
  20. sheet['D'+row_str].value and
  21. sheet['E'+row_str].value and
  22. sheet['F'+row_str].value):
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement