Unplanned
Last Updated: 15 Jul 2020 16:37 by ADMIN
Denny
Created on: 05 May 2020 08:00
Category: SpreadProcessing
Type: Feature Request
0
SpreadProcessing: Supplement the document structure in order to be the same as the latest Excel version

Hi Telerik,

 

I would like to request 1 feature to be added in Current RADGRID control which is to exporting grid data to into Excel 2016 version.

We need this feature because one of our supporting application will work only with  Excel 2016 version, where as the current RADGRID conversion only able to export to EXCEL 2007 (excel 12) format.

 

Thank you.

 

 

10 comments
ADMIN
Attila Antal
Posted on: 15 Jul 2020 16:37

Hi Denny,

Please excuse us for the delayed response. 

I have created a Web-based version of the application shared by Martin and attached it back to my response. In this application, instead of calling the export methods, the application gets access to the Export Structure, write it into a file, updates the Version, and finally, it prompts the result for downloading. 

I hope this will be helpful.

Kind regards,
Attila Antal
Progress Telerik

Denny
Posted on: 21 May 2020 10:12

Hi Martin,

 

We are exporting RADgrid using "Telerik.Web.UI" by calling "MasterTableView.ExportToExcel()" function.

Can you advised how to integrate the code which you have provided ?

 

Thank you so much and Have a good day.

 

Denny

Denny
Posted on: 21 May 2020 10:11

Hi Martin,

 

The code which you provided seems

 

We are exporting RADgrid using "Telerik.Web.UI" by calling "MasterTableView.ExportToExcel()" function.

Can you advised how to integrate the code which you have provided ?

 

Thank you so much and Have a good day.

 

Denny

 

ADMIN
Martin
Posted on: 19 May 2020 13:10

Hi Denny,

I am attaching you a sample project with the workaround that my colleague Nikolay was writing to you about.

In the project, we are adding the missing document part ("app.xml") used to specify the version of the Excel application that generated the document, and we are updating two more parts ("[Content_Types].xml" and "_rels/.rels") in order to have the same structure as the latest Excel version.

I hope this is a solution for your case. Please, let me know how it goes.

In appreciation for bringing this to our attention, I have added Telerik points to your account.

As a side note, I am slightly modifying the feature request in order to meet our requirements.

Do not hesitate to contact us if any additional questions arise.

Regards,
Martin
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Attached Files:
Denny
Posted on: 14 May 2020 10:55

Hi Nikolay,

 

I will need to integrate the conversion in our projects to really test the whether workaround is working.

Can you share the workaround which you are mentioned below.

 

Thank you so much and Have a good day.

 

Denny

ADMIN
Nikolay Demirev
Posted on: 13 May 2020 15:06

Hello Denny,

The RadGrid uses the Document Processing Libraries to generate XLSX documents. The RadSpreadProcessing library export documents containing only the required parts (the XML files in the XLSX file) and the required elements in each XML file in order to cover the requirements of each feature the library supports. That is why I have generated an empty XLSX document using the RadSpreadProcessing and I have extracted its contents and searched for something which can be used to recognize the version of the file format specification used to generate the file, but I was not able to find anything, which can lead to the conclusion that the file is in Excel 2007 or other formats. 

After that experiment, I have created an empty document with the latest Excel version and it seems there is another part (XML file) in the XLSX file used to specify which version of the Excel application generated the document. As I am not able to test the generated file with your software I can only assume which part of the document can be used to relate it to any Excel version. I am sharing with you an XLSX file generated by me based on the empty file generated with RadSpreadProcessing which you could use to test if it is recognized as generated using the latest Excel version. Please find the attached document and test with it.

If the issue is resolved for that file I could offer you a workaround, which will help you preprocess the generated documents and make your software think they are generated with the latest Excel version.

Please let me know if the attached file is correctly imported using your software and if that kind of workaround would suit your needs.

Regards,
Nikolay Demirev
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Attached Files:
Denny
Posted on: 13 May 2020 11:16

Hi Peter,

I am well aware on the output of the current .xlsx format is of 2007 (excel 12) version, and Rumen has confirmed this.

He asked me to log feature request on excel 2016 or later support.

We need this because one of our supporting application ( which i cant disclose) is able to detect that the format of the .xlsx generated by telerik is using older excel 2007 format, thus not able to support.

Is there any possibility that XLSX conversion for excel 2016 or Later is added to current telerik release?

 

Thank you and Have a good day.

Denny

 

 

ADMIN
Peter Milchev
Posted on: 12 May 2020 14:53

Hello Denny,

The .xlsx format is introduced in 2007 and is used by all subsequent versions of Microsoft Excel. With that said, both the Telerik UI for ASP.NET AJAX and Document Processing Library support the .xlsx format:

Please let us know if this is the feature you are looking for or share the differences in the .xlsx format between the version you desire and the one exported by the RadGrid.

Regards,
Peter Milchev
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Denny
Posted on: 12 May 2020 09:02

Hi Dimitar,

 

The product that we are subscribe is "Telerik UI for ASP.NET AJAX".

We are using RADGRID component under "Telerik.Web.dll".

Please let me know if you required further clarification.

 

Thank you and Have a good day.

 

Denny

 

ADMIN
Dimitar
Posted on: 05 May 2020 08:46

Hi Denny,

Can you specify which product are you currently using? I am asking since the RadDocument Processing library does not contain any UI elements.

I am looking forward to your reply.

Regards,
Dimitar
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.