PureBasic Forums - English

If some body has code or snippet to manipulate excel file, i am trying to
assemble coding to be able to manipulate Excel files.
like How to create style, merge cell, add borderline, manipulate range etc... I will also supply all code to the french community.

If some body has code or snippet to manipulate excel file, i am trying to
assemble coding to be able to manipulate Excel files.
like How to create style, merge cell, add borderline, manipulate range etc... I will also supply all code to the french community.

Here is a sample of code for excel from ...

I tried that code on Excel 2007 wrote by Jackymb, corrected by Kiffi and srod. It worked until
this line until Cell$ = ExcelObject\GetStringProperty("Cells(" + Str(intRow) + ",1) = #NullString")
To make it worked i replace it with
Until Cell$ = ""

Is it working with another excel version.

Also ...

Here is the code Paul. I finally found the problem.
As i use a procedure SavePic() to save the image and a procedure GetPic() to retrieve the image, had to put the image encoder in the procedure.
Now everithing work fine.



;Image Saver And VIEWER PB4.2
;
;Window Constant
;
Enumeration ...

THANK YOU FOR ALL YOUR HELP.

THANK'S NETMAESTRO FOR YOUR CODE.

FROM YOUR CODE I TRIED TO HAVE AN IMAGE SAVER. BUT I HAVE AN ERROR MESSAGE #IMAGE OBJECT NOT INITIALIZE.

HERE IS MY CODE USING PURE BASIC 4.2

;- Gadget Constants
;
;Window Constant

Enumeration
#Window_0
#Window_1
EndEnumeration ...

Need to save and retrieve picture using Sqlite Db using Purebasic.
Thank for your support.

That exactly what i need and it work perfectly on string. I will try the
other with + replacing &.

Many thank's

I am just starting programming in Pure Basic and i can't find the right syntax for queries using variable and passing it from PB api to SQLite database

All Samples below is use on a program done with VB6 and MSAccess and all :shock: work properly

Here is a sample of different small queries using ...

ooops i will translate.

thank

Est-Ce que qe Vous connaissez les opérateurs pour passé ces variables dans SQLIte

Les exemples si dessous sont utilisés dans un prgramme VB6 avec base de données MSAcces
Je désire refaire le programme sous Pure Basic en Utilisant SQLite Comme Base de donnée.

Voici des exemples de requête utilisées ...