OdsHelperWriteObjectListT Method

將物件清單寫入儲存格

Definition

Namespace: eBizprise.Utility
Assembly: eBizprise.Utility.OdfHelper (in eBizprise.Utility.OdfHelper.dll) Version: 25.0.1.0+adf38c4ccb2bf98d8ad258a6278302b5e05a94ed
C#
public void WriteObjectList<T>(
	int sheetIndex,
	string cellText,
	List<T> items,
	OdsImageSetting setting
)

Parameters

sheetIndex  Int32
工作表索引(由0開始)
cellText  String
起始儲存格內容
items  ListT
欲寫入的資料集合
setting  OdsImageSetting
設定

Type Parameters

T
輸出物件類別

Example

C#
//定義寫入類別
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);
        }            
    }

Revision History

DateVersionDescription
2021/04/221.0.0.0初版

See Also