This is a migrated thread and some comments may be shown as answers.

Excel warning when opening file exported by XlsxFormatProvider

4 Answers 120 Views
SpreadProcessing
This is a migrated thread and some comments may be shown as answers.
Jon
Top achievements
Rank 1
Jon asked on 02 Aug 2017, 09:00 AM

I am currently trying out SpreadProcessing. I am importing an xlsx spreadsheet file using the XlsxFormatProvider, capturing its data into a DataTable and then exporting it (without changes) to a new file (with an xlsx extension).

However, when I subsequently open the exported file in Excel, I get the following message:

We found a problem with some content in <file>. Do you want us to recover as much as we can? If you trust the source of this workbook, click Yes.

If I click Yes, the file appears to load fully and correctly (although I get a further dialog). How can I avoid this message - it's going to be a concern to users of the application I'm intending to use SpreadProcessing in.

Excel Version 2013; Visual Studio 2017; UI for ASP.NET AJAX R2 2017; .NETFramework 4.5.2

4 Answers, 1 is accepted

Sort by
0
Accepted
Anna
Telerik team
answered on 04 Aug 2017, 08:10 AM
Hi Jon,

Sometimes this error appears in situations when you are trying to export to a stream retrieved from an already existing file by using FileMode.Open or FileMode.Create. If you don't think that this is the cause in this case, can you please open a ticket with us and send us your code so that we can investigate where the issue comes from? 

Regards,
Anna
Progress Telerik

0
Jon
Top achievements
Rank 1
answered on 04 Aug 2017, 08:53 AM
Yes, that could well have been it. It's academic now as the application I was considering using SpreadProcessing in requires data to be output to an .xlsm file (spreadsheet containing macros) which SpreadProcessing doesn't currently support so I've had to find an alternative (i.e.EPPlus).
0
Anna
Telerik team
answered on 07 Aug 2017, 06:50 AM
Hi,

I am sorry to hear that SpreadProcessing did not provide the functionality you needed for your application. I have created an item in our Feedback portal for macro support and if you'd like to you can upvote it. This would be of help to us as we take the upvotes into account when we determine which features to implement.

Regards,
Anna
Progress Telerik

0
Anna
Telerik team
answered on 08 Aug 2017, 08:53 AM
Hi,

I apologize, there is an older item regarding this functionality so the new one I linked in the previous reply has been deleted. The official item can be found in this link and all likes and follows from the deleted item have been merged into it.

Regards,
Anna
Progress Telerik

Tags
SpreadProcessing
Asked by
Jon
Top achievements
Rank 1
Answers by
Anna
Telerik team
Jon
Top achievements
Rank 1
Share this question
or