Cannot import an excel file easily into a wingrid???

430

Luis posted over 16 years ago

I am astonished, we cannot find a simple way to import a workbook or a worksheet into a wingrid. we are working with 2007.3 but we cannot find a way to simple import as we can easily export to excel.

Is it not implemented? do we have to manually import the worksheet data cell by cell???

please, advise

490

Patrick posted over 16 years ago in reply to Jason Beres [Infragistics]

I am a little frustrated with this same topic. I understand the complexity of manipulating excel, but I would think you (Infragistics) could invest more effort into handling simple scenarios.
For example, I need to dump a grid out to excel, let the user modify the data, and then reimport the data into the grid; the structure will not change. Could you not create an API around importing data from a known excel structure? In this case it is known because your API's generated the export.
Cancel
Reply

Cancel
725

Stephan posted over 16 years ago in reply to Luis

wrongly typed in...
Cancel
Reply

Cancel
430

Luis posted over 16 years ago in reply to Jason Beres [Infragistics]

I'll send you to your email a simple workbook that breaks your excel importer. Unfortunately, we will find many similar sheets to load and your excel importer does not help so we have to use a direct connection to excel to obtain the data.I think that a default behavior could not harm if you clearly specify your limitations of each import. In most cases a user could just need to upload into a grid the same grid he/she exported some time ago but with some changes in the data. It is more harmful not having at least a way to have a dataset per worksheet available built in.Luis.-
Cancel
Reply

Cancel
19380

Jason Beres [Infragistics] posted over 16 years ago in reply to Luis

Hi Luis,
Can you help me understand what areas of the Excel import are broken? I don't think it's a bad idea to have an import with some constraints, possibly a single worksheet with contiguous data. My worry would be that a lot of spreadsheets are more complex and the majority wouldn't work that way, so the default behavior would do more harm than good. I could be wrong though. What do you think?
Thanks

Jason
Cancel
Reply

Cancel
430

Luis posted over 16 years ago in reply to Jason Beres [Infragistics]

Very interesting, can you copy and paste your comments in the brochure and advertisements of your wingrid capabilities?

There are many ways to do the reverse from excel to a grid but your grid does not support multiple layers. The minimum could be to have a worksheet automatically loaded in a wingrid under certain constrains... anyway, your poor excel wrapper get broken very easily for a wide set of 2003 excel workbooks so I understand your limitations now.

have a nice day.

Luis.-
Cancel
Reply

Cancel