export excel to editable phpgrid.
Moderator: General Moderators
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
export excel to editable phpgrid.
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,
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,
- andyhoneycutt
- Forum Contributor
- Posts: 468
- Joined: Wed Aug 27, 2008 10:02 am
- Location: Idaho Falls
Re: export excel to editable phpgrid.
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
- 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
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: export excel to editable phpgrid.
hii,
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.
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 has an excel document, and uses it to modify data.
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.The user somehow gets this spreadsheet uploaded onto a central server.
yes, data entry and data updations will be thru excel only.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.
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.
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: export excel to editable phpgrid.
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
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
- andyhoneycutt
- Forum Contributor
- Posts: 468
- Joined: Wed Aug 27, 2008 10:02 am
- Location: Idaho Falls
Re: export excel to editable phpgrid.
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
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
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: export excel to editable phpgrid.
probably we cant do this task using MS-Excel as phpgrid's data source.1- Retool your datagrid class so that it uses the excel document as a datasource rather than using a mysql table
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.
yes i too thought of implementing the step-2.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.
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.
- andyhoneycutt
- Forum Contributor
- Posts: 468
- Joined: Wed Aug 27, 2008 10:02 am
- Location: Idaho Falls
Re: export excel to editable phpgrid.
I think that would be your best approach.
-Andy
-Andy
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: export excel to editable phpgrid.
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,
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,
- andyhoneycutt
- Forum Contributor
- Posts: 468
- Joined: Wed Aug 27, 2008 10:02 am
- Location: Idaho Falls
Re: export excel to editable phpgrid.
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
-Andy
- pavanpuligandla
- Forum Contributor
- Posts: 130
- Joined: Thu Feb 07, 2008 8:25 am
- Location: Hyderabad, India
Re: export excel to editable phpgrid.
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,
.
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,
.