Excel name saving as a Unique name

Question

0.00/5 (No votes)

See more:

Hi,

I'm doing Excel Data Upload into SQL DB, for this i'm doing all the stuff, it's working fine for me also...

Now , my question is whenever i upload the different excel file's , i want to save any excel having a unique name...

Ex:

I'm try to upload A.xls,B.xls..., but the file should be saved in folder as xxx.xls.

this is the code for saving the excel

C#

FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string FolderPath = ConfigurationManager.AppSettings["DMSFolder"];
FilePath = Server.MapPath(FolderPath + FileName);
ViewState["FilePath"] = FilePath;
ViewState["FileName"] = FileName;
FileUpload1.SaveAs(FilePath);

How to achieve this ....

But one more thing after save the file i want to display the available sheets in that excel . so, whatever we implement for that it's wont effect to existing ...

can any body give me some suggestion...

Thanks in Advance....

Posted 5-Feb-13 23:26pm

Naveen.Sanagasetti

Updated 6-Feb-13 0:11am

v2

Add a Solution

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)

Abhinav S · Answer 1 · 2013-02-05T23:34:00

Solution 1

You could go ahead and add date and time (or a serial number) to make the file name unique.
A GUID[^] would be the most unique item (but I guess that would be overkill for your requirement).

Posted 5-Feb-13 23:34pm

Abhinav S

Comments

Naveen.Sanagasetti 6-Feb-13 6:09am

Sorry Abhinav i'm asking i upload any type of file name but i want to save the file name as xxx.xls. But one thing after save the file i displayed the sheet names available in that excel . If we change some thing in file name it wont effect on existing.

joe_j 6-Feb-13 7:11am

Could you please make the question more clear? Not quite clear about the requirement.