Spire.XLS is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Wed Aug 29, 2012 3:27 pm

I have purchased a copy of Spire XLS standard edition .

I have an xlsx file with an addin that pulls data from other source and poluplate/refresh cells every 2 seconds. below is my code

xlWorkSheet = xlWorkBook.Worksheets("abc")
console.writeline(xlWorkSheet.Range(1, 1).NumberText) ' displays "#NAME?"

console.writeline(xlWorkSheet.Range(1, 1).Numbervalue) ' displays -1.#IND

I thought of putting some delay in order to give it time to get values by inserting the below statement after line 1 but it still would not load values.

Any suggestions/help?



Posts: 3
Joined: Fri May 04, 2012 1:27 pm

Fri Aug 31, 2012 8:05 am

Dear Edwin,

Sorry, I have not describled clearly.

Each time the value in cells pouplated/refreshed by excel add-in, will the workbook which has these cells with new value be saved to the file strFilename? If that, would you please send us the file to help me fix your problem?

Have a nice day!

Best wishes,
e-iceblue support
User avatar

Posts: 2626
Joined: Wed Jun 27, 2012 8:50 am

Sat Jan 19, 2013 9:29 pm

Yes, really. I join told all above. Let's discuss this question.

Posts: 2
Joined: Wed Jan 09, 2013 6:31 am

Return to Spire.XLS