If we are planning to pregnancy and if piles operation done, would that effect my process of conception?

Not related: Hemorrhoids ("piles") are present in the distal rectum/anal canal. There is no connection from the rectum to either the vagina or more proximal female organs upon which fertility, and ultimately delivery, depends. If concerned about hemorrhoids, try simple techniques for hemorrhoid relief like stool softeners, fiber supplements, sitz baths, topical agents.

Doubt it: Assuming no problems with the procedure, meds, etc., shouldn't be a problem. However, you may not be "in the mood" for a while after the procedure.