Hi Everyone,
I've been having some difficulties programmaticall y assign the position of the Border in Excel sheet. I want to export the contents of another file into Excel sheet. In that file I have a Rectangle. In Excel concept we can't directly draw the Rectangle (or) Line etc.. We can draw the Rectangle by formatting the cells(ie) Assigning the border colour for the cells. My problem is I have the Top and Left value of the Rectangle. But in Excel we can draw the Borders by using the Row's and Column's value.
If anyone knows how to calculate the border position based on the Top and Left values please let me know.
Thank you in advance.
I've been having some difficulties programmaticall y assign the position of the Border in Excel sheet. I want to export the contents of another file into Excel sheet. In that file I have a Rectangle. In Excel concept we can't directly draw the Rectangle (or) Line etc.. We can draw the Rectangle by formatting the cells(ie) Assigning the border colour for the cells. My problem is I have the Top and Left value of the Rectangle. But in Excel we can draw the Borders by using the Row's and Column's value.
If anyone knows how to calculate the border position based on the Top and Left values please let me know.
Thank you in advance.