How to create excel file 31055.xlsx in application path

Question

0.00/5 (No votes)

See more:

.NET4.5

I work in windows form c# visual studio 2015

I have excel file xlsx and name is 3105.xlsx and i need to create it in application

path .

how to create excel file in application path

my code

C#

public void CreateSheetIfNotExists()  
       {  
           using (System.Data.OleDb.OleDbConnection databaseConnection = new System.Data.OleDb.OleDbConnection())  
           {  
  
               DataTable schemaTable = default(DataTable);  
               databaseConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=D:\\Book3105.xlsx;Mode=ReadWrite;Extended Properties=Excel 12.0 Xml;";  
  
               databaseConnection.Open();  
  
               schemaTable = databaseConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] {  
           null,  
           null,  
           "Sheet1$"  
       });  
  
               if (schemaTable.Rows.Count == 0)  
               {  
                   string SQLDDLCommand = "CREATE TABLE [Sheet1] (UserID INTEGER, UserName CHAR(255))";  
                   System.Data.OleDb.OleDbCommand excelCommand = new System.Data.OleDb.OleDbCommand(SQLDDLCommand, databaseConnection);  
                   excelCommand.ExecuteNonQuery();  
                     
               }  
              
               databaseConnection.Close();  
           }  
       }

What I have tried:

How to create Excel file 31055.xlsx in application path

Posted 23-Jan-17 13:02pm

ahmed_sa

Updated 23-Jan-17 18:34pm

Add a Solution

Comments

[no name] 23-Jan-17 19:08pm

Show the code where you have tried to create the file and tell us how the code did not do what you expect.

Dave Kreskowiak 23-Jan-17 22:10pm

You do realize that the Program Files folder (and everything under it) is ReadOnly for normal users, correct? Normal users will not be able to run this code and expect it to work because you're trying to create and write to a file in a location that is ReadOnly for those users.

1 solution

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)

Patrice T · Answer 1 · 2017-01-23T18:34:00

This question was asked a few days ago, is it you ?

Quote:
How to create Excel file 31055.xlsx in application path

Windows actively prevent this from happening for security reasons,it is to prevent malware from altering apps. No app store its own configuration in the app path, there is a reason.
Only supervisors can do this, normal users can't.

Why do you absolutely need to store this Excel file in app directory ?