Using the Aspose plugin for Excel operations
Last Update:2016-05-28
Source: Internet
Author: User
<span id="Label3"></p><p><p>Import and export an Excel document using the Aspose plugin</p></p><p><p>Excel import:</p></p><p><p>The front desk uses the file tag to get it and submit it.</p></p><pre><span style="color: #0000ff;"><span style="color: #0000ff;"><</span></span><span style="color: #800000;"><span style="color: #800000;">form</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">ID</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "form1"</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">enctype</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "multipart/form-data"</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">Method</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "post"</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">></span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"><</span></span><span style="color: #800000;"><span style="color: #800000;">Table</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">class</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "table-condensed"</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span><span style="color: #0000ff;"><span style="color: #0000ff;"><</span></span><span style="color: #800000;"><span style="color: #800000;">TR</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"><</span></span><span style="color: #800000;"><span style="color: #800000;">TD</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">class</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "text-right"</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span>Import Table:<span style="color: #0000ff;"><span style="color: #0000ff;"></</span></span><span style="color: #800000;"><span style="color: #800000;">TD</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"><</span></span><span style="color: #800000;"><span style="color: #800000;">TD</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">class</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "text-left"</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">><</span></span><span style="color: #800000;"><span style="color: #800000;">input</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">type</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "file"</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">name</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "file1"</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">class</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "btn Btn-default btn-lg"</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">/></</span></span><span style="color: #800000;"><span style="color: #800000;">TD</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></</span></span><span style="color: #800000;"><span style="color: #800000;">TR</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span><span style="color: #0000ff;"><span style="color: #0000ff;"><</span></span><span style="color: #800000;"><span style="color: #800000;">TR</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"><</span></span><span style="color: #800000;"><span style="color: #800000;">TD</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">class</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "text-left"</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"><</span></span><span style="color: #800000;"><span style="color: #800000;">input</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">type</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "submit"</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">ID</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "btnimport"</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">name</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "btnimport"</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">value</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "import"</span></span><span style="color: #ff0000;"><span style="color: #ff0000;">class</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">= "btn btn-default"</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">/></span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></</span></span><span style="color: #800000;"><span style="color: #800000;">TD</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></</span></span><span style="color: #800000;"><span style="color: #800000;">TR</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></</span></span><span style="color: #800000;"><span style="color: #800000;">Table</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></</span></span><span style="color: #800000;"><span style="color: #800000;">form</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">></span></span></pre><p><p>Background receive:</p></p><pre>HttpPostedFileBase filebase = request.files[<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">file1</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>];<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">get name here consistent with foreground label name</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(filebase! =<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span><span style="color: #000000;"><span style="color: #000000;">) { </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>filename =<span style="color: #000000;"><span style="color: #000000;">Path.getfilename (filebase.filename); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>Extension =<span style="color: #000000;"><span style="color: #000000;">path.getextension (filename); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>Path =<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">/upload/test/</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>+ DateTime.Now.ToString (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">YYYYMMDD</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>) +<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">/</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">; Directory.CreateDirectory (path.getdirectoryname (request.mappath (Path)); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>NewFileName = DateTime.Now.ToString (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">yyyymmddhhmmssfff</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>Fullfilename = path + NewFileName +<span style="color: #000000;"><span style="color: #000000;">extension; Filebase.saveas (request.mappath (fullfilename));</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Try</span></span><span style="color: #000000;"><span style="color: #000000;">{Stopwatch SW</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span>Stopwatch ();<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">record how long the import operation</span> takes</span><span style="color: #000000;"><span style="color: #000000;">SW. Start ();</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">This can be put into the BLL method to handle</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>result =<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">PRODUCTBLL (). Importexcel (request.mappath (path), newfilename, extension);</span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">BLL Method Productbll</span></span><span style="color: #000000;">public string Importexcel (string path, string filename, string Extension)<br>{<br>Workbook Workbook = new Workbook (path + filename + extension);<br>Worksheet Worksheet = Workbook. worksheets[0];<br>Cells cells = Worksheet. Cells;<br>for (int i = 1; i < Cells. rows.count; I++)<br>{<br>Try<br>{<br>String brand = cells[i, 0]. Stringvalue.trim ();//get column values<br>String years = cells[i, 1]. Stringvalue.trim ();<br>}<br>Catch (Exception E)<br>{<br>Continue<br>}<br><br>}<br>Return "ok";<br>}sw. Stop ();</span><span style="color: #0000ff;"><span style="color: #0000ff;">Long</span></span>RunTime = SW. elapsedmilliseconds/<span style="color: #800080;"><span style="color: #800080;"></span> +</span><span style="color: #000000;"><span style="color: #000000;">;}</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Catch</span></span><span style="color: #000000;"><span style="color: #000000;">(Exception e) {log.write (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Import</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>,<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Import Error</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>,<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Error Message:</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>+<span style="color: #000000;"><span style="color: #000000;">e.message); } }<br><br>Excel export:<br></span></span></pre><pre><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>Path =<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">/upload/test/</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>+ DateTime.Now.ToString (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">YYYYMMDD</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>) +<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">/</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">; Directory.CreateDirectory (path.getdirectoryname (server.mappath (Path)); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>NewFileName = DateTime.Now.ToString (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">yyyymmddhhmmssfff</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>) +<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">. xls</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>Fullfilename = Server.MapPath (path +<span style="color: #000000;"><span style="color: #000000;">newfilename);</span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">void</span></span>Exportinfo (list<test> List,<span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span><span style="color: #000000;"><span style="color: #000000;">Fullfilename) {Aspose.Cells.Workbook Workbook</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Aspose.Cells.Workbook (); Aspose.Cells.Worksheet Cellsheet</span></span>= Workbook. worksheets[<span style="color: #800080;"><span style="color: #800080;">0</span></span><span style="color: #000000;"><span style="color: #000000;">]; CellSheet.PageSetup.LeftMargin</span></span>=<span style="color: #800080;"><span style="color: #800080;">0.3</span></span><span style="color: #000000;"><span style="color: #000000;">; CellSheet.PageSetup.RightMargin</span></span>=<span style="color: #800080;"><span style="color: #800080;">0.3</span></span><span style="color: #000000;"><span style="color: #000000;">; CellSheet.PageSetup.TopMargin</span></span>=<span style="color: #800080;"><span style="color: #800080;">1</span></span><span style="color: #000000;"><span style="color: #000000;">; CellSheet.PageSetup.BottomMargin</span></span>=<span style="color: #800080;"><span style="color: #800080;">0.5</span></span><span style="color: #000000;"><span style="color: #000000;">; CellSheet.PageSetup.FooterMargin</span></span>=<span style="color: #800080;"><span style="color: #800080;">0.5</span></span><span style="color: #000000;"><span style="color: #000000;">; CellSheet.PageSetup.HeaderMargin</span></span>=<span style="color: #800080;"><span style="color: #800080;">0.5</span></span><span style="color: #000000;"><span style="color: #000000;">; CellSheet.PageSetup.Orientation</span></span>=<span style="color: #000000;"><span style="color: #000000;">pageorientationtype.landscape; CellSheet.PageSetup.CenterHorizontally</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">true</span></span><span style="color: #000000;"><span style="color: #000000;">; CellSheet.PageSetup.CenterVertically</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">true</span></span><span style="color: #000000;"><span style="color: #000000;">; cellsheet.cells[</span></span><span style="color: #800080;"><span style="color: #800080;">0</span></span>,<span style="color: #800080;"><span style="color: #800080;">0</span></span>]. Putvalue (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Item No.</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); cellsheet.cells[</span></span><span style="color: #800080;"><span style="color: #800080;">0</span></span>,<span style="color: #800080;"><span style="color: #800080;">1</span></span>]. Putvalue (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Color</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); cellsheet.cells[</span></span><span style="color: #800080;"><span style="color: #800080;">0</span></span>,<span style="color: #800080;"><span style="color: #800080;">2</span></span>]. Putvalue (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">size</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">);</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>i =<span style="color: #800080;"><span style="color: #800080;">1</span></span><span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">foreach</span></span>(<span style="color: #0000ff;"><span style="color: #0000ff;">var</span></span>Item<span style="color: #0000ff;"><span style="color: #0000ff;">inch</span></span><span style="color: #000000;"><span style="color: #000000;">List) {cellsheet.cells[i,</span></span><span style="color: #800080;"><span style="color: #800080;">0</span></span><span style="color: #000000;"><span style="color: #000000;">]. Putvalue (item.productno); cellsheet.cells[i,</span></span><span style="color: #800080;"><span style="color: #800080;">1</span></span><span style="color: #000000;"><span style="color: #000000;">]. Putvalue (item.size); cellsheet.cells[i,</span></span><span style="color: #800080;"><span style="color: #800080;">2</span></span><span style="color: #000000;"><span style="color: #000000;">]. Putvalue (item.color);</span></span>++<span style="color: #000000;"><span style="color: #000000;">; }cellsheet.autofitcolumns (); Fullfilename</span></span>=<span style="color: #000000;"><span style="color: #000000;">Path.GetFullPath (fullfilename); Workbook. Save (fullfilename);} </span></span></pre><pre><pre>Due to extracting part of the code, the layout and references are not commented in detail-----------------------------------------------------------<br>----------------------------------------------------------------------------------------------------<br>----------------------------------------------------------------------------------------------------<br>1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111<br>2223222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222<br>3333333333333333333233333333333333333333333333333333333333333333333333333333333333333333333333333333</pre></pre><p><p>cheerleader, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-</p></p><p><p>cheerleader, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-</p></p><p><p>cheerleader, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-</p></p><p><p>cheerleader, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-</p></p><p><p>cheerleader, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la, la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-la-</p></p><pre><pre><span style="color: #000000;"></span></pre></pre><p><p></p></p><p><p>Using the Aspose plugin for Excel operations</p></p></span>