HEllo guys,
i am using listview control in C#.
I need to create Excel file runtime and want to save all Listview content into it.
I have done some coding but i could found only
"theWorkbook = ExcelObj.Workbooks._Open(...)" method.
I couldn't find any method to create file.
I am also facing some problem in saving and closing file as the file is getting opened in 'Read Only' type.
Excel object remains undestroyed even after application close.
Code that i have written is as follows.
private void saveLog_btn_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Workbook theWorkbook;
Microsoft.Office.Interop.Excel.Worksheet worksheet;
Microsoft.Office.Interop.Excel.Application ExcelObj = null;
string strMessage = "File created at " + m_PathOfLog;
try
{
ExcelObj= new Microsoft.Office.Interop.Excel.Application();
theWorkbook = ExcelObj.Workbooks._Open(m_PathOfLog, 0, false, 5,
"", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true);
Microsoft.Office.Interop.Excel.Sheets sheets = theWorkbook.Worksheets;
worksheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1);
int i = 1;
foreach (ListViewItem currItem in lstViewResult.Items)
{
worksheet.Cells[i, 1] = i;
worksheet.Cells[i, 2] = currItem.SubItems[0].Text;
if (currItem.SubItems.Count <= 1)
{
worksheet.Cells[i, 3] = "";
}
else
{
worksheet.Cells[i, 3] = currItem.SubItems[1].Text;
}
i = i + 1;
}
ExcelObj.Save(m_PathOfLog);
ExcelObj.Workbooks.Close();
theWorkbook.Close((System.Boolean)false, m_PathOfLog, System.Type.Missing);
ExcelObj.Quit();
}
I request you to help me to find solution to this problem.
Regards,
Kedar