Page 1 of 1
export excel to editable phpgrid.
Posted: Wed Nov 19, 2008 11:54 am
by pavanpuligandla
hii,
i'm using excel as my front end, so i've to show the end user the excel sheet in an editable datagrid, which now i'm using an uneditable table using php excel reader.
i've executed phpgrid but it is rendering the values from mysql table in the grid.
i wanna render excel sheet in an editable GRID.
can anyone give me suggestions..
many thanks,
Re: export excel to editable phpgrid.
Posted: Wed Nov 19, 2008 3:58 pm
by andyhoneycutt
Let me see if I have an understanding of what you're trying to do here:
- The user has an excel document, and uses it to modify data.
- The user somehow gets this spreadsheet uploaded onto a central server.
- You want to display the data to the user, have it editable as if the user was using excel, but still retain the option of having the user edit the data in excel.
Is this what you're trying to accomplish? Thanks for any clarification!
-Andy
Re: export excel to editable phpgrid.
Posted: Thu Nov 20, 2008 5:35 am
by pavanpuligandla
hii,
The user has an excel document, and uses it to modify data.
yes the end user was provided an excel sheet for data entry.the excel sheet he's gonna use set to be a constant.
The user somehow gets this spreadsheet uploaded onto a central server.
the excel sheet once filled with data, will be rendered in a html table(not editable) for data entity recheck before upload.i'm using COM objects to open the excel file which is read by php excel reader then uploaded to the database.
You want to display the data to the user, have it editable as if the user was using excel, but still retain the option of having the user edit the data in excel.
yes, data entry and data updations will be thru excel only.
i'm now providing an option like, if he enters wrong data and uploaded it without recheking, then he has to delete entire records then upload the excel sheet again.
if you want more details, i can provide you my project snapshots..
thanks for hearing man.
regards.
Re: export excel to editable phpgrid.
Posted: Thu Nov 20, 2008 5:38 am
by pavanpuligandla
heres an example for inline editing the grid.but the data shown in the grid was retrieved from mysql table.
i dont want that, i want my excel data to be rendered in an editable grid, later can be uploaded to the mysql table.
http://phpscripts.pallettgroup.com/d...datagrid/6.php
Re: export excel to editable phpgrid.
Posted: Thu Nov 20, 2008 10:50 am
by andyhoneycutt
Ok. It sounds to me as though you will need to do one of two things to accomplish your goal:
1- Retool your datagrid class so that it uses the excel document as a datasource rather than using a mysql table
2- Use the excel document to create a temporary database table for editing purposes only and have your php datagrid class use that temporary table as it's datasource.
Frankly, I would go with option 2, working with flat files can be slow and very irritating (if columns are added it can throw your whole application off, and problems of that nature).
-Andy
Re: export excel to editable phpgrid.
Posted: Thu Nov 20, 2008 2:08 pm
by pavanpuligandla
1- Retool your datagrid class so that it uses the excel document as a datasource rather than using a mysql table
probably we cant do this task using MS-Excel as phpgrid's data source.
i think with xml data(not xml spreadsheet), there is a possibility. but i dont want to make this more complex to the end user.
if we get this loading excel sheet in the grid done, then our grid will be equivalent to Google Spreadsheets.

. i've developed my own javascript spreadsheet, but i know nothing about how to load the excel data and save the exel data.(saving is writing the excel using phpexcel)
2- Use the excel document to create a temporary database table for editing purposes only and have your php datagrid class use that temporary table as it's datasource.
yes i too thought of implementing the step-2.
the user will select the file for upload, after upload the inserted data will be shown in the grid, like writing 2 queries in the same page. then he can easily trace errors,with inline editing he can edit the record too.
after updatiing the records in the grid, then he will save the grid data as a new excel which will replace the original hardcoded excel file for future correspondence.
please let me know whether am i on the rite mode or not?
many thanks for hearing me andy,
regards.
Re: export excel to editable phpgrid.
Posted: Thu Nov 20, 2008 2:12 pm
by andyhoneycutt
I think that would be your best approach.
-Andy
Re: export excel to editable phpgrid.
Posted: Thu Nov 20, 2008 2:20 pm
by pavanpuligandla
hii,
thanks alot.
i dont why PHP is not well with handling MS components..
i think its bcoz of this popular saying
Microsoft has no beef with opensource
but using ASP.NEt we can easily render the excel data in a datagrid.
please let me know if it is possible to load excel in my spreadsheet.
if you answer is YES, then we can release our own online spreadsheet editor..(more features == more bucks..)
regards,
Re: export excel to editable phpgrid.
Posted: Thu Nov 20, 2008 4:58 pm
by andyhoneycutt
There are various PHP classes you can utilize that other people have already taken the time to put together that address the issue of reading and writing Excel documents. I'd search
phpclasses.org for some decent ones.
-Andy
Re: export excel to editable phpgrid.
Posted: Fri Nov 21, 2008 6:14 am
by pavanpuligandla
hii,
nop boss, ivent found solution for this in any site..i'm sure about it..
anyways i decided to go up with the setp-2 suggested by you..
many regards,
.