csv格式的话
用文本打开
就是这样的格式
1,2,3,4,,,
233,4343,
fkfksf,,,,,,
用文本打开
就是这样的格式
1,2,3,4,,,
233,4343,
fkfksf,,,,,,
解决方案 »
- 求助语: PHP编著的首页其中某点元素如何修改!
- 浏览器编码问题,急!
- Fatal error: Cannot instantiate non-existent class: domdocument in d:\usr\www\html\test\to.php on line 10
- 一个类值的问题
- 一个读取字符的问题
- 我需要一个生成htm的网上商店来玩
- **大家帮忙看看,我就这点分了。
- 使用HTTP_POSE_VARS['name']接受post传来参数的一个问题
- 如何用SQL语句统计得到本周的信息数量?
- 哪位兄弟有”项目可行性分析“的模板
- 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中有详细说明~~