Export into Excel File

Discussions about tools to complement CSPro data processing
Post Reply
YFT_CBSD
Posts: 48
Joined: January 3rd, 2023, 12:36 am

Export into Excel File

Post by YFT_CBSD »

Hi, how can I export the csdb data file into a Excel file but the Value display will be the label not the code?

Thanks
Gregory Martin
Posts: 1796
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Export into Excel File

Post by Gregory Martin »

You can create a batch application where the output file is an Excel file. Then, take a look at the Excel options here: https://www.csprousers.org/help/CSPro/data_sources.html

You can use the connection string property: values=labels

For example, your output file might be: MyOutput.xlsx|values=labels
khurshid.arshad
Posts: 572
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Export into Excel File

Post by khurshid.arshad »

Please see the tutorial titled "Applying Batch Application for Data Export" that i've just uploaded.

You'll discover how to export data, both with and without labels, using attributes.

https://youtu.be/lf3IqegLx9g

a.
Post Reply