导出HTML内容以打开Office应用程序时出现问题.
大家好.
当我尝试导出HTML内容以打开Office应用程序时遇到问题.
我正在C#中使用ASP.Net.
我有一个数据表,其中一列是平均小时数".
它以字符串类型保存假定为"08:50"的值.
这意味着员工的平均工作时间为08小时50分钟.
将HTML导出到开放式Office应用程序中后,
它显示为上午08:50:00.
我认为开放办公室的默认时间格式设置为HH:MM:SS AM/PM.
当我在开放办公室中将格式更改为仅HH:MM时,则列中的值正确显示.
但是在Microsoft Office(Excel)应用程序中,没关系.
假设我的HTML内容如下-
Hello All.
I am facing a problem when I am trying to export an HTML content to open office application.
I am using ASP.Net with C#.
I have a datatable and one of it''s column is say "Average Hours".
It holds the value suppose as "08:50" as string type.
That means average hours for an employee is 08 hours and 50 minutes.
When the HTML is exported into open office application,
it is showing as 08:50:00 AM.
I think default time format for open office is set as HH:MM:SS AM/PM.
When I am changing the format to only HH:MM in open office, then values in column is showing properly.
But in Microsoft Office (Excel) application, it is all right.
Suppose my HTML content is as follows--
<table>
<tr>
<td>08:50
</td>
</tr>
</table>
有什么办法可以通过我的代码来解决此问题,而无需每次在开放式办公室中更改格式.在C#中.
请帮帮我.
非常感谢.
Is there any way to manage this problem through my code with out changing the format every time in open office. in C#.
Please help me.
Thanks a lot.