91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 88.54MB
    文件類型: .zip
    金幣: 1
    下載: 0 次
    發布日期: 2023-01-28
  • 語言: C#
  • 標簽: C#??EXCEL??C#EXCEL??

資源簡介

C#使用Microsoft.Office.Interop.Excel操作EXCEL，讀取EXCEL到內存中，處理完存到新的EXCEL中。程序邏輯是根據工程內“初始文件”文件夾編寫的，所以請使用初始文件里的文件操作。處理完例子文件可能需十來分鐘。當然，可以只看代碼里面是怎么使用Microsoft.Office.Interop.Excel的。另，編碼水平有限，慎下載。

資源截圖

代碼片段和文件信息 

using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?Microsoft.Office.Interop.Excel;

namespace?ExcelProcess
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????????memoEdit1.Text?+=?“...“;
????????????memoEdit1.Text?+=?“\r\n“?+?“請選擇文件...“;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????//要求：這里Time是2002-01~2018-12，總共是17*12=204個月，要求每個月只占一行，就是總共只有204行，每一行依次（必按此順序）包含Value1-ValueNReturn1-ReturnNBeta1-BetaN，BtoM1-BtoMNLeve1-LeveN。????????????????????????????可行？先按照Time讀入一些數據，然后遇到Time不同的，就開始按列輸出，然后輸入換行符？結構體數組？
????????????
????????????if（txtNUM.Text?!=?null）
????????????{
????????????????if（!string.IsNullOrWhiteSpace（txtYuan.Text））
????????????????{
????????????????????if?（!string.IsNullOrWhiteSpace（txtSave.Text））
????????????????????{
????????????????????????//memoEdit1.Selectionstart?=?memoEdit1.Text.Length;//做筆記--定位到字符串最末尾
????????????????????????ProcessDataNew?editExcel?=?new?ProcessDataNew（Convert.ToInt32（txtNUM.Text）?txtYuan.Text?txtSave.Text）;//調用構造函數中賦值
????????????????????????memoEdit1.Text?+=?“\r\n“?+?“開始轉換...“;
????????????????????????editExcel.getColumnDB（）;//讀數據
????????????????????????memoEdit1.Text?+=?“\r\n“?+?“讀取完成，開始轉化并保存到EXCEL...“;
????????????????????????editExcel.setToExcel（）;//寫數據
????????????????????????memoEdit1.Text?+=?“\r\n“?+?“轉化完成“;
????????????????????}
????????????????}
????????????}
????????????
????????????//editExcel.getColumnDB（importExcelPath）;
????????????//editExcel.setToExcelNULL（）;
????????}
????????

????????private?void?button2_Click（object?sender?EventArgs?e）//瀏覽按鈕事件
????????{
????????????OpenFileDialog?openFileDialog?=?new?OpenFileDialog（）;
????????????if?（openFileDialog.ShowDialog（）?==?DialogResult.OK）
????????????{
????????????????txtYuan.Text?=?openFileDialog.FileName;//
????????????}
????????}

????????private?void?button3_Click（object?sender?EventArgs?e）//另一個瀏覽按鈕事件
????????{
????????????OpenFileDialog?openFileDialog?=?new?OpenFileDialog（）;
????????????if?（openFileDialog.ShowDialog（）?==?DialogResult.OK）
????????????{
????????????????txtSave.Text?=?openFileDialog.FileName;//需要新建一個EXCEL，并且注意Sheet名字與setToExcel（）中的一致
????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-07-18?12:26??ExcelProcess\
?????目錄???????????0??2019-07-18?12:19??ExcelProcess\.vs\
?????目錄???????????0??2019-07-18?12:19??ExcelProcess\.vs\ExcelProcess\
?????目錄???????????0??2019-07-18?12:19??ExcelProcess\.vs\ExcelProcess\v15\
?????文件??????222720??2019-08-02?15:10??ExcelProcess\.vs\ExcelProcess\v15\.suo
?????目錄???????????0??2019-07-18?12:19??ExcelProcess\.vs\ExcelProcess\v15\Server\
?????目錄???????????0??2019-07-22?11:19??ExcelProcess\.vs\ExcelProcess\v15\Server\sqlite3\
?????文件???????????0??2019-07-18?12:19??ExcelProcess\.vs\ExcelProcess\v15\Server\sqlite3\db.lock
?????文件?????1327104??2019-07-25?10:32??ExcelProcess\.vs\ExcelProcess\v15\Server\sqlite3\storage.ide
?????文件???????32768??2019-08-02?14:58??ExcelProcess\.vs\ExcelProcess\v15\Server\sqlite3\storage.ide-shm
?????文件?????4132392??2019-08-02?15:10??ExcelProcess\.vs\ExcelProcess\v15\Server\sqlite3\storage.ide-wal
?????目錄???????????0??2019-08-02?15:09??ExcelProcess\ExcelProcess\
?????文件????????1134??2019-07-18?12:19??ExcelProcess\ExcelProcess.sln
?????目錄???????????0??2019-07-25?10:56??ExcelProcess\ExcelProcess\bin\
?????目錄???????????0??2019-07-18?13:02??ExcelProcess\ExcelProcess\bin\Debug\
?????文件?????7093782??2019-07-25?10:56??ExcelProcess\ExcelProcess\bin\Debug.zip
?????目錄???????????0??2019-07-18?13:02??ExcelProcess\ExcelProcess\bin\Debug\de\
?????文件?????3243512??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.Data.v13.2.dll
?????文件?????1034398??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.Data.v13.2.xml
?????文件?????2443256??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.Printing.v13.2.Core.dll
?????文件??????865532??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.Printing.v13.2.Core.xml
?????文件???????43512??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.Sparkline.v13.2.Core.dll
?????文件???????20893??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.Sparkline.v13.2.Core.xml
?????文件?????4868600??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.Utils.v13.2.dll
?????文件??????512041??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.Utils.v13.2.xml
?????文件?????2724344??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.XtraEditors.v13.2.dll
?????文件?????1423737??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\DevExpress.XtraEditors.v13.2.xml
?????文件??????165368??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\de\DevExpress.Data.v13.2.resources.dll
?????文件???????12792??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\de\DevExpress.Printing.v13.2.Core.resources.dll
?????文件???????11256??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\de\DevExpress.Sparkline.v13.2.Core.resources.dll
?????文件???????25592??2018-10-09?10:29??ExcelProcess\ExcelProcess\bin\Debug\de\DevExpress.Utils.v13.2.resources.dll
............此處省略78個文件信息

評論

共有 條評論