Can't get datagrid to export to CSV

Ask questions about creating Graphical User Interfaces (GUI) in PowerShell and using WinForms controls.
Forum rules
Do not post any licensing information in this forum.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
This topic is 8 years and 1 month old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked
User avatar
WEAVER84
Posts: 9
Last visit: Thu Feb 18, 2016 1:54 pm

Can't get datagrid to export to CSV

Post by WEAVER84 »

Hello,

So I can get the datagrid to display everything I want and how I want, but just can't seem to get it to export the information. It will save a CSV in the location I tell it to, just won't display the data from the datagrid into the CSV... Attached is my PSF file. I'm really new at using Powershell Studio so assuming I'm probably missing something simple.

Let me know if anyone has any questions regarding this. (I'm pretty new powershell as well... :oops: )

Thanks
Attachments
IAM1.psf
(35.89 KiB) Downloaded 189 times
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Re: Can't get datagrid to export to CSV

Post by jvierra »

Hi weaver. It takes one line:

$datagridview1.Rows | select -expand DataBoundItem | Export-Csv $savexml -NoType
User avatar
WEAVER84
Posts: 9
Last visit: Thu Feb 18, 2016 1:54 pm

Re: Can't get datagrid to export to CSV

Post by WEAVER84 »

When I use that it just gives me a blank CSV file unfortunately
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Re: Can't get datagrid to export to CSV

Post by jvierra »

How are you loading the grid?
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Re: Can't get datagrid to export to CSV

Post by jvierra »

Try this:
Attachments
Demo-DGVExport.psf
(13.84 KiB) Downloaded 218 times
User avatar
WEAVER84
Posts: 9
Last visit: Thu Feb 18, 2016 1:54 pm

Re: Can't get datagrid to export to CSV

Post by WEAVER84 »

I'm going to have to play around more this tomorrow. Can't seem to get it working with that information.

But in your example, when the form loads I should load a file? I'm wanting to create a new file though. Didn't understand that part.

I'll let you know what I come across tomorrow morning when I have some more time. Thanks for the help!
User avatar
WEAVER84
Posts: 9
Last visit: Thu Feb 18, 2016 1:54 pm

Re: Can't get datagrid to export to CSV

Post by WEAVER84 »

jvierra wrote:How are you loading the grid?
$datagridview.rows.add("randomstuff", "morerandomstuff")
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Re: Can't get datagrid to export to CSV

Post by jvierra »

You need to use objects and you need to update the data in the underlying dataset. Editing the grid does not stick until you accept the changes.
User avatar
WEAVER84
Posts: 9
Last visit: Thu Feb 18, 2016 1:54 pm

Re: Can't get datagrid to export to CSV

Post by WEAVER84 »

I was thinking it wasn't saving somewhere that's why it wasn't working... Is there an easy example of how that is supposed to be done somewhere? Otherwise I can always search around google to see what I can find.


Thanks
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Re: Can't get datagrid to export to CSV

Post by jvierra »

I attached a sample above al long to me ago.
This topic is 8 years and 1 month old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked