Comateplus problem

[pierscintilla]

I'm a "border line" programmer and are new in Purebasic.
I am interested to write excel file from Purebasic and I have downloaded Comateplus.
I tried to run some examples I found attached to Comateplus with Purebasic 5.11 demo but I always get the same error:
Line 35 Structure not found: iUnknow in Residents.pbi.
How can I fix?

Thanks in advance

[spikey]

It sounds like the residents file has become corrupted It should read iUnknown not iUnknow. It might be an idea to unzip it from the zip package again.

[davido]

pierscintilla: I agree with spikey as I've been using CoMate Plus with PB511-64 with no problems. (That is no problems with CoMate!)

However, it might just be that the demo version which is 'limited' is the cause of your problems.

I can assure you that PureBasic is really worth the cost.

[spikey]

Ooops - davido is correct - I didn't spot the mention that you were using the demo. COMate plus will exceed the line limit of the demo version.

[pierscintilla]

Indeed, as says Spikey I read IUnknown and not iUnknow.
May be a limitation of the demo version, but on another occasion I got the message "exceeded the number of lines allowed" that now I have not.
I would like to be sure before buying. Lately I've spent too much ...

Thanks for the answers

[LuisAlberto]

Hello forum,
Newbie here. I echo "pierscintilla" concerns. Same problem when running examples form Comateplus. Error calls for "Structure not found: iUnknown". Additionally the Demo version that I have downloaded today, says it stops working with code about 800 lines. I tried to run some 200 lines code and it stops working since it exceed the limit of the Demo version.
I have no problem whatsoever if this is caused by the limitation of the Demo version, but would like to make sure these issues are only tied to Demo and will not be normal after purchasing the full version. Have any body in this forum, besides Pierscintilla and I, had experienced these issues?

I will much appreciate your feedback.
Thank you.
Alberto.

[idle]

The demo version doesn't have the windows API structures or imports included the full version does!

[pierscintilla]

Ok. Message loud and clear!
I have a couple more questions:
With my programs usually elaborate CSV file and I make excel file with charts.
Since I can not use Comateplus with the demo version you can get an idea of ??how long it takes to write i.e. 10000 numerical values ??one per line on a column excel with this library?
In other languages ??I have experienced that the only way to speed up the excel file writing is to make the job in VBA code inserted in the program or content in excel file that I open using a dll.
What you thinks about this?
In PureBasic do not think you can enter the VBA code. I think the only way to run VBA code is to launch excel to open a file with macro and run the macro everything with ComatePlus.
Is true?

Many thanks

[davido]

pierscintilla:

Can you create your variables with a small PureBasic program?

If that is possible then you could write these out to a text file with comma delimiting.

[pierscintilla]

Yes, this is what I normally do when I write the CSV file (during a data acquisition session) but then I must to transfer this data to an Excel spreadsheet with graphs and therein lies the problem of speed...