.csv file is created but .xls file is not created. :(

Question

1.00/5 (2 votes)

See more:

C#

string newda = System.DateTime.Now.ToString("yyyy-MM-dd HH-mm");
string ttts = Session["username"] + newda;
Session["Filepath"] = "C:/techsoft/chart/" + ttts + ".xls";
File.AppendAllText("C:/techsoft/csv/" + ttts + ".csv", arrre[g] + "," + arrre1[g] + "\r\n");

Posted 22-Apr-13 1:47am

navin ks

Updated 23-Apr-13 2:09am

v2

Add a Solution

Comments

Sandeep Mewara 22-Apr-13 7:52am

Elaborate more on what are you trying to do.

Above code is not creating anything.

navin ks 22-Apr-13 7:56am

Session["Filepath"] = "C:/techsoft/chart/" + ttts + ".xls"; this part of code must create a .xls file in chart folder. unfortunately its not created. i dont know why. code is too large to post here

[no name] 23-Apr-13 8:14am

That is because, as you have already been told, that is just assigning a string to a session variable. You are not actually creating a file anywhere for .xls.

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)

Dave Kreskowiak · Accepted Answer · 2013-04-22T01:58:00

Solution 1

Your code is just writing a bunch of text to a .CSv file. It doesn't appear to be doing anything with an XLS file.

So, the to your question of "Why?" is because you didn't write any code to do it.

Posted 22-Apr-13 1:58am

Dave Kreskowiak

Comments

navin ks 22-Apr-13 8:01am

i need a xls file in chart folder. i need empty .xls file..

navin ks 22-Apr-13 8:01am

y cant a empty xls file be created?

Dave Kreskowiak 22-Apr-13 8:11am

BECAUSE YOU DIDN'T WRITE ANY CODE TO CREATE THE FILE!

Just specifying a filename as a string somewhere does not magically create a file at that path.

navin ks 22-Apr-13 8:13am

File.AppendAllText("C:/techsoft/csv/" + ttts + ".csv", arrre[g] + "," + arrre1[g] + "\r\n"); this part of code creates .csv file. how?

Dave Kreskowiak 22-Apr-13 8:19am

Are you elephanting kidding me?? Do you have ANY idea at all how File.AppendAllText works or even what it's used for?? If not, I suggest you try reading the documentation on it:

http://msdn.microsoft.com/en-us/library/ms143356.aspx

navin ks 22-Apr-13 8:24am

thanks to let me know about appending.

navin ks 22-Apr-13 8:24am

is there any simple way to create xls file in a specific folder

Dave Kreskowiak 22-Apr-13 10:15am

"Simple" is a subjective term. What's simple for me may be impossible to understand for you.

I therefor refer you to https://www.google.com/#output=search&sclient=psy-ab&q=create+xls+file+in+vb.net&oq=create+xls+file&gs_l=hp.3.0.0i20j0l3.11571.13511.0.14966.15.10.0.5.5.0.178.1271.4j6.10.0...0.0...1c.1.9.psy-ab.ziTDe8sPjVI&pbx=1&bav=on.2,or.r_qf.&bvm=bv.45512109,d.aWM&fp=78381bbe686eaba4&biw=1920&bih=1105