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...
Hello,
I am just following up to see if you need any further assistance with this issue. If so please let me know.
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.