Extract data from LL file wirh VBnet or export to excel Programatically Vbnet?

[Luis_C_Hermosillo]

Is posible to read the LL file and find some data on it programatically vbnet? Or extract de info programatically vbnet? or export by Command line from report viewer?

[jbartlau (combit - Jochen Bartlau)]

Hi Luis,

Welcome to our community!

Sure, you can use the preview API to do so. In .NET, the PreviewFile class can be used to convert the file to a text file or one of the other supported formats. You can also use a ListLabelPreviewControl and its SearchFirst to visually search for text. Does that help already ?

[Luis_C_Hermosillo]

Thanks, I’m going to try
Do you have an example of code to convert *.ll file to excel or txt?
Specifically I need to do it starting from the LL file, without prior application. The specific situation is that another program exports its files in LL format and we can only access the LL files to extract data.

[jbartlau (combit - Jochen Bartlau)]

Here’s a snippet showing the code for the conversion:

PreviewFile.ConvertTo exportTarget parameter values

Can you tell me what the valid values for the PreviewFile.ConvertTo’s exportTarget parameter are? We are LL19 right now, but switching to LL20 soon. In the code example here: It is passing in “PDF”, but I cannot find a valid list of values that can go here. Also, the example in the manual-report-generator-List-Label.pdf document doesn’t even specify this parameter. If the parameter is left off, does the ConvertTo method infer the export target from the extension in the specified filename? I…

In order to export to Excel, the preview needs to contain the required data (see this blog post for details).