Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
c# export to excel with a Specific sheet name
james james
Nov 29 2017 2:30 PM
281
Reply
The below code when exporting to excel gives the sheet name Book1. How can i edit it to where export the sheet name as "Sams Report"?
private
void
btn_Export_Click(
object
sender, EventArgs e)
{
if
(dataGridView1.Rows.Count > 0)
{
Microsoft.Office.Interop.Excel.ApplicationClass XcelApp =
new
Microsoft.Office.Interop.Excel.ApplicationClass();
XcelApp.Application.Workbooks.Add(Type.Missing);
// Storing header part in Excel
for
(
int
i = 1; i < dataGridView1.Columns.Count + 1; i++)
{
XcelApp.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText;
}
// Storing Each row and column value to excel sheet
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.ToString();
}
}
XcelApp.Columns.AutoFit();
XcelApp.Visible =
true
;
}
}
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
calcualte diskspace performance physicalmemory usage histroy
How to connect dot net application with sFTP?