Showing results for tags 'excel'.

How to find Image Height and width using PHP saved as Excel?

aveeva posted a topic in PHP Coding Help

I have folder with 100's images, how to find Height and width as Excel sheet?

PHP - MySQL Data Output to MS Excel

Dear Forum Members, I'm trying to create a snippet of PHP code which can select a specific number of rows from a Database table (Database "formulier", "tables under invoer"), and output this data into a .cvs file. The script: export.php This script will be running on a website, where after people click on a button and submit a client-specfic ID and Last Name, they get a .csv to download for administrative use. Needless to say, I want the script to generate a .csv file with all entries (different dates of entries, total 23 variables) of one ID-number from the database. I've started to work on this, and whilst it works for the larger part, I'm really stuck at the moment. I hope that some of you can shed some light on the issue. Attached are the scripts I'm currently running. formulier.htmlinsert.php Please note that they're definetly not final, and still insecure. That's not the issue right now. Kind regards,

April 18, 2014
3 replies
- php
- mysql
- (and 3 more)
  Tagged with:
  - php
  - mysql
  - excel
  - database
  - microsoft

Read Excel sheet and store in database

Dharmender posted a topic in Frameworks

I have a form where user uploads file i.e. Excel Sheet The data read from sheet is to be store in mysql database. The headers location is not fixed. So I need to search the header with the mysql table column name. Records below header are to be inserted into database. How can I search teh header row in Excel using cakephp

Export HTML table to excel using PHP

Dharmender posted a topic in PHP Coding Help

I have generated HTML table from Mysql data using PHP. I want to export this table to Excel. I have 'googled' a lot but not satisfied with it.

January 11, 2013
5 replies
- php
- excel
- (and 1 more)
  Tagged with:
  - php
  - excel
  - mysql

Displaying a selected excel file's content in a webpage using php

nandakishor posted a topic in PHP Coding Help

I am sorry, If I am asking a basic question.. I am working for a project where I need to give a upload and submit option for client. In that client will browse the local path and selects required "EXCEL" file and if they click to submit, then the content should be displayed in the webpage.. these are few codes I went through, but I thought I am not in the right way.. <HTML> <HEAD> <TITLE> PHP File Upload Script </TITLE> </HEAD> <BODY> <?php if( isset($_POST['submit1'])) { // $_FILES is the array auto filled when you upload a file and submit a form. $userfile_name = $_FILES['file1']['name']; // file name $userfile_tmp = $_FILES['file1']['tmp_name']; // actual location $userfile_size = $_FILES['file1']['size']; // file size $userfile_type = $_FILES['file1']['type']; // mime type of file sent by browser. PHP doesn't check it. $userfile_error = $_FILES['file1']['error']; // any error!. get from here // Content uploading. $file_data = ''; if ( !empty($userfile_tmp)) { // We encode the data just to make it more database friendly $file_data = base64_encode(@fread(fopen($userfile_tmp, 'r'), filesize($userfile_tmp))); } switch (true) { // Check error if any case ($userfile_error == UPLOAD_ERR_NO_FILE): case empty($file_data): echo 'You must select a document to upload before you can save this page.'; exit; break; case ($userfile_error == UPLOAD_ERR_INI_SIZE): case ($userfile_error == UPLOAD_ERR_FORM_SIZE): echo 'The document you have attempted to upload is too large.'; break; case ($userfile_error == UPLOAD_ERR_PARTIAL): echo 'An error occured while trying to recieve the file. Please try again.'; break; } if( !empty($userfile_tmp)) { // only MS office and text file is accepted. if( !(($userfile_type=="application/msword") || ($userfile_type=="text/plain") || ($userfile_type=="application/vnd.ms-excel")) ) {echo 'Your File Type is:'. $userfile_type; echo '<br>File type must be text(.txt) or msword(.doc).'; exit; } } echo filesize($userfile_tmp); } echo ?> <form name="profile" method="POST" action="<?php echo $_SERVER['PHP_SELF'] ?>" target="_self" enctype="multipart/form-data" > <P align ="center"><input type="hidden" name="MAX_FILE_SIZE" value="1000000"> <input type="file" name="file1" value="AttachFile" device="files" accept="text/*" tabindex=18 > <input type="submit" name="submit1" value="Submit" /> </P> </form> </BODY> </HTML> from the above code I am getting only file size.. This code will displays the content of excel file but it is a hard coded one, but I need client should select that file and content get displayed in the webpage itself... <?php error_reporting(E_ALL ^ E_NOTICE); require_once 'excel_reader2.php'; $data = new Spreadsheet_Excel_Reader("test.xls"); php echo $data->dump(true,true); ?> Thanks in advance...

January 8, 2013
1 reply
- php
- javascript
- (and 2 more)
  Tagged with:
  - php
  - javascript
  - jqery
  - excel

Excel Page To Php

cutielou22 posted a topic in PHP Coding Help

I am trying to help my mom with her site and we came across a problem with a Excel Page. My mom had information in a Excel document then clicked somewhere in Excel to make it into a webpage. It made it into a .htm page and when I go to add php to it for the layout it doesn't work - It just shows the layout then and no info. Here is the page coding (Internments.htm): <?php $pagetitle = "Saint Michaels Cemetery"; include("../layout/header.php"); ECHO <<<END <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta name="Excel Workbook Frameset"> <meta http-equiv=Content-Type content="text/html; charset=us-ascii"> <meta name=ProgId content=Excel.Sheet> <meta name=Generator content="Microsoft Excel 12"> <link rel=File-List href="Internments_files/filelist.xml"> <![if !supportTabStrip]> <link id="shLink" href="Internments_files/sheet001.htm"> <link id="shLink" href="Internments_files/sheet002.htm"> <link id="shLink" href="Internments_files/sheet003.htm"> <link id="shLink"> <script language="Javascript">  </script> <![endif]> </head> <frameset rows="*,39" border=0 width=0 frameborder=no framespacing=0> <frame src="Internments_files/sheet001.htm" name="frSheet"> <frame src="Internments_files/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0> <noframes> <body> <p>This page uses frames, but your browser doesn't support them.</p> </body> </noframes> </frameset> </html> END; include("../layout/footer.php"); ?> It works fine without the php stuff. . . but then it doesn't have the layout.

October 29, 2012
6 replies
- excel
- php
- (and 1 more)
  Tagged with:
  - excel
  - php
  - html

Sign In

Search the Community

Search By Tags

Search By Author

Content Type

Forums

Find results in...

Find results that contain...

Date Created

Start

End

Last Updated

Start

End

Filter by number of...

Minimum number of comments

Minimum number of replies

Joined

Start

End

Group

AIM

MSN

Website URL

ICQ

Yahoo

Jabber

Skype

Location

Interests

Age

Donation Link

Important Information