Elwood Blues
Top achievements
Rank 1
Rank 1
Elwood Blues
asked on 13 Jan 2010, 02:03 PM
Hi,
I'm evaluating your products for a previsioning system. The user of the system should export some data in excel format and re-import those data for a different period. I'm facing a problem during the import of the excel file generated by the Telerik RadGrid control: I've tried both the HTML based format and the ExcelML format without success.
I'm using some sample code I found here: http://www.telerik.com/community/forums/winforms/gridview/import-from-excel-or-csv.aspx
The file that I'm importing is the one generated from the export sample here: http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/exporting/defaultcs.aspx
I've changed the sheet name on the command to the correct one. The error I get is the following:
"External table is not in the expected format". Any suggestion?
Best Regards,
Elwood
3 Answers, 1 is accepted
0
Hello Elwood,
This approach doesn't work since it is suitable for the binary format only (Excel BIFF8). RadGrid supports HTML Excel (Office HTML) and ExcelML (XMLSS) - both are text-based formats (XML/HTML).
Of course, you could use the CSV format if it is suitable for your scenario.
Regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
This approach doesn't work since it is suitable for the binary format only (Excel BIFF8). RadGrid supports HTML Excel (Office HTML) and ExcelML (XMLSS) - both are text-based formats (XML/HTML).
Of course, you could use the CSV format if it is suitable for your scenario.
Regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Elwood Blues
Top achievements
Rank 1
Rank 1
answered on 13 Jan 2010, 02:55 PM
Hello Daniel,
thanks for your reply.
Unfortunately CSV is not an option.
Do you think that working with a XMLSS library like this http://www.codeproject.com/KB/office/excelxmllibrary.aspx will be a valid approach? In other words: should I expect a standard XMLSS?
Thanks in advance.
Elwood.
0
Hello Elwood,
We haven't tested this project although I believe it should work properly if it conforms to the XMLSS specification.
Please let me know what your observations are.
Best regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
We haven't tested this project although I believe it should work properly if it conforms to the XMLSS specification.
Please let me know what your observations are.
Best regards,
Daniel
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.