By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,899 Members | 1,230 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,899 IT Pros & Developers. It's quick & easy.

How to programmatically assign the Border position to an Excel WorkSheet using C#?

P: 1
Hi Everyone,

I've been having some difficulties programmatically 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.
Feb 22 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.