一款使用于sharepoint 的excel报表组件org.in2bits.MyXls
以下是调用方法: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);
}
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;
}
页:
[1]