Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Naveen
447
Could not load foramtted predefined Excel template using Infragistics.Excel
posted

I have a excel template with all the formatting predefined. All I want to do it load this template with appropriate values and save it.

When I load the excel template. it could not fine the active sheets. It says WorkSheets count as 0.

Here is the code that I use.

var excel_path = @"C:\\Test\\TEST.xlsx";

FileStream stream = File.OpenRead(excel_path);

Workbook wBook = Workbook.Load(stream);

Worksheet loSheet = wBook.Worksheets[0]; // here is where it is breaking.

I checked the wBook.Worksheets.Count and it says 0.

 

Am I missing anything? Please let me know...

 

Parents
No Data
Reply
  • 11095
    Offline posted

    Hello,

    Thank you for contacting Infragistics Developer Support!

    I was not able to reproduce the behaviour that you're seeing on your side. I have attached the sample project I used to test this. Please test this project on your side; whether or not it works correctly may help indicate the nature of this issue.
    If this sample project is not an accurate demonstration of what you're trying to do, please feel free to modify it and send it back, or send a small sample project of your own if you have one.

    Please note that when using to escape @ backslashes it is not needed to write double backslashes, because they are already escaped.

    Please let me know if I can provide any further assistance.

    InfragisticsExcelSample.zip
Children