IndexError: At least one sheet must be visible

when trying to write multiple tables in html to one wb it gives me this error. ur manual isnt very clear, u should refine it. how to write many tables to one wb, in same sheet or not, doesnt really matter. also, what about if tables don't have a name or id ? what should b the requirements for this ?