Excel Editor in webpage

[apulmca]

Hi All,

 

I need excel like interface in a form of web page. My actual need is to copy data from MS Excel and paste it into a form. Then I will read it from cell to cell and Process it on server. I think if there is any excel editor for web is available, it should work.

 

All help will be appreciated.

 

Thanks in Advance

Apul Gupta

[Mchl]

I have done an application that processes data pasted from excel but I do it in a different way.

 

The data is pasted into textarea. Then in php script I explode() it first by line breaks, then second time by tabulation (each cell pasted into textarea is separated by tab from others). If the cell is empty, then there are two tabs, so no problem on that.

 

 

Here's code I use

$data = $_POST['data'];  //this is data from form textarea
$data = explode("\n",$DaneDokumentu['DaneAH']);   //  \n is a newline character in windows, data is exploded into rows
foreach ($data as $key => $row) {
	$data[$key] = explode("\t",$row);    // each row is further exploded into cells.
}

[apulmca]

Hi,

 

Thanks For help. It will help me.

 

But I need some more. Means, I want to display excel sheet inside the web page so that a normal user can see that he is doing work in excel otherwise he may confuse.

I think you understood my problem.

 

Thanks for your quick reply.

 

[Mchl]

I don't know anything like that, but it probably exists... After all Google Docs do have spreadsheet app.

[apulmca]

Anyways,

 

Thanks for your help for processing Excel data in PHP.

 

One more question: I know PHP and working on it from last 1 year but I think I am not using the correct way to doing work.I don't use any environment not any framework.

 

If you can guide me about the code in PHP using Zend Environment, i will be very thankful to you.

 

Thanks

Apul Gupta