Exporting to Csv

[Ramya]

why exporting to csv file not loads correctly and how to solve this 

[Martin]

Hi Ramya,

To investigate the case I would like to ask you for more details on this scenario.

From this ticket thread, I understand that you are trying to export a CSV file. The product is marked as WordsProcessing but there is no such functionality in this library. The WordsProcessing is a processing library that allows you to create, modify, and export documents to a variety of formats, like Doc(x), RTF, HTML, PDF (export only), and Txt.

On the other hand, the SpreadProcessing library provides an option to export a Workbook (created by importing a document from an Xls(x,m) file or created by using the library`s APIs). Examples can be found in Using CsvFormatProvider.

If you are using the SpreadProcessing library could you provide more details on how the Workbook is created or if this is not the case any additional information provided will be greatly appreciated.

Regards,
Martin
Progress Telerik

[Ramya]

Thanks for u r response Martin

Actually i can't find any solution to this

While exporting report I see the data isn't correct on csv it doesn't match the Excel version of report

 

 

[Ramya]

Hi Martin

While exporting to Csv why headings are missing in this case what to do to get back headings in csv file

[Peshito]

Hello Ramaya, 

Some parts such as Page Header Section, Page Footer Section, Shape, Cross-section Item, PictureBox, Chart are ignored during processing. I believe you can find our CSV Rendering article useful and get familiar with the specifics when exporting to CSV.

Regards,
Peshito
Progress Telerik

[Ramya]

Hi

Thanks for reply

This article is helpful but  i need some more information to solve it 

[Dimitar]

Hi Ramya,

To help resolve the problem, could you please attach a copy of the report to your reply?

I would like to inspect what items are used for the headings and determine why they are not rendered to the CSV. If possible, also include some sample data that can be used to preview the report on my machine.

[Ramya]

report

[Dimitar]

Hello Ramya,

Thank you for attaching the report!

I see that the headings are located in the page header section of the report. The page sections of the report are ignored when the report is rendered to CSV and that is the reason why you do not see the headers in the generated CSV file.

For more details on the specifics of the CSV rendering extension, please visit the CSV Rendering Design Considerations at a glance - Telerik Reporting article.

As a workaround, you may put the headings in the Report Header section of the report - Report Structure at a Glance - Telerik Reporting.

i hope that this will help. Let me know if you need further assistance.