Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

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

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

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

amy.zhao
 
Posts: 2766
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.

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

Return to Spire.XLS