how to open excel file in browser ,
i dont want some thing like force download dialog ,
i want to open excel in browser somthing like in gmail when u click the excel file in the inbox, it will show browser itself,
same like , how to do in php.
-
2You mean when it opens in Google Docs? That's an entire Excel clone for the web.Fanis Hatzidakis– Fanis Hatzidakis2010-10-05 07:07:56 +00:00Commented Oct 5, 2010 at 7:07
-
3Afaik, you need extensions/addons for every browser that is supposed to open Office documents (just like you need for Adobe Reader). I am not sure how available these are in anything but IE.Gordon– Gordon2010-10-05 07:26:11 +00:00Commented Oct 5, 2010 at 7:26
-
well there is an online mixrosoft office solution. but i don't know how to give documents to it and then show it to someone else because it requires a Live account. the thing in gmail is a full grown solution made by google.ITroubs– ITroubs2010-10-05 08:10:01 +00:00Commented Oct 5, 2010 at 8:10
-
Do you need to actually open the file in Excel itself, allowing the user to edit cells? Or do you simply need to display data from an Excel file in a (read-only) grid?Mark Baker– Mark Baker2010-10-05 08:28:59 +00:00Commented Oct 5, 2010 at 8:28
-
@Bharanikumar - In that case, why not look at a library such as PHPExcel that can read your Excel file and then write out a formatted, static HTML version of those worksheetsMark Baker– Mark Baker2010-10-05 08:42:18 +00:00Commented Oct 5, 2010 at 8:42
Add a comment
|
1 Answer
Using PHPExcel:
include 'PHPExcel/IOFactory.php';
$inputFileType = 'Excel5';
$inputFileName = 'MyExcelFile.xls';
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'HTML');
$objWriter->save('php://output');
exit;
EDIT
If your Excel file is Excel 2007 (xlsx) or later rather than Excel 2003 (xls) or earlier
include 'PHPExcel/IOFactory.php';
$inputFileType = 'Excel2007';
$inputFileName = 'MyExcelFile.xlsx';
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'HTML');
$objWriter->save('php://output');
exit;
4 Comments
Bharanikumar
am getting error Fatal error: Uncaught exception 'Exception' with message 'The filename test.xlsx is not recognised as an
Mark Baker
@Bharanikumar - If your file is Excel 2007 (xlsx) OpenXML format, then you need to use the appropriate reader, not the Excel5 BIFF reader of my initial example... see edit.
Bharanikumar
For exact desig aspect like gmail, we should use any css or i should call any php classes (like excel grid )
Mark Baker
@Bharanikumar - Write your own variant of the HTML Writer then, the existing code should provide the basis for what you want.
