Transferring Data to Excel
Author: joannakim
Creation Date: 3/5/2011 11:24 AM
profile picture

joannakim

#1

3/5/2011 11:24 AM

Hi. Could you please tell me how I could transfer data from one of my custom data sets to Excel spreadsheet? Thanks.

Joanna
profile picture

Eugene

#2

3/5/2011 11:50 AM

What do you mean by data from your custom DataSets?
If it's what I mean, this code should help:
Data | Exporting data out of WL6 to ASCII and WL4 native binary files > "Exporting to ASCII comma-separated files (CSV)"
Import as CSV.
profile picture

andresmontoya1

#3

4/24/2014 4:50 PM

Hello guys, i have tried that method to transfer the data, but i have an error or problem in the code (i copied directly form the example on the wiki).

This is the line that have the mistake:

File.WriteAllLines(file, datalist);

The mistake --> (The best overloaded match for Sistem.IO.File.WriteAlllines (String, String[])

Thanks.
profile picture

Eugene

#4

4/25/2014 1:22 AM

The Wiki code does not have errors, just your application of it. The question is how exactly it is done in your code.
profile picture

andresmontoya1

#5

4/25/2014 12:48 PM

Thanks Eugene, I have just found the error...
profile picture

Eugene

#6

4/25/2014 2:04 PM

I guess that's because you're using an outdated and unsupported version of Wealth-Lab (6.1, am I correct?)

C#, cannot convert from 'System.Collections.Generic.IEnumerable' to 'string'

Please download and install .NET framework 4.0 (4.5 now, actually), then update Wealth-Lab to v6.6 and the error will go away.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).