How to Create Excel .xls file

Author

Message

venkatadapa

Post subject: How to Create Excel .xls file

Posted: Fri Jun 06, 2008 9:36 am

Joined: Mon May 12, 2008 11:43 am
Posts: 307

Hi friends,

I have to create a Excel file using php, if anybody knows code in php for creating word document please send me

thanks in advance

Top

samir

Post subject:

Posted: Fri Jun 06, 2008 9:57 am

Joined: Mon Nov 12, 2007 10:12 am
Posts: 355

Hi venkat,

You can create excel files using the following code
<?php
$excel = new COM("excel.application");
//Keep Excel invisible
$excel->Visible = 0;
//Create a new workbook
$wkb = $excel->Workbooks->Add();
$sheet = $wkb->Worksheets(1);
//This code adds the text 'Test' on row 2, column 4
$sheet->activate;
$cell = $sheet->Cells(2,4);
$cell->Activate;
$cell->value = 'Test';
//Save the file just like the Word file above
$wkb->SaveAs("C:\htdocs\excel123.xls");
//Quit MS Excel
$wkb->Close(false);
$excel->Workbooks->Close();
$excel->Quit();
unset($sheet);
unset($excel);
?>

Top

Page 1 of 1

[ 2 posts ]

Page 1 of 413

1, 2, 3, 4, 5 ... 413

	Replies	Views	Last post
Jquery ajax Pagination using php by rajkumar » Tue Apr 19, 2011 11:14 am in Coding Repository	8	17602	Mon May 20, 2013 2:46 am gfsdfg
Ecommerce website development and website Design by iweballey » Fri May 17, 2013 7:15 am in PHP-Code Help	0	217	Fri May 17, 2013 7:15 am iweballey
How to upgrade and migrate Joomal site by mallikharjuna rao » Mon Jan 21, 2013 1:40 pm in Joomla	1	352	Thu May 16, 2013 9:53 am sunitha12
Benefits of PHP by hirephpexpert » Fri Sep 07, 2012 4:41 am in CakePHP	6	1586	Wed May 15, 2013 6:25 am PrettyPrincesG
How to stop user from getting registered in Joomla by mallikharjuna rao » Tue Jan 22, 2013 5:16 am in Joomla	3	1518	Wed May 15, 2013 6:17 am PrettyPrincesG

Other Forums

Other Services

Search