using Microsoft.Office.Interop.Excel ;
private void exportButton_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel .Application xApplication = new
Microsoft.Office.Interop.Excel .Application();
Workbook workbook =
xApplication.Workbooks.Add(XlS heetType.xlWorksheet);
Worksheet worksheet = (Worksheet)xApplication.Active Sheet;
xApplication.Visible = true;
for (int i = 1; i < purchaseReportDataGridView.Row s.Count; i++)
{
for (int j = 0; j < 13; j++)
{
worksheet.Cells[i + 1, j + 1] =
purchaseReportDataGridView.Row s[i].Cells[j].Value;
}
}
}
Never hasitate to comment or ask me.
Happy Codding .......
Microsoft.Office.Interop.Excel
Microsoft.Office.Interop.Excel
Workbook workbook =
xApplication.Workbooks.Add(XlS
Worksheet worksheet = (Worksheet)xApplication.Active
xApplication.Visible = true;
for (int i = 1; i < purchaseReportDataGridView.Row
{
for (int j = 0; j < 13; j++)
{
worksheet.Cells[i + 1, j + 1] =
purchaseReportDataGridView.Row
}
}
}
Never hasitate to comment or ask me.
Happy Codding .......
No comments:
Post a Comment