Page 1 of 2

Can't get datagrid to export to CSV

Posted: Wed Feb 10, 2016 1:58 pm
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

Re: Can't get datagrid to export to CSV

Posted: Wed Feb 10, 2016 2:09 pm
by jvierra
Hi weaver. It takes one line:

$datagridview1.Rows | select -expand DataBoundItem | Export-Csv $savexml -NoType

Re: Can't get datagrid to export to CSV

Posted: Wed Feb 10, 2016 2:18 pm
by WEAVER84
When I use that it just gives me a blank CSV file unfortunately

Re: Can't get datagrid to export to CSV

Posted: Wed Feb 10, 2016 2:20 pm
by jvierra
How are you loading the grid?

Re: Can't get datagrid to export to CSV

Posted: Wed Feb 10, 2016 2:22 pm
by jvierra
Try this:

Re: Can't get datagrid to export to CSV

Posted: Wed Feb 10, 2016 2:41 pm
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!

Re: Can't get datagrid to export to CSV

Posted: Wed Feb 10, 2016 6:05 pm
by WEAVER84
jvierra wrote:How are you loading the grid?
$datagridview.rows.add("randomstuff", "morerandomstuff")

Re: Can't get datagrid to export to CSV

Posted: Wed Feb 10, 2016 6:27 pm
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.

Re: Can't get datagrid to export to CSV

Posted: Thu Feb 11, 2016 6:18 am
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

Re: Can't get datagrid to export to CSV

Posted: Thu Feb 11, 2016 7:03 am
by jvierra
I attached a sample above al long to me ago.