Can't write to excel using C#?

Question

I am writing a very simple program. It runs without any errors. But nothing is written into the Excel file. Am I wrong somewhere?

  using Excel = Microsoft.Office.Interop.Excel;

  // I already add this reference into my project

  public Write()
  {
        Excel.Application xlApp;
        Excel.Workbook xlWorkBook;
        Excel.Worksheet xlWorkSheet;
        object misValue = System.Reflection.Missing.Value;

        xlApp = new Excel.Application();
        xlWorkBook = xlApp.Workbooks.Open(Directory.GetCurrentDirectory() + "\\KKK.xlsx", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
        xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

        // This is all I want to write to my Excel file

        xlWorkSheet.Cells[1, 1] = "input";

        xlWorkBook.SaveAs(Directory.GetCurrentDirectory() + "\\KQ" + ThoiGian(), Excel.XlFileFormat.xlWorkbookDefault, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
        xlWorkBook.Close(true, misValue, misValue);
        xlApp.Quit();

        releaseObject(xlApp);
        releaseObject(xlWorkBook);
        releaseObject(xlWorkSheet);
}

Tarik · Accepted Answer · 2013-10-04 05:11:38Z

1

Try

xlWorkSheet.Cells[1, 1].value = "input";

answered Oct 4, 2013 at 5:11

Tarik

11.2k2 gold badges31 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Tarik Over a year ago

xlApp.Visible = True will show the sheet. Comment out the code that closes the workbook. Visually check if data has been written

Diep Tu Khuong Over a year ago

Still nothing Tarik . I used to write like this and they all work fine until today . Something must be wrong somewhere...

Diep Tu Khuong Over a year ago

It works on another PC just fine. Very nice guess Tarik. I still have no idea whats going on with my PC. thanks for your help though !

Tarik Over a year ago

Try your code in a vbscript to determine if it is a .net specific issue.

Collectives™ on Stack Overflow

Can't write to excel using C#?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related