ExcelWriter (creates MS-Excel '97 compatible files)

Developed or developing a new product in PureBasic? Tell the world about it.
gnozal
PureBasic Expert
PureBasic Expert
Posts: 4229
Joined: Sat Apr 26, 2003 8:27 am
Location: Strasbourg / France
Contact:

Post by gnozal »

Rook Zimbabwe wrote:I keep getting this error
Did you remove (uninstall) the library before using the include ?
For free libraries and tools, visit my web site (also home of jaPBe V3 and PureFORM).
ABBKlaus
Addict
Addict
Posts: 1143
Joined: Sat Apr 10, 2004 1:20 pm
Location: Germany

Post by ABBKlaus »

gnozal wrote:
Rook Zimbabwe wrote:I keep getting this error
Did you remove (uninstall) the library before using the include ?
No he did not :twisted:
User avatar
Rook Zimbabwe
Addict
Addict
Posts: 4322
Joined: Tue Jan 02, 2007 8:16 pm
Location: Cypress TX
Contact:

Post by Rook Zimbabwe »

SO I need to delet the Lib from User Libraries??? OK I will try anything.
Binarily speaking... it takes 10 to Tango!!!

Image
http://www.bluemesapc.com/
User avatar
Rook Zimbabwe
Addict
Addict
Posts: 4322
Joined: Tue Jan 02, 2007 8:16 pm
Location: Cypress TX
Contact:

Post by Rook Zimbabwe »

How would I write a formula?

I wrote a string into the file, but even though the formula is correct I had to access that cell in excel and then hit enter to make it a formula`!!!

I used

Code: Select all

XLS_WriteText("=SUM(A1:A6)",7,0,#XLS_Font2,#XLS_LeftAlign,#XLS_CellNormal,0)
But it sin't recognized as a formula... Is there a XLS_WriteFormula() ?

:D
Binarily speaking... it takes 10 to Tango!!!

Image
http://www.bluemesapc.com/
ABBKlaus
Addict
Addict
Posts: 1143
Joined: Sat Apr 10, 2004 1:20 pm
Location: Germany

Post by ABBKlaus »

Rook Zimbabwe wrote:Is there a XLS_WriteFormula() ?
No sorry, ExcelWriter does not support formula´s.

Did you tried PureXLS from flype :?:

http://www.purebasic.fr/english/viewtop ... 454#145454
ABBKlaus
Addict
Addict
Posts: 1143
Joined: Sat Apr 10, 2004 1:20 pm
Location: Germany

Post by ABBKlaus »

updated ExcelWriter to work with PB4.30X86.

Download see first post.
ABBKlaus
Addict
Addict
Posts: 1143
Joined: Sat Apr 10, 2004 1:20 pm
Location: Germany

Re: ExcelWriter (creates MS-Excel '97 compatible files)

Post by ABBKlaus »

Update : ExcelWriter version 1.05 for PureBasic 4.5x x86

Regards Klaus
+18
Enthusiast
Enthusiast
Posts: 228
Joined: Fri Oct 24, 2008 2:07 pm

Re: ExcelWriter (creates MS-Excel '97 compatible files)

Post by +18 »

thanks for developing and sharing :D
jamba
Enthusiast
Enthusiast
Posts: 144
Joined: Fri Jan 15, 2010 2:03 pm
Location: Triad, NC
Contact:

Re: ExcelWriter (creates MS-Excel '97 compatible files)

Post by jamba »

awesome! thanks for developing and maintaining this :D
-Jon

Fedora user
But I work with Win7
Post Reply