Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
How to set Border to excel when we export datagrid to excel?
Ajit N
Dec 23 2016 5:37 AM
205
Reply
Hello, i simply export the datagridview into excel. now, I want to set border to data in excel.
so how can i do this, help me for the solution.
this is the code of export datagridview to excel.
private
void
btnexport_Click(
object
sender, EventArgs e)
{
if
(dataGridView1.Rows.Count > 0)
{
Microsoft.Office.Interop.Excel._Application XcelApp =
new
Microsoft.Office.Interop.Excel.Application();
XcelApp.Application.Workbooks.Add(Type.Missing);
for
(
int
i = 1; i < dataGridView1.Columns.Count + 1; i++)
{
XcelApp.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText;
}
for
(
int
i = 0; i < dataGridView1.Rows.Count; i++)
{
for
(
int
j = 0; j < dataGridView1.Columns.Count; j++)
{
XcelApp.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value;
}
}
XcelApp.Columns.AutoFit();
XcelApp.Visible =
true
;
}
}
i want the excel in this format.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
The remote server returned an error: (403) Forbidden
com add ins go inactive mode in Excel