addin issue

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

addin issue

Postby edantas » 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

Re: addin issue

Postby amy.zhao » 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: 2273
Joined: Wed Jun 27, 2012 8:50 am

Re: addin issue

Postby tyncunatt » 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

Who is online

Users browsing this forum: No registered users and 0 guests

cron