File Extension Not Working for Excel Export

[Bob]

Hello Telerik team,

I know there are hundreds of posts around this topic, but I couldn't find a specific one regarding this issue

I set

RadGrid1.ExportSettings.Excel.FileExtension = "xlsx";

I expect that the exported file will have an extension of .xslx

Instead, I am getting RadGridExport.xslx.xsl  ???

How do I get the file extension I want?

Thanks

Bob

[Daniel]

Hello Bob,

To be honest, I don't see much point to change the file extension to xlsx - what's more, even if you change the extension manually, Microsoft Excel won't be able to open the file because Microsoft Office will detect the difference between the MIME type and the file content and will then add its own autodetected extension.
 
It would be better to leave the default file extension and then re-save the file in the format you like.

Best regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Bob]

Okay, so the purpose of the Property is ?????

[Daniel]

Hello Bob,

The purpose is to allow the developer to change the file extension. Unfortunately there are some limitations - in this particular case Microsoft Excel impose restrictions over the allowed extensions.
Since the ExcelML format is XML-based format, you could set the file extension to XLS, XML, XSL, etc.

This is the same as for the CSV format - you could safely change its extension to TXT.

Kind regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Bob]

Okay, I sort of understand, but the property is misleading and confusing.  If I am not actually able to change the FileExtension, then this property is really just some suffix that gets tacked onto the end of the filename....

All I am asking for is a bit of cleanup or consistency.  If I can;t modify the actual file extension of the downloaded file, then perhaps not teasing me with a Property that claims to do this would be helpful.  I got all excited about being able to set the extension (we have use cases that necessitate the Office 2007 extensions) only to find out it doesn;t work

But thanks for your explanations though...

Bob

[Daniel]

Hello Bob,

I'm afraid we can't remove the property but we can (and will do) explain this limitation in the documentation to facilitate our customers.

Best regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Chuck]

If this were true why wouldn't the extension be changed to HTML when the Format = GridExcelExportFormat.Html? Is there no way to change the filename extension?

[Tsvetomir]

Hi Chuck,

Setting the Export Format property to HTML is not designed to export to an HTML file. It does export grid's content to an Excel file based on the HTML and CSS. This behavior is explained in the overview of the following article.

HTML-Based Export 

Furthermore, RadGrid exporting functionality exposes a plethora of supported formats such as Excel, PDF, CSV etc. 

Supported Formats

Creating and exporting to custom files which are not listed in the article above might lead to unexpected complications. 

Is there a specific requirement you would like to cover? If you share your thoughts on the topic and provide more detailed information, I would be able to provide a more accurate answer.


Best regards,
Tsvetomir
Progress Telerik

[Chuck]

This is part of the need to be able to change the cell color based upon the cell value and the only why I've been able to do this is using the HTML format and the Export event as you had shown me but when the user goes to open the file in Excell the mesg appears that the file is in the wrong format because the extension is defaulted to "XLS". Why can't I be able to change the file extension when using the HTML filetype to avoid this message?

[Tsvetomir]

Hi Chuck,

The described error message is a known issue for older version of Excel files and is documented in the following article: Excel Format (HTML-Based)

If you use the newer format XLSX (Open XML), this warning will not be shown. To do that, set the Format property to "Xlsx" in the ExportSettings of the grid and include the rest of the assemblies that can be found in the AdditionalLibrary folder of the Telerik/Progress installation directory.

<ExportSettings>
    <Excel Format="Xlsx" />
</ExportSettings>

Should you require further clarifications, free to contact me.

Kind regards,
Tsvetomir
Progress Telerik

[Chuck]

Seems to be a problem, getting the attached error.

[Peter Milchev]

Hello Chuck,

The allowed upload file extensions for the forum are .gif, .jpg, .jpeg, .png. 

What I can suggest is opening an official support ticket where you can attach .zip and .rar archives up to 20MB with a small runnable sample reproducing the observed error. This will allow us to investigate locally your exact scenario and provide more accurate and specific suggestions. 

Once we have a solution in the support thread, we can share the solution here for convenience and better visibility from the community. 

Regards,
Peter Milchev
Progress Telerik