[. Net C#]匯出Excel

以下為C# .Net匯出Excel範例

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Reflection;
using System.IO;
using System.Windows.Forms;

private void ExportExcel
{
    System.Web.HttpServerUtility server = System.Web.HttpContext.Current.Server;
    Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
    excelApp.Visible = false;
    excelAppUserControl = true;
    Microsoft.Office.Interop.Excel.Workbooks workbooks = excelApp.Workbooks; 
    Microsoft.Office.Interop.Excel._Workbook workbook = workbooks.Add("/test.xlsx"); //此處套用來源Excel
    Microsoft.Office.Interop.Excel.Sheets sheets = workbook.Sheets;
    Microsoft.Office.Interop.Excel._Worksheet worksheet = (Microsoft.Office.Interop.Excel._Worksheet)sheets.get_Item(1); //選擇第一個Sheet
  if (worksheet == null)
     {
       //找不到Sheet處理動作
     }
  else
     {
         //新增一欄
         Range range = worksheet.get_Range("A1", "L1");
         range.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
         worksheet.get_Range("A1", "L1").Insert(Type.Missing, Type.Missing);
  //新增一列
  Range range = worksheet.get_Range("D1", "D4");
         range.EntireColumn.Insert(Microsoft.Office.Interop.Excel.XlInsertShiftDirection.xlShiftToRight,
         Microsoft.Office.Interop.Excel.XlInsertFormatOrigin.xlFormatFromRightOrBelow);
         //合併儲存格
         worksheet.get_Range("B1", "C1").Merge(worksheet.get_Range("B1", "C1").MergeCells);
         //設定Row行 填入資料
  int row_ = 4;
         worksheet.Cells[row_, 1] = "Hello World";
  //儲存檔案
  string savaPath = "~/Temp/" + "Test.xlsx";
         workbook.SaveAs(savaPath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
         workbook.Close();
      }
}

[.Net C#]圖片上傳預覽

這邊來教大家做個資料庫式的網頁留言版系統
 首先在網頁中加入UpdatePanel及Image元件

<asp:UpdatePanel ID="UpdatePanel1" runat="server">
 <contenttemplate>
  <asp:image height="100px" id="previewImg" runat="server" visible="false" width="100px" />
 </contenttemplate>
</asp:updatepanel>

接著在圖片上傳事件寫入

if (Image_Upload.HasFile)
 {
   String FileName = Image_Upload.FileName;
   String savePath = Server.MapPath("~/UploadImage/" + FileName);
   Image_Upload.SaveAs(savePath);
   String ImgFormat =Image_Upload.FileName.Split('.')[(Image_Upload.FileName.Split('.')).Length - 1].ToUpper();
   String FileName = Image_Upload.FileName;
   String savePath = Server.MapPath("~/UploadImage/" + FileName);
   Image_Upload.SaveAs(savePath);
   if (previewImg.ImageUrl == "")
     {
       previewImg.ImageUrl = "Server端位置/UploadImage/" + FileName;
       Image.DataBind();
     }
}

這樣就會在previewImg中顯示出預覽圖~
不過當然此方法是已經把圖片上傳至伺服器中了

程式設計之路第一步

凡事起頭難 每件事畢竟都需要重頭開始學習~ 首先就先來利用Vistual Studio來撰寫最基本的HelloWorld吧

首先先開啟我們的開發工具 隨意開啟一個C#專案後 首先如下寫下程式碼

        static void Main(string[] args)
        {
            Console.WriteLine("Hello World!");
        }

編譯看看結果吧~

這樣就完成了第一個程式了~簡單吧~