s
Contact Login Register
h M

Data Springs Modules Community Questions & Answers

Data Grid Export to Excel Broken?

I'm unable to get a usable export to excel on forms that utilize the data-grid.

It looks like the results for each data grid response is broken into separate columns, but that all other responses are included in a single non-delimited cell.

The resulting excel file seems to be pretty much unusable, is there a patch in the works or any way to get this data into a useable format?

 

 

asked 12/8/2015
Craigjb1241
Craigjb12
  • HI Craig, the data grid is stored in the database table as one big blob of data so exporting it to excel would not work too well because the columns will not align properly.

    Another option would be to actually write an SQL query to retrieve the data and copy it over to excel instead.

    Do you have access to SQL management studio or Host / SQL to write an SQL statement?

    David To
    Data Springs Technical Support - Chad Nash 12/9/2015

  • Thanks David,

    I do have that access.

    Do you happen to have any snippets that might help out with dealing with the data grid controls specifically when writing custom queries?

    Thanks again - Craigjb12 12/15/2015

  • Long-term planning and decision-making can be enhanced by engaging in online gaming. It is because y ou need to think ahead to make judgments that will help you in the long run when playing tactical games. The best decisions for your desired outcome can be made when you play these games since they train your brain to comprehend various consequences and implications of your choices. An individual will be better equipped to use these skills in the actual world if they are practiced in a virtual setting. Visit the Appxplore page or this games.lol/blog/best-tycoon-games-on-pc/ if you want to read game related topic.


    - Darden 3/10/2023

0 Answers

Your Answer

In order to provide an answer to this question, you must Login

I am flagging this question because...

10 inform moderator flags remaining

I am deleting this question because...

I am flagging this answer because...

10 inform moderator flags remaining

Flagging a Post

You have already flagged this post. Clicking "Remove Flag" below will remove your flag, thus reducing the count by one as well.

I am deleting this answer because...

Looking for a DNN Module?

If you’ve used Data Springs modules before, you know how easy they are to install and use. We have built each individual module in our collection with integration in mind, so when you opt for Collection 7.0 you’ll be able to install our entire toolbox quickly and start putting it to work for your business today.Yes, in the blink of an eye you will arrive on the scene like a Superhero!

Data Springs has long been recognized as a leader in the DotNetNuke (DNN) community through hard work, integrity, and commitment. We’ve helped thousands of people POWER UP their website and our Collection 7.0 will do the same for you.

You deserve more than just an average website. You deserve a MACHINE!

Enter your email below AND grab your spot in our big giveaway!

The winner will receive the entire Data Springs Collection 7.0 - Designed to get your website up and running like a DNN superhero (spandex not included).

Subscribe