We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Opening a downloaded Spreadsheet

Thread ID:

Created:

Updated:

Platform:

Replies:

77520 Nov 4,2008 03:51 PM Nov 11,2008 02:25 AM Windows Forms 7
loading
Tags: XlsIO
Aditya
Asked On November 4, 2008 03:51 PM

Hi,
I am downloading a excel spreadsheet from a website and then i tried to open it using

ExcelEngine excelEngine = new ExcelEngine();

IApplication application = excelEngine.Excel;

IWorkbook workbook = application.Workbooks.Open(@"C:\test.xls");

However the last line throws an error saying CompoundFileException was unhandled Wrong Signature.

I copy pasted the contents of the original xls file (off the web) into another xls file and the code worked fine.

Please advise.




Geetha M [Syncfusion]
Replied On November 5, 2008 11:39 PM

Hi Aditya,

Thank you for the details.

Could you please send us the Excel file that does not open? It would help us to recreate and analyze the problem.

Please let me know if you have any difficulties.

Regards,
Geetha


Aditya
Replied On November 6, 2008 01:35 PM

Hi Geetha,
You can download the file from:
https://www.theice.com/marketdata/nybotreports/getOptionsDailyVolumeOIReportResultsExcel.do?commodityChoice=ALL+COMMODITIES&format=excel


>Hi Aditya,

Thank you for the details.

Could you please send us the Excel file that does not open? It would help us to recreate and analyze the problem.

Please let me know if you have any difficulties.

Regards,
Geetha




Geetha M [Syncfusion]
Replied On November 7, 2008 06:11 AM

Hi Aditya,

I am not able to download the Excel file from the above link. Could you please attach it here?

Regards,
Geetha


Aditya
Replied On November 7, 2008 03:51 PM

Attached.


>Hi Aditya,

I am not able to download the Excel file from the above link. Could you please attach it here?

Regards,
Geetha





test_eca69e85.zip

Geetha M [Syncfusion]
Replied On November 9, 2008 11:07 PM

Hi Aditya,

Thank you for the attachment.

I was able to see the issue with your spreadsheet. But when I analyzed the file, it appears to be a htm file renamed with .xls extension. Essential XlsIO does not provide support to open such files. After I re saved the file as .xls using MS Excel I was able to open it using Essential XlsIO.

Please let me know if you have any questions.

Regards,
Geetha


Aditya
Replied On November 10, 2008 10:09 AM

Our requirment is to open and process this file on a server which does not have MS Excel installed. Let me know if you think this can be done with any of your products.


>Hi Aditya,

Thank you for the attachment.

I was able to see the issue with your spreadsheet. But when I analyzed the file, it appears to be a htm file renamed with .xls extension. Essential XlsIO does not provide support to open such files. After I re saved the file as .xls using MS Excel I was able to open it using Essential XlsIO.

Please let me know if you have any questions.

Regards,
Geetha




Geetha M [Syncfusion]
Replied On November 11, 2008 02:25 AM

Hi Aditya,

Essential XlsIO does not provide support to open a htm file. As a workaround if you can convert it to any form which is supported by XlsIO, that is as an .csv, .xml, .txt (Tab demilited), then you may open it using XlsIO and process it.

Please let me know if you have any questions.

Regards,
Geetha


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;