OdsHelperWriteObjectListT Method
將物件清單寫入儲存格
Namespace: eBizprise.UtilityAssembly: eBizprise.Utility.OdfHelper (in eBizprise.Utility.OdfHelper.dll) Version: 25.0.1.0+adf38c4ccb2bf98d8ad258a6278302b5e05a94ed
public void WriteObjectList<T>(
int sheetIndex,
string cellText,
List<T> items,
OdsImageSetting setting
)
- sheetIndex Int32
- 工作表索引(由0開始)
- cellText String
- 起始儲存格內容
- items ListT
- 欲寫入的資料集合
- setting OdsImageSetting
- 設定
- T
- 輸出物件類別
//定義寫入類別
class AssignProject
{
[OdfColumnName("客戶統編")] //對應 Ods表格 Column名稱
public string CustomerNo { get; set; }
[OdfColumnName("客戶名稱(中文)")] //對應 Ods表格 Column名稱
public string Name { get; set; }
[OdfColumnName("登記地址")]
public string CompanyAddress { get; set; }
// 其它屬性
...
}
string odsOutputFile = "..\\..\\..\\OdsOutputFile.ods";
using (FileStream stream = new FileStream("OdsHelperSample.ods", FileMode.Open))
using (OdsHelper odsHelper = OdfHelper.CreateOdsHelper(stream))
{
List<AssignProject> projects = new List<AssignProject>
{
new AssignProject{ CustomerNo="50772142", Name="金善良有限公司", CompanyAddress="台北市信義區信義路25號1樓",AssignBranch="054-信義分行",Distance="鄰近分行",AssignReasonId="存匯往來", IsDataUpdate=true, TestDate=null, TestInt=null, TestDouble=null},
new AssignProject{ CustomerNo="54590860", Name="鑫奕城有限公司", CompanyAddress="台北市大安區大安路33號1樓",AssignBranch="054-信義分行",Distance="鄰近分行",AssignReasonId="鄰近分行", IsDataUpdate=true, TestDate=DateTime.Today, TestInt=111, TestDouble=55.66d},
new AssignProject{ CustomerNo="37985086", Name="清心冷飲店", CompanyAddress="台北市松山區富錦街2號1樓",AssignBranch="不核配",Distance="鄰近分行",AssignReasonId="鄰近分行", IsDataUpdate=true, TestDate=null, TestInt=999,TestDouble=99.99d}
};
odsHelper.WriteObjectList(0, "{CustomerNo}", projects, null);
// 其它處理
odsHelper.SaveToFile(odsOutputFile);
}
}
| Date | Version | Description |
|---|
| 2021/04/22 | 1.0.0.0 | 初版 |