用php生成了excel表格,如何将表格的灰色背景框去掉(用代码实现) 一般的方法是在工具栏中去掉,我想在php代码中来实现,请教各位大虾有什么方法,先谢谢了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 莫办法php与office.application没有接口实时上也无法控制客户端打开的exel啊(这时候客户端已经启动office进程了) 用ASP或.netk吧,PHP做不了这个 这得看楼主是用什么方式打开excel了。如果用<object>方式打开服务端excel,html就可以实现。 <p><object classid="clsid:0002E559-0000-0000-C000-000000000046" id="Spreadsheet1" border="0" width="1082" height="546"> <param name="DataType" value="XMLDATA"> <param name="XMLData" value="<?xml version="1.0"?><ss:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet"> <x:ExcelWorkbook> <x:ProtectStructure>False</x:ProtectStructure> <x:ActiveSheet>0</x:ActiveSheet> </x:ExcelWorkbook> <ss:Styles> <ss:Style ss:ID="Default"> <ss:Alignment ss:Horizontal="Automatic" ss:Rotate="0.0" ss:Vertical="Bottom" ss:ReadingOrder="Context"/> <ss:Borders> </ss:Borders> <ss:Font ss:FontName="宋体" ss:Size="11" ss:Color="Automatic" ss:Bold="0" ss:Italic="0" ss:Underline="None"/> <ss:Interior ss:Color="Automatic" ss:Pattern="None"/> <ss:NumberFormat ss:Format="General"/> <ss:Protection ss:Protected="1"/> </ss:Style> </ss:Styles> <c:ComponentOptions> <c:Label> <c:Caption>Microsoft Office 电子表格</c:Caption> </c:Label> <c:MaxHeight>80%</c:MaxHeight> <c:MaxWidth>80%</c:MaxWidth> <c:NextSheetNumber>4</c:NextSheetNumber> </c:ComponentOptions> <x:WorkbookOptions> <c:OWCVersion>11.0.0.8166 </c:OWCVersion> <x:Height>14446</x:Height> <x:Width>28628</x:Width> </x:WorkbookOptions> <ss:Worksheet ss:Name="Sheet1"> <x:WorksheetOptions> <x:Selected/> <x:ViewableRange>R1:R262144</x:ViewableRange> <x:Selection>R6C4</x:Selection> <x:TopRowVisible>0</x:TopRowVisible> <x:LeftColumnVisible>0</x:LeftColumnVisible> <x:ProtectContents>False</x:ProtectContents> </x:WorksheetOptions> <c:WorksheetOptions> </c:WorksheetOptions> <ss:Table ss:DefaultColumnWidth="54.0" ss:DefaultRowHeight="12.75"> </ss:Table> </ss:Worksheet> <ss:Worksheet ss:Name="Sheet2"> <x:WorksheetOptions> <x:ViewableRange>R1:R262144</x:ViewableRange> <x:Selection>R1C1</x:Selection> <x:TopRowVisible>0</x:TopRowVisible> <x:LeftColumnVisible>0</x:LeftColumnVisible> <x:ProtectContents>False</x:ProtectContents> </x:WorksheetOptions> <c:WorksheetOptions> </c:WorksheetOptions> <ss:Table ss:DefaultColumnWidth="54.0" ss:DefaultRowHeight="12.75"> </ss:Table> </ss:Worksheet> <ss:Worksheet ss:Name="Sheet3"> <x:WorksheetOptions> <x:ViewableRange>R1:R262144</x:ViewableRange> <x:Selection>R1C1</x:Selection> <x:TopRowVisible>0</x:TopRowVisible> <x:LeftColumnVisible>0</x:LeftColumnVisible> <x:ProtectContents>False</x:ProtectContents> </x:WorksheetOptions> <c:WorksheetOptions> </c:WorksheetOptions> <ss:Table ss:DefaultColumnWidth="54.0" ss:DefaultRowHeight="12.75"> </ss:Table> </ss:Worksheet></ss:Workbook>"> <param name="AllowPropertyToolbox" value="-1"> <param name="AutoFit" value="0"> <param name="Calculation" value="-4105"> <param name="Caption" value="Microsoft Office 电子表格"> <param name="DisplayColumnHeadings" value="-1"> <param name="DisplayGridlines" value="-1"> <param name="DisplayHorizontalScrollBar" value="-1"> <param name="DisplayOfficeLogo" value="-1"> <param name="DisplayPropertyToolbox" value="0"> <param name="DisplayRowHeadings" value="-1"> <param name="DisplayTitleBar" value="0"> <param name="DisplayToolbar" value="-1"> <param name="DisplayVerticalScrollBar" value="-1"> <param name="DisplayWorkbookTabs" value="-1"> <param name="EnableEvents" value="-1"> <param name="MaxHeight" value="80%"> <param name="MaxWidth" value="80%"> <param name="MoveAfterReturn" value="-1"> <param name="MoveAfterReturnDirection" value="-4121"> <param name="RightToLeft" value="0"> <param name="ScreenUpdating" value="-1"> <param name="LockedDown" value="0"> <param name="ConnectedToChart" value="0"> <param name="DefaultQueryOnLoad" value="-1"> <param name="EnableUndo" value="-1"> <table width='100%' cellpadding='0' cellspacing='0' border='0' height='8'><tr><td height='25' width='10%'> </td><td width='85%'><font face='宋体' color='white' size='4'><b> 缺少 Microsoft Office Web Components</b></font></td></tr><tr><td width='15'> </td><td width='500px'><br> <font face='宋体' size='2'>此网页要求 Microsoft Office Web Components。<p align='center'> <a href='http://xxx/office2003/office/files/owc11/setup.exe'>单击此处安装 Microsoft Office Web Components。</a>.</p></font><p><font face='宋体' size='2'>此网页同时要求 Microsoft Internet Explorer 5.01 或更高版本。</p><p align='center'><a href='http://www.microsoft.com/windows/ie/default.htm'> 单击此处安装最新的 Internet Explorer</a>.</font><br> </td></tr></table></object></p> 顶上面的;如果是在服务端控制生成Excel文件的格式,生成以后不改变,是有办法;可以在Excel中生成一个你需要的格式的文件,保存为xml格式的;只要用PHP输出这个XML文件,用EXCEL打开就可以了,当然数据是可以替换; phpadmin怎么用? 这样的问题真不知道怎么解决 显示ip地址的问题!! php能否利用路径映射 服务器端对上传文件的大小有限制,不修改配置如何上传大文件? 100分求救!急!空白页面,死活调试不好! apache+php+sqlserver的配置问题 ★★★如何在PHP中实现分页显示代码★★★ 新手上路,请教我一招 phpadmin 急--为什么我装上scriptx后,好象没有factory.printing(即没找到printing的属性) 安装了easyphp在本机.局域网的其他电脑怎样才可以看到我的网页?
实时上也无法控制客户端打开的exel啊(这时候客户端已经启动office进程了)
这得看楼主是用什么方式打开excel了。如果用<object>方式打开服务端excel,html就可以实现。
<p>
<object classid="clsid:0002E559-0000-0000-C000-000000000046" id="Spreadsheet1" border="0" width="1082" height="546">
<param name="DataType" value="XMLDATA">
<param name="XMLData" value="<?xml version="1.0"?>
<ss:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet">
<x:ExcelWorkbook>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ActiveSheet>0</x:ActiveSheet>
</x:ExcelWorkbook>
<ss:Styles>
<ss:Style ss:ID="Default">
<ss:Alignment ss:Horizontal="Automatic" ss:Rotate="0.0" ss:Vertical="Bottom"
ss:ReadingOrder="Context"/>
<ss:Borders>
</ss:Borders>
<ss:Font ss:FontName="宋体" ss:Size="11" ss:Color="Automatic" ss:Bold="0"
ss:Italic="0" ss:Underline="None"/>
<ss:Interior ss:Color="Automatic" ss:Pattern="None"/>
<ss:NumberFormat ss:Format="General"/>
<ss:Protection ss:Protected="1"/>
</ss:Style>
</ss:Styles>
<c:ComponentOptions>
<c:Label>
<c:Caption>Microsoft Office 电子表格</c:Caption>
</c:Label>
<c:MaxHeight>80%</c:MaxHeight>
<c:MaxWidth>80%</c:MaxWidth>
<c:NextSheetNumber>4</c:NextSheetNumber>
</c:ComponentOptions>
<x:WorkbookOptions>
<c:OWCVersion>11.0.0.8166 </c:OWCVersion>
<x:Height>14446</x:Height>
<x:Width>28628</x:Width>
</x:WorkbookOptions>
<ss:Worksheet ss:Name="Sheet1">
<x:WorksheetOptions>
<x:Selected/>
<x:ViewableRange>R1:R262144</x:ViewableRange>
<x:Selection>R6C4</x:Selection>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x:ProtectContents>False</x:ProtectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="54.0" ss:DefaultRowHeight="12.75">
</ss:Table>
</ss:Worksheet>
<ss:Worksheet ss:Name="Sheet2">
<x:WorksheetOptions>
<x:ViewableRange>R1:R262144</x:ViewableRange>
<x:Selection>R1C1</x:Selection>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x:ProtectContents>False</x:ProtectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="54.0" ss:DefaultRowHeight="12.75">
</ss:Table>
</ss:Worksheet>
<ss:Worksheet ss:Name="Sheet3">
<x:WorksheetOptions>
<x:ViewableRange>R1:R262144</x:ViewableRange>
<x:Selection>R1C1</x:Selection>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x:ProtectContents>False</x:ProtectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="54.0" ss:DefaultRowHeight="12.75">
</ss:Table>
</ss:Worksheet>
</ss:Workbook>
">
<param name="AllowPropertyToolbox" value="-1">
<param name="AutoFit" value="0">
<param name="Calculation" value="-4105">
<param name="Caption" value="Microsoft Office 电子表格">
<param name="DisplayColumnHeadings" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScrollBar" value="-1">
<param name="DisplayOfficeLogo" value="-1">
<param name="DisplayPropertyToolbox" value="0">
<param name="DisplayRowHeadings" value="-1">
<param name="DisplayTitleBar" value="0">
<param name="DisplayToolbar" value="-1">
<param name="DisplayVerticalScrollBar" value="-1">
<param name="DisplayWorkbookTabs" value="-1">
<param name="EnableEvents" value="-1">
<param name="MaxHeight" value="80%">
<param name="MaxWidth" value="80%">
<param name="MoveAfterReturn" value="-1">
<param name="MoveAfterReturnDirection" value="-4121">
<param name="RightToLeft" value="0">
<param name="ScreenUpdating" value="-1">
<param name="LockedDown" value="0">
<param name="ConnectedToChart" value="0">
<param name="DefaultQueryOnLoad" value="-1">
<param name="EnableUndo" value="-1">
<table width='100%' cellpadding='0' cellspacing='0' border='0' height='8'><tr><td height='25' width='10%'> </td><td width='85%'><font face='宋体' color='white' size='4'><b> 缺少 Microsoft Office Web Components</b></font></td></tr><tr><td width='15'> </td><td width='500px'><br> <font face='宋体' size='2'>此网页要求 Microsoft Office Web Components。<p align='center'> <a href='http://xxx/office2003/office/files/owc11/setup.exe'>单击此处安装 Microsoft Office Web Components。</a>.</p></font><p><font face='宋体' size='2'>此网页同时要求 Microsoft Internet Explorer 5.01 或更高版本。</p><p align='center'><a href='http://www.microsoft.com/windows/ie/default.htm'> 单击此处安装最新的 Internet Explorer</a>.</font><br> </td></tr></table></object>
</p>
如果是在服务端控制生成Excel文件的格式,生成以后不改变,是有办法;
可以在Excel中生成一个你需要的格式的文件,保存为xml格式的;
只要用PHP输出这个XML文件,用EXCEL打开就可以了,当然数据是可以替换;