addin issue

[edantas]

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

xlWorkBook.LoadFromFile(strFilename)
xlWorkSheet = xlWorkBook.Worksheets("abc")
xlWorkSheet.Select()
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.
System.Threading.Thread.Sleep(30000)

Any suggestions/help?

Thanks,

ED

[amy.zhao]

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,
Amy
e-iceblue support

[tyncunatt]

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