一款使用于sharepoint 的excel报表组件org.in2bits.MyXls

mac2022-06-30 18

以下是调用方法:

public void GenBudgetRpt(FinBudgetBalanceRptDTO rptObject) { rptObject.RptName = "Report name : Budget Balance report";string formatDate = string.Format("{0:dd/MM/yyyy}", DateTime.Now); rptObject.CutoffDate = "Cut off date: " + formatDate; rptObject.Department = "Department: " + rptObject.Department; XlsReportManager.Send<FinBudgetBalanceRptDTO>(rptObject); } [Serializable]public class FinBudgetBalanceRptDTO {public string RptName { get; set; }public string CutoffDate { get; set; } // temporarliy use LastUpdatedDate public string Department { get; set; }public List<FinBudgetBalanceDTO> BudgetBalanceDTOs { get; set; } }

XlsReportStyleManager和XlsReportManager请看附件.

下面是XlsReportManager会调用的xml文件

<xsl-report name="FIN Budget Summary" type="Report.FinBudgetBalanceRptDTO"><XF name="XF1"><Font Bold="true"/></XF><XF name="XF2"><Font Bold="true"/><HorizontalAlignment value="Centered"/></XF><XF name="XF3"><HorizontalAlignment value="Right"/></XF><Worksheet name="Budgets Report"><ColumnInfo ColumnIndexStart="0" ColumnIndexEnd="7" Width="4500"></ColumnInfo><Cells><cell row="1" column="1"><value name="RptName"/></cell><cell row="2" column="1"><value name="CutoffDate"/></cell><cell row="3" column="1"><value name="Department"/></cell><cell row="5" column="1" XF="XF1">Budget code</cell><cell row="5" column="2" XF="XF1">Budget name</cell><cell row="5" column="3" XF="XF1">Budget owner</cell><cell row="5" column="4" XF="XF2">Total budget</cell><cell row="5" column="5" XF="XF2">Total ER approved</cell><cell row="5" column="6" XF="XF2">ER in process</cell><cell row="5" column="7" XF="XF2">Budget balance</cell><cell row="5" column="8" XF="XF2">Budget Available</cell><muti-cell beginRow="6" column="1"><list name="BudgetBalanceDTOs" item="BudgetCode"/></muti-cell><muti-cell beginRow="6" column="2"><list name="BudgetBalanceDTOs" item="BudgetName"/></muti-cell><muti-cell beginRow="6" column="3"><list name="BudgetBalanceDTOs" item="BudgetOwner"/></muti-cell><muti-cell beginRow="6" column="4" XF="XF3"><list name="BudgetBalanceDTOs" item="TotalBudget"/></muti-cell><muti-cell beginRow="6" column="5" XF="XF3"><list name="BudgetBalanceDTOs" item="TotalERApproved"/></muti-cell><muti-cell beginRow="6" column="6" XF="XF3"><list name="BudgetBalanceDTOs" item="ERInProcess"/></muti-cell><muti-cell beginRow="6" column="7" XF="XF3"><list name="BudgetBalanceDTOs" item="BudgetBalance"/></muti-cell><muti-cell beginRow="6" column="8" XF="XF3"><list name="BudgetBalanceDTOs" item="BudgetAvailable"/></muti-cell></Cells></Worksheet></xsl-report>

MyXls.zip BTW, 当点击按钮导出xls之后, 无论按任何按钮都会死在那里,解决方法, 在按钮里面加入下script:

function PosExport(obj,msg) {if (!confirm(msg))return false; _spOriginalFormAction = obj.form.action; _spSuppressFormOnSubmitWrapper = true;return true; }

转载于:https://www.cnblogs.com/Forest-zhu/archive/2011/11/30/2269409.html