troubleshooting Question

Upload Excel Spreadsheets into DataGrid

Avatar of EricFleet
EricFleet asked on
ASP.NET
1 Comment1 Solution623 ViewsLast Modified:
I have several pages in an ASP.NET application where I have datagrids that users can enter information into. These datagrids have a few pre-defined columns. Some users may have this data in Excel spreadsheets on their systems. These spreadsheets may not correspond exactly with the datagrid format. They may have extra columns, differently ordered columns, etc. I would like to have some way to allow these users to upload their spreadsheet, and have it populate the datagrid.

Does anyone here have any experience with this? How did you accomplish this? Third party tools?

I am not looking for links to product web sites. I can google that. I want someone who has actually used the tool and can tell me how their implementation worked out.

Thanks
ASKER CERTIFIED SOLUTION
Ted Bouskill
Senior Software Developer
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros