Dynamically Create Excel file using C#.net and Microsoft Excel Interop?

Question

I'm creating Excel like following:

     class Program
{
    private Excel.Application app = null;
    private Excel.Application worksheet = null;
    private Excel.Application workbook = null;
    private Excel.Application worksheet_range = null;

    //public Program()
    //{
    //    CreateExcelDoc();
    //}
    static void Main(string[] args)
    {
        Program obj = new Program();
        obj.CreateExcelDoc();
    }

    public void CreateExcelDoc()
    {
        try
        {
            app = new Excel.Application();
            if (app == null)
                return;
            app.Visible = true;
            workbook = app.Workbooks.Add(1);////error in this,saying "can not convert from Excel.Workbook to Excel.Application"

        }
        catch (Exception ex)
        {
            throw new Exception("CreateExcelDoc: Error" + ex.Message);
        }

    }
}

Could anyone pl tell where I'm going wrong? Note: I'm following this: http://msdn.microsoft.com/en-us/library/ms173186%28v=vs.80%29.aspx

Please send me any nice link/solution. I'm using Windows 7 64-bit OS.

Thanks.

Where do you declare the variable workbook and what type do you declare it as? — David
– David, Commented May 27, 2013 at 11:01

Francesco De Lisi · Accepted Answer · 2013-05-28 07:39:42Z

3

Change this declaration:

    private Excel.Application app = null;
    private Excel.Application worksheet = null;
    private Excel.Application workbook = null;
    private Excel.Application worksheet_range = null;

to:

    private Excel.Application app = null;
    private Excel.Worksheet worksheet = null;
    private Excel.Workbook workbook = null;
    private Excel.Range worksheet_range = null;

You may also follow exactly the code:

    app.Visible = true; // or false if you don't want to show app.
    workbook  = app.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
    worksheet = (Worksheet)workbook.Worksheets[1];

    // Select the Excel cells, in the range c1 to c7 in the worksheet.
    worksheet_range  = worksheet.get_Range("C1", "C7");

Edit

You can save your workbook with the following code:

    workbook.SaveAs(@"C:\XMLCopy.xls",
    Excel.XlFileFormat.xlXMLSpreadsheet, missing, missing,
    false, false, Excel.XlSaveAsAccessMode.xlNoChange,
    missing, missing, missing, missing, missing);

but look for resources release methods after Workbook save. You need to close your file, your Application and all the involved objects.

edited May 28, 2013 at 7:39

answered May 27, 2013 at 11:32

Francesco De Lisi

1,5239 silver badges20 bronze badges

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

3 Comments

bapi Over a year ago

Thank you! Now, no error and I can proceed.I hope with this I can create Excel Dynamically?

bapi Over a year ago

I do not want to make it visible, but rather to save dynamically it in particular location in disk drive.How can I do this? Also, next time when I'm going to create it application should check if the file exist or not.

Francesco De Lisi Over a year ago

These are simple task you can achieve with a little bit of MSDN and Google search. To hide your app just set app.Visible = false. For the other tasks check the link msdn.microsoft.com/en-us/library/vstudio/h1e33e36.aspx

Collectives™ on Stack Overflow

Dynamically Create Excel file using C#.net and Microsoft Excel Interop?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related