Did you remove (uninstall) the library before using the include ?Rook Zimbabwe wrote:I keep getting this error
ExcelWriter (creates MS-Excel '97 compatible files)
-
- PureBasic Expert
- Posts: 4229
- Joined: Sat Apr 26, 2003 8:27 am
- Location: Strasbourg / France
- Contact:
For free libraries and tools, visit my web site (also home of jaPBe V3 and PureFORM).
- Rook Zimbabwe
- Addict
- Posts: 4322
- Joined: Tue Jan 02, 2007 8:16 pm
- Location: Cypress TX
- Contact:
- Rook Zimbabwe
- Addict
- Posts: 4322
- Joined: Tue Jan 02, 2007 8:16 pm
- Location: Cypress TX
- Contact:
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
But it sin't recognized as a formula... Is there a XLS_WriteFormula() ?

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)

No sorry, ExcelWriter does not support formula´s.Rook Zimbabwe wrote:Is there a XLS_WriteFormula() ?
Did you tried PureXLS from flype

http://www.purebasic.fr/english/viewtop ... 454#145454
Re: ExcelWriter (creates MS-Excel '97 compatible files)
thanks for developing and sharing 

Re: ExcelWriter (creates MS-Excel '97 compatible files)
awesome! thanks for developing and maintaining this 
