TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
james james
NA
419
29.8k
c# export to excel with a Specific sheet name
Nov 29 2017 2:30 PM
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
;
}
}
Reply
Answers (
9
)
calcualte diskspace performance physicalmemory usage histroy
How to connect dot net application with sFTP?