How Do I create a New Excel File without passing file name And Copy Some Data Using C#

Question

1.71/5 (5 votes)

See more:

hi,

I want to create a new excel file without using any file name and copy some data in excel file using c# ...pls help me on this.

pls help i realy need it

thank you

Posted 20-Oct-14 9:18am

TusharZoo

Updated 21-Oct-14 5:25am

v6

Add a Solution

Comments

PIEBALDconsult 20-Oct-14 15:27pm

You'd have to give it a name.
I'd use OleDb and the ACE engine, but you can also look into EPPLUS.
There are many ways.

TusharZoo 20-Oct-14 15:51pm

thank you sir.

but i want to opan simple a new book.xlsx(ex. book1.xlsx if book1 are available then book2 will open etc) please help me..

BillWoodruff 20-Oct-14 17:45pm

You are ignoring the feedback and solutions people are giving you. Start studying.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2014-10-20T09:38:00

Solution 2

You cannot Open a new Excel file without file path, however you can create a new Excel file and write the data to it. There is a difference in both. Also note that you will always require to provide file path to open the file for working.

This article might help you to work with Excel using C#, Working with Excel Using C#[^]

Posted 20-Oct-14 9:38am

Afzaal Ahmad Zeeshan

Comments

TusharZoo 20-Oct-14 15:50pm

thank you sir.

but i want to opan simple a new book.xlsx(ex. book1.xlsx if book1 are available then book2 will open etc) please help me..

Afzaal Ahmad Zeeshan 20-Oct-14 15:55pm

Then just create a new file, don't open existing (since you don't want to pass the name) if you want to pass a name, then pass the name of the file to open. However, I am still confused, do you mean "create" by "open"?

TusharZoo 21-Oct-14 0:01am

yes sir, i want to create a new excel file without passing file name ..pls help

Afzaal Ahmad Zeeshan 21-Oct-14 10:14am

Then you can read the Article I posted, to learn how to create a new file. :)

TusharZoo 21-Oct-14 11:30am

sir,i do not want to use any location ,path or file name
in your case
MyBook = MyApp.Workbooks.Open(DB_PATH);
i am new in excel coding
pls help me i realy need it
thank you

Member 10231328 · Answer 2 · 2014-10-20T09:33:00

private void button1_Click(object sender, EventArgs e)
        {
            Excel.Application xlApp ;
            Excel.Workbook xlWorkBook ;
            Excel.Worksheet xlWorkSheet ;
            object misValue = System.Reflection.Missing.Value;

            xlApp = new Excel.Application();
            xlWorkBook = xlApp.Workbooks.Open("csharp.net-informations.xls", 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);

            MessageBox.Show(xlWorkSheet.get_Range("A1","A1").Value2.ToString());

            xlWorkBook.Close(true, misValue, misValue);
            xlApp.Quit();

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

        private void releaseObject(object obj)
        {
            try
            {
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
                obj = null;
            }
            catch (Exception ex)
            {
                obj = null;
                MessageBox.Show("Unable to release the Object " + ex.ToString());
            }
            finally
            {
                GC.Collect();
            }
        }