将数据导出到word [英] exporting data to word
问题描述
在mvc 3.0(asp.net C#)中,我通过HTML,CSS,RAZOR开发了一个工资单,并放置了服务器端变量以使其动态化。现在我想以编辑格式将其导出为MS WORD。
代码:(查看)
<前lang =CSS> < div class ='continer'>
< div class = 'header'>
< div>
< span class ='title'> PRECISE TECHNOLOGY < / span >
< span 类=slip_type>官方复制 < / span >
< span class ='titleimg'> < img src =@ Url.Content(〜/ Content / csm_logo.png)alt =No Image> < / img > < / span >
< / div >
< div class =midtext>
< br />
< br />
< span class ='payslip'>支付 Slip for month of @ Model.Month < / span > < br />
< span>优惠券否。 @ Model .EmplID / @ System。 DateTime 。现在 .Month / @ System。 DateTime 。现在。 Year .ToString()。Substring(2,2)< / span > < br />
< / div >
< div class =emp_inf>
< table>
< tr>
< td>
名称
< / td >
< td>
@ Model 。 EmplName
< / td >
< td>
名称
< / td >
< td>
@ Model 。 DeptName
< / td >
< / tr >
< tr style =border-removedsolid 3px black>
< td>总计工作 时间 < ; / td >
< td> @Model。 OverallTime < / td >
< td> Net 薪水 PKR < / td >
< td> Nil < / td > ;
< / tr >
< tr>
< td colspan =2class =td_text_Align>收入< / td >
< ; td colspan =2class =td_text_Align>扣除< / td >
< / tr >
< tr>
@ *收入部分* @
< th>描述< / th >
< th>金额 PKR < / th >
@ * Deductions部分* @
< th>描述< / th >
< th>金额 PKR < / th >
< / tr >
< tr>
@ *收入部分* @
< td class =td_height td_vertical_align>加班: @ Model 。 OverTime < / td >
< td> < / td >
@ *扣减部分* @
< td> < / td >
< td> < / td >
< / tr >
< tr>
< td class =td_text_Align>总收入< / td >
< td> PKR = < / td >
< td class =td_text_Align>扣除< / td >
< td> PKR = < / td >
< / tr >
< tr> < / tr >
< / 表格 >
< ; br />
< table class =element_borderless>
< tr >
< td class =element_borderless> HR Manager < / td >
< td class =element_borderless> _________________ < / td >
< td class =element_borderless> Net Paymnet PKR < / td >
< td class =element_borderless>
< div class =div_borderless> < / div >
< / td >
< / < span class =code-leadattribute> tr >
< tr> < / tr >
< tr >
< td class =element_borderless> ; 授权签名 < / td >
< td class =element_borderless > _________________ < / td >
< td class =element_borderless>员工签名 < / td >
< td class =element_borderless> _________________ < / td >
< / tr >
< / 表格 >
< / div >
< / div >
< / div >
< br />
< img class =scissor_imgsrc =@ Url.Content(〜/ Content / scissor.png)alt =No Image /> < hr />
< br />
@ *员工复制* @
< div class ='continer'>
< div class = 'header'>
< div>
< span class ='title'> PRECISE TECHNOLOGY < / span >
< span 类=slip_type>员工复制 < / span >
< span class ='titleimg'> < img src =@ Url.Content(〜/ Content / csm_logo.png)alt =No Image> < / img > < / span >
< / div >
< div class =midtext>
< br />
< br />
< span class ='payslip'>支付 Slip for month of @ Model.Month < / span > < br />
< span>优惠券否。 @ Model .EmplID / @ System。 DateTime 。现在 .Month / @ System。 DateTime 。现在。 Year .ToString()。Substring(2,2)< / span > < br />
< / div >
< div class =emp_inf>
< table>
< tr>
< td>
名称
< / td >
< td>
@ Model 。 EmplName
< / td >
< td>
名称
< / td >
< td>
@ Model 。 DeptName
< / td >
< / tr >
< tr style =border-removedsolid 3px black>
< td>总计工作 时间 < ; / td >
< td> @Model。 OverallTime < / td >
< td> Net 薪水 PKR < / td >
< td> Nil < / td > ;
< / tr >
< tr>
< td colspan =2class =td_text_Align>收入< / td >
< ; td colspan =2class =td_text_Align>扣除< / td >
< / tr >
< tr>
@ *收入部分* @
< th>描述< / th >
< th>金额 PKR < / th >
@ * Deductions部分* @
< th>描述< / th >
< th>金额 PKR < / th >
< / tr >
< tr>
@ *收入部分* @
< td class =td_height td_vertical_align>加班: @ Model 。 OverTime < / td >
< td> < / td >
@ *扣减部分* @
< td> < / td >
< td> < / td >
< / tr >
< tr>
< td class =td_text_Align>总收入< / td >
< td> PKR = < / td >
< td class =td_text_Align>扣除< / td >
< td> PKR = < / td >
< / tr >
< tr> < / tr >
< / 表格 >
< ; br />
< table class =element_borderless>
< tr >
< td class =element_borderless> HR Manager < / td >
< td class =element_borderless> _________________ < / td >
< td class =element_borderless> Net Paymnet PKR < / td >
< td class =element_borderless>
< div class =div_borderless> < / div >
< / td >
< / < span class =code-leadattribute> tr >
< tr> < / tr >
< tr >
< td class =element_borderless> ; 授权签名 < / td >
< td class =element_borderless > _________________ < / td >
< td class =element_borderless>员工签名 < / td >
< td class =element_borderless> _________________ < / td >
< / tr >
< / 表格 >
< / div >
< / div >
< / div >
控制器:
public ActionResult Generated_PaySlip( int ? emplID,字符串月)
{
IEnumerable< GetMonthlyReportResult> PaySlip = DataContext.GetMonthlyReport(emplID,month).ToList();
return 查看(PaySlip.FirstOrDefault());
}
OpenXML可以是使用...
检查主要网站:
http://openxmldeveloper.org/resources/ workshop / m / presentations / default.aspx
其他有用资源:
http:// www.codeproject.com/Articles/36694/Creation-of-a-Word-2007-document-using-the-Open-XM
http://msdn.microsoft.com/en-us /库/办公室/ bb656295(v = office.12)的.aspx
In mvc 3.0 (asp.net C#)I developed a payslip via HTML, CSS, RAZOR and putting server side variables to make it dynamic. Now i want to export it to MS WORD in EDITABLE FORMAT.
CODE: (VIEW)
<div class='continer'>
<div class = 'header'>
<div>
<span class ='title'> PRECISE TECHNOLOGY </span>
<span class="slip_type">Official Copy</span>
<span class ='titleimg'> <img src="@Url.Content("~/Content/csm_logo.png")" alt="No Image"></img> </span>
</div>
<div class="midtext">
<br />
<br />
<span class='payslip'>Pay Slip for the month of @Model.Month </span> <br />
<span>Voucher No. @Model.EmplID/@System.DateTime.Now.Month/@System.DateTime.Now.Year.ToString().Substring(2,2)</span> <br />
</div>
<div class="emp_inf">
<table>
<tr>
<td>
Name
</td>
<td>
@Model.EmplName
</td>
<td>
Designation
</td>
<td>
@Model.DeptName
</td>
</tr>
<tr style="border-removedsolid 3px black">
<td>Total Working Time</td>
<td>@Model.OverallTime</td>
<td>Net Salary PKR</td>
<td>Nil</td>
</tr>
<tr>
<td colspan="2" class="td_text_Align">Earning(s)</td>
<td colspan="2" class="td_text_Align">Deduction(s)</td>
</tr>
<tr>
@*Earnings Section*@
<th>Description</th>
<th>Amount PKR</th>
@*Deductions Section*@
<th>Description</th>
<th>Amount PKR</th>
</tr>
<tr>
@*Earnings Section*@
<td class="td_height td_vertical_align">Overtime: @Model.OverTime</td>
<td></td>
@*Deductions Section*@
<td></td>
<td></td>
</tr>
<tr>
<td class="td_text_Align">Total Earning(s)</td>
<td>PKR=</td>
<td class="td_text_Align">Deduction(s) </td>
<td>PKR=</td>
</tr>
<tr></tr>
</table>
<br />
<table class="element_borderless">
<tr >
<td class="element_borderless">HR Manager</td>
<td class="element_borderless">_________________</td>
<td class="element_borderless">Net Paymnet PKR</td>
<td class="element_borderless">
<div class="div_borderless"></div>
</td>
</tr>
<tr></tr>
<tr >
<td class="element_borderless">Authorized Signature</td>
<td class="element_borderless">_________________</td>
<td class="element_borderless">Employees Signature</td>
<td class="element_borderless">_________________</td>
</tr>
</table>
</div>
</div>
</div>
<br />
<img class="scissor_img" src="@Url.Content("~/Content/scissor.png")" alt="No Image"/> <hr />
<br />
@*Employee Copy*@
<div class='continer'>
<div class = 'header'>
<div>
<span class ='title'> PRECISE TECHNOLOGY </span>
<span class="slip_type">Employee Copy</span>
<span class ='titleimg'> <img src="@Url.Content("~/Content/csm_logo.png")" alt="No Image"></img> </span>
</div>
<div class="midtext">
<br />
<br />
<span class='payslip'>Pay Slip for the month of @Model.Month </span> <br />
<span>Voucher No. @Model.EmplID/@System.DateTime.Now.Month/@System.DateTime.Now.Year.ToString().Substring(2,2)</span> <br />
</div>
<div class="emp_inf">
<table>
<tr>
<td>
Name
</td>
<td>
@Model.EmplName
</td>
<td>
Designation
</td>
<td>
@Model.DeptName
</td>
</tr>
<tr style="border-removedsolid 3px black">
<td>Total Working Time</td>
<td>@Model.OverallTime</td>
<td>Net Salary PKR</td>
<td>Nil</td>
</tr>
<tr>
<td colspan="2" class="td_text_Align">Earning(s)</td>
<td colspan="2" class="td_text_Align">Deduction(s)</td>
</tr>
<tr>
@*Earnings Section*@
<th>Description</th>
<th>Amount PKR</th>
@*Deductions Section*@
<th>Description</th>
<th>Amount PKR</th>
</tr>
<tr>
@*Earnings Section*@
<td class="td_height td_vertical_align">Overtime: @Model.OverTime</td>
<td></td>
@*Deductions Section*@
<td></td>
<td></td>
</tr>
<tr>
<td class="td_text_Align">Total Earning(s)</td>
<td>PKR=</td>
<td class="td_text_Align">Deduction(s) </td>
<td>PKR=</td>
</tr>
<tr></tr>
</table>
<br />
<table class="element_borderless">
<tr >
<td class="element_borderless">HR Manager</td>
<td class="element_borderless">_________________</td>
<td class="element_borderless">Net Paymnet PKR</td>
<td class="element_borderless">
<div class="div_borderless"></div>
</td>
</tr>
<tr></tr>
<tr >
<td class="element_borderless">Authorized Signature</td>
<td class="element_borderless">_________________</td>
<td class="element_borderless">Employees Signature</td>
<td class="element_borderless">_________________</td>
</tr>
</table>
</div>
</div>
</div>
Controller:
public ActionResult Generated_PaySlip(int? emplID, String month)
{
IEnumerable<GetMonthlyReportResult> PaySlip = DataContext.GetMonthlyReport(emplID, month).ToList();
return View(PaySlip.FirstOrDefault());
}
Hi,
OpenXML can be used...
Check primary website:
http://openxmldeveloper.org/resources/workshop/m/presentations/default.aspx
Also other useful resources:
http://www.codeproject.com/Articles/36694/Creation-of-a-Word-2007-document-using-the-Open-XM
http://msdn.microsoft.com/en-us/library/office/bb656295(v=office.12).aspx
这篇关于将数据导出到word的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!