PureBasic Forums - English

Hi there,

ExcelWriter is a bit outdated. You might want to try Flypes PureXLS, its much better ;-)

You find it here : http://www.purebasicpower.de/downloads/PureXLS.pbi

BR Klaus

Thanks! I've just tried it and not only is the maximum characters in a cell enough it also keeps the correct date ...

Well I've found that the current Excel version, BIFF 2.1, excel.pbi writes is limited to 255 characters so there isn't any other good solution except to create a newer xls sheet but I can't find any good purebasic libraries for it. I do have found a crude workaround.

I'll just split the long text ...

Just tried it but can't open the output xls file in Excel 2007 or 2003, it says content unreadable.
I'll try if I can just hardwrite a character amount of above 255 in the xls file and get all to be displayed in Excel.

Using Michael's tip and changing 0x90 to 0xFF i can boost the 'limit' to 255 characters but it's still to small I need atleast double, I'll have a look inside the excel.pbi file to see if I can somehow change the character count it writes.

I might have read somewhere that in early versions of excel ...

The file is imported as 144 characters in Excel 2007. LibreCalc won't open it. In the absence of talking to the developers, perhaps the best way to work around the issue is to create a csv file and import it.
Thanks, I've tried comma seperated file but it had it's own problems. It's a shame that ...

Thanks,

Here is the code:

XIncludeFile "excel.pbi"

xlsCreateFile("test1.xls")

xlsWriteText ...

Still I would need some sort of work around
Code the output manually.
it might be a limitation of the older excel format excelwriter is writing
Then you need to take that up with the ExcelWriter developers.
http://sourceforge.net/projects/excel-writer/
Are there any other libs or code that ...

nospam wrote:

in Excel it's truncated to 144

Then the limitation has nothing to do with PB.

Still I would need some sort of work around, it might be a limitation of the older excel format excelwriter is writing. Are there any other libs or code that can create excel files from PB?

When using ExcelWriter in Purebasic I've stumbled upon a rather annoying bug or limitation, hopefully someone knows the answer to this.

When I use

XLS_WriteText ...

Is there a simple way to increase saturation of a pixel?
Something like:

convert RGB>HSL
S+10 (what would be the max?)
convert HSL>RGB

I've seen some code on the forum but it contains more then I need or is to complex for me and my program .

WInfo gives an error on my machine so I can't see it run. I only need the code to see the CPU usage, does your program display that like in Windows taskmanager?

Hello,

I've searched the help files and forum but couldn't find the answer.
Which code do I need to read the CPU usage on (any) Windows, and I guess if the processor has multiple threads each displays it's own CPU usage so I have to read the amount of threads and then the usage of each thread (in ...

Thanks, I thought so. I've finally succeeded in making the program multithreaded and got a 29% speed increase! Working with threads the first time is pretty complex.

Thanks, I tried the multiple threads but did not succeed, would speed things up if some or all code in the procedure was changed into asm?

Yes, please add this along with:

- cookie support
- easy posting of variables to URL's using POST or GET