office

位置:IT落伍者 >> office >> 浏览文章

拼接的字符串导入EXCEL


发布日期:2020年07月24日
 
拼接的字符串导入EXCEL
StringBuilder sb = new StringBuilder()

sbAppendLine(<table><tr><th>序号</th><th>批单号</th><th>保单号</th><th>被保险人</th><th>保全项目</th><th>退费金额</th><th>保全操作日期</th><th>经办人</th></tr>

int i = ;

string str = abc;

string str = wanglei;

string str = aaa;

string time = DateTimeNowToString()

sbAppendLine(<tr><td></td><td style=\vndmsexcelnumberformat:@\> + + </td><td style=\vndmsexcelnumberformat:@\> + str + </td><td> + str + </td><td> + str + </td><td> + </td><td> + time + </td><td> + str + </td></tr>

//foreach (BillChange change in list)

//{

// sbAppendLine(<tr><td> + (i++)ToString() + </td><td style=\vndmsexcelnumberformat:@\> + changeChangeBillCode + </td><td style=\vndmsexcelnumberformat:@\> + changeBillCode + </td><td> + changeBillHolder + </td><td> + GetChangeTypeString(changeChangeType) + </td><td> + (changeReturnFee > ? changeReturnFeeToString() : ) + </td><td> + changeCreateDatetimeToString(yyyyMMdd) + </td><td> + changeCreatorName + </td></tr>

//}

sbInsert( <html><head><meta content=text/html; charset=utf httpequiv=contenttype /></head><body><table border=>

sbAppendLine(</table></body></html>

ResponseClear()

ResponseBuffer = true;

ResponseCharset = UTF;

ResponseAppendHeader(ContentDisposition attachment;filename=\ + ServerUrlEncode(保单变更信息xls) + \

ResponseContentEncoding = EncodingUTF;

ResponseContentType = application/msexcel;

ResponseWrite(sbToString())

ResponseEnd()

上一篇:PowerShell中Write族cmdlet的介绍和使用

下一篇:GhostDoc 安装与配置