Upload Excel data into the database (ASP. NET automatically generates a three-tier code sixth episode)

Uploading files

String savepath = Server.MapPath ("~/upload/");//Specifies the save path of the uploaded file on the server            //checks if the physical path exists on the server, and if it does not exist, create if            (! System.IO.Directory.Exists (Savepath))            {                System.IO.Directory.CreateDirectory (savepath);            }            if (fileupload1.hasfile)            {                string fileextension = Path.getextension (this. Fileupload1.filename). ToLower ();                string filename = DateTime.Now.ToOADate () + fileextension;                Savepath = Savepath + filename;                Fileupload1.saveas (Savepath);                String aller = string. Format ("<a href= ' upload/{0} ' >upload/{0}</a>", filename);                Response.Write (aller);            }            else            {                Response.Write ("You have not yet chosen to upload the file!");            }

Excel operations

        var app = new Application {Visible = false};            Workbook Workbook = App. Workbooks.Open (Savepath);            Worksheet Worksheet = App. WORKSHEETS[1];

　　

Upload Excel data into the database (ASP. NET automatically generates a three-tier code sixth episode)