高分求用PHP操作EXCLE的例子 csv格式的话用文本打开就是这样的格式1,2,3,4,,,233,4343,fkfksf,,,,,, 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用php输出javascript语句,然后在javascript中调用execl:<script language="javascript"> function jStartExcel() { var xls = new ActiveXObject ( "Excel.Application" ); xls.visible = true; var newBook = xls.Workbooks.Add; newBook.Worksheets.Add; newBook.Worksheets(1).Activate; xls.ActiveWorkBook.ActiveSheet.PageSetup.Orientation = 2; xls.ActiveWorkBook.ActiveSheet.PageSetup.PaperSize = 5; newBook.Worksheets(1).Columns("A").columnwidth=50; newBook.Worksheets(1).Columns("A").WrapText = true; newBook.Worksheets(1).Columns("B").columnwidth=50; newBook.Worksheets(1).Columns("B").WrapText = true; newBook.Worksheets(1).Range("A1:B1000").NumberFormat = "0"; newBook.Worksheets(1).Range("A1:B1000").HorizontalAlignment = -4131; newBook.Worksheets(1).Cells(1,1).Interior.ColorIndex="15"; newBook.Worksheets(1).Cells(1,1).value="First Column, First Cell"; newBook.Worksheets(1).Cells(2,1).value="First Column, Second Cell"; newBook.Worksheets(1).Cells(1,2).value="Second Column, First Cell"; newBook.Worksheets(1).Cells(2,2).value="Second Column, Second Cell"; newBook.Worksheets(1).Name="My First WorkSheet"; } </script> http://pear.php.net/package/Spreadsheet_Excel_Writer附带例子的phpe.net的类下载里面好像也有一个 <script language="javascript"> function jStartExcel() { var xls = new ActiveXObject ( "Excel.Application" ); xls.visible = true; var newBook = xls.Workbooks.Add; newBook.Worksheets.Add; newBook.Worksheets(1).Activate; xls.ActiveWorkBook.ActiveSheet.PageSetup.Orientation = 2; xls.ActiveWorkBook.ActiveSheet.PageSetup.PaperSize = 5; newBook.Worksheets(1).Columns("A").columnwidth=50; newBook.Worksheets(1).Columns("A").WrapText = true; newBook.Worksheets(1).Columns("B").columnwidth=50; newBook.Worksheets(1).Columns("B").WrapText = true; newBook.Worksheets(1).Range("A1:B1000").NumberFormat = "0"; newBook.Worksheets(1).Range("A1:B1000").HorizontalAlignment = -4131; newBook.Worksheets(1).Cells(1,1).Interior.ColorIndex="15"; newBook.Worksheets(1).Cells(1,1).value="First Column, First Cell"; newBook.Worksheets(1).Cells(2,1).value="First Column, Second Cell"; newBook.Worksheets(1).Cells(1,2).value="Second Column, First Cell"; newBook.Worksheets(1).Cells(2,2).value="Second Column, Second Cell"; newBook.Worksheets(1).Name="My First WorkSheet"; } </script> 以上程序怎么产生的Excel里面一点信息也没有啊 用Pear里面好象有类库另外,<PHP程序设计>这本书有讲这个 你那PHP是在什么平台的?如果是win32平台,而且还要在服务器那里是安装了Excel的话,可以用COM控制Excel啊。下面是偶好久好久前写的,关键是看一下Excel中的部分定义(单元格等)<?php$workbook = "E:\\webroot\\Book.XLS"; $sheet = "bak"; #上两句是打开的Excel文件和工作表名$ex = new COM("Excel.sheet") or Die ("Did not connect"); $wkb = $ex->application->Workbooks->Open($workbook) or Die ("Did not open"); $sheets = $wkb->Worksheets($sheet);$sheets->activate;# 下面是复制表格部分$myRange1 = $sheets->range("A1:E6");# A1:E6 就是表格格式$maxi=3;# $maxi 是复制的次数 + 1for ($i=1;$i<$maxi;$i++) {$NO1="A".$i*8;$myRange2 = $sheets->range("$NO1");$myRange1->Copy($myRange2);echo "$i Doing ....<br>";}$ex->Application->ActiveWorkbook->SaveAs("Our"); #关闭,不提问 $ex->application->ActiveWorkbook->Close("False"); $ex->application->Quit();# all okunset ($ex);?> 如果要在服务器端操作EXL的话~~好像使一定要在WIN平台的~~使用excel的COM这个在MSDN中有详细说明~~ php上传文件类型如何判断?高分求解答 zend studio5.5 如何设置文件格式 关于include的问题! Mail函数发邮件,为什么我自定义发件人,却还是显示默认的呢? header是否可以改变HTML文件种类 比如404 400 200 奇怪的问题,关于php appserv php中执行die()了以后对服务器端压力不大吧 看看错在哪? 请问PHP里XPath查找出数据后如何让它不返回数据结构只返回值? 菜鸟求救,为什么调用addUser("ss");界面却没有如何的显示 php+access查询的分页显示 PHP当中大家是怎样使用imagegif()来输出gif图像的?
function jStartExcel() {
var xls = new ActiveXObject ( "Excel.Application" );
xls.visible = true;
var newBook = xls.Workbooks.Add;
newBook.Worksheets.Add;
newBook.Worksheets(1).Activate;
xls.ActiveWorkBook.ActiveSheet.PageSetup.Orientation = 2;
xls.ActiveWorkBook.ActiveSheet.PageSetup.PaperSize = 5;
newBook.Worksheets(1).Columns("A").columnwidth=50;
newBook.Worksheets(1).Columns("A").WrapText = true;
newBook.Worksheets(1).Columns("B").columnwidth=50;
newBook.Worksheets(1).Columns("B").WrapText = true;
newBook.Worksheets(1).Range("A1:B1000").NumberFormat = "0";
newBook.Worksheets(1).Range("A1:B1000").HorizontalAlignment = -4131;
newBook.Worksheets(1).Cells(1,1).Interior.ColorIndex="15";
newBook.Worksheets(1).Cells(1,1).value="First Column, First Cell";
newBook.Worksheets(1).Cells(2,1).value="First Column, Second Cell";
newBook.Worksheets(1).Cells(1,2).value="Second Column, First Cell";
newBook.Worksheets(1).Cells(2,2).value="Second Column, Second Cell";
newBook.Worksheets(1).Name="My First WorkSheet";
}
</script>
附带例子的
phpe.net的类下载里面好像也有一个
function jStartExcel() {
var xls = new ActiveXObject ( "Excel.Application" );
xls.visible = true;
var newBook = xls.Workbooks.Add;
newBook.Worksheets.Add;
newBook.Worksheets(1).Activate;
xls.ActiveWorkBook.ActiveSheet.PageSetup.Orientation = 2;
xls.ActiveWorkBook.ActiveSheet.PageSetup.PaperSize = 5;
newBook.Worksheets(1).Columns("A").columnwidth=50;
newBook.Worksheets(1).Columns("A").WrapText = true;
newBook.Worksheets(1).Columns("B").columnwidth=50;
newBook.Worksheets(1).Columns("B").WrapText = true;
newBook.Worksheets(1).Range("A1:B1000").NumberFormat = "0";
newBook.Worksheets(1).Range("A1:B1000").HorizontalAlignment = -4131;
newBook.Worksheets(1).Cells(1,1).Interior.ColorIndex="15";
newBook.Worksheets(1).Cells(1,1).value="First Column, First Cell";
newBook.Worksheets(1).Cells(2,1).value="First Column, Second Cell";
newBook.Worksheets(1).Cells(1,2).value="Second Column, First Cell";
newBook.Worksheets(1).Cells(2,2).value="Second Column, Second Cell";
newBook.Worksheets(1).Name="My First WorkSheet";
}
</script>
以上程序怎么产生的Excel里面一点信息也没有啊
另外,<PHP程序设计>这本书有讲这个
如果是win32平台,而且还要在服务器那里是安装了Excel的话,可以用COM控制Excel啊。
下面是偶好久好久前写的,关键是看一下Excel中的部分定义(单元格等)
<?php
$workbook = "E:\\webroot\\Book.XLS";
$sheet = "bak";
#上两句是打开的Excel文件和工作表名
$ex = new COM("Excel.sheet") or Die ("Did not connect");
$wkb = $ex->application->Workbooks->Open($workbook) or Die ("Did not open");
$sheets = $wkb->Worksheets($sheet);
$sheets->activate;# 下面是复制表格部分
$myRange1 = $sheets->range("A1:E6");
# A1:E6 就是表格格式
$maxi=3;
# $maxi 是复制的次数 + 1for ($i=1;$i<$maxi;$i++) {
$NO1="A".$i*8;
$myRange2 = $sheets->range("$NO1");
$myRange1->Copy($myRange2);
echo "$i Doing ....<br>";
}$ex->Application->ActiveWorkbook->SaveAs("Our");
#关闭,不提问
$ex->application->ActiveWorkbook->Close("False");
$ex->application->Quit();
# all ok
unset ($ex);
?>
好像使一定要在WIN平台的~~
使用excel的COM这个在MSDN中有详细说明~~