|104481||Jul 23,2012 06:07 AM||Jul 29,2012 11:25 PM||ASP.NET Web Forms (Classic)||4|
I am opening a Excel File (version 97-2003) like this
In My workbook, I have many WorkSheets.Based on logic , I am hidding some of the worksheets.
After that i activated and saved the workbook.
But i am opening the Excell file i am missing some of the lookups like (dropdown of country list etc) in some worksheets and populating the same lookups in some worksheets. What might be the problem?
In My machine, installed Excell Version is 2007 But i am opening Excell 2003 file.
I am using Syncfusion.XlsIO.Base.dll version 18.104.22.168.
Can you please help me out.
Thank you for using Syncfusion products.
We have analyzed the details which you have posted in the last post and we were not able find the actual cause of this issue. So it’s not possible to fix this issue without the input excel file. Please could you share us the input template which reproduces the issue. This will be helpful for us to further investigate on this issue.
Please let us know if you require any further clarifications.
I can't post the Excel Sheet due to some security reasons.
Let me explian the scenario cleary for your understaing. I Have a Excel Sheet with many worksheets. Most of the worksheet contains city drop down list and so on.My requirement is to download the excel file and based on the worksheet selection in my application , i want to show the selected work sheets in Excel sheet and hide the remaining.
I follow the following procedure.
1. I copied the Base Excel file to some temporary folder.
2. I opened the excel file from tempfolder using the below code
application.SkipOnSave = SkipExtRecords.None;
application.SkipOnSave = SkipExtRecords.CopySubstreams;
workbook = application.Workbooks.Open("FilePath", ExcelOpenType.Automatic);
3. Hiding Unwanted worksheets.
4.Save the Excel File using below code.
When opening the file,In some worksheets we are missing the lookups in Excel 2007.Surprisingly we haven't facing any problem with Excel 2003.
Do we need to anything in code for Excel Version Compatibility.
Thanks for your update.
The above reported issue has been fixed in our latest version 10.2.0.75. The reported version 22.214.171.124 is almost 20 versions back and also migrating from the latest version to the 126.96.36.199 requires huge amount of migration in the supporting products. So we strongly recommend you to upgrade your essential studio version to our latest version.
We provided the latest version download link for your reference.
Please let us know if you need any clarification
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.