ExcelWriter (creates MS-Excel '97 compatible files)

[ABBKlaus]

Hi,

i made a conversion of the excelapi from Paul Squires. (see here http://www.planetsquires.com)

http://www.purebasicpower.de/?ExcelWriter

Klaus

[Num3]

Well i've seen that it doesn't require F64 lib anymore, but it just creates a blank document for me...

[ABBKlaus]

the example with the XIncludeFile does not need the F64 lib its only for PB4 Beta !
but i can´t reproduce your problem with the blank file, the example i delivered just works fine here.
can you put a snippet together and post it here
you can also debug each command :

Code: Select all

XIncludeFile("Source\ExcelWriter_res.pb")
XIncludeFile("Source\ExcelWriter.pb")

XLS_Init() ; Wichtig !!! muss hier stehen ist ja keine PB lib

Debug XLS_CreateFile("C:\Data\Test.xls")
Debug GetLastError_()

Debug XLS_PrintGridLines(#False)
Debug GetLastError_()

Klaus

[Num3]

Tried that and - No errors!

I just get a 900kb empty file...

I wonder if it has something to do with using OpenOffice...
I find the size too big, for such a small output...

[ts-soft]

In opencalc i see nothing, but in excel is good

[Droopy]

Very useful, thanks a lot

[Flype]

hello,

i began a lib (pb4) for writing excel files in XML format.
Since MS Office use this format it becames much easier to implement.

you might be interested in this try - ( just a start - not a full featured lib )

PureXLS -> UserLib_PB40_PureXLS.zip


here is how xml tags are organized :

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>

<Workbook>
   
    <Styles>
        <Style>
            <Alignment/>
            <Borders>
                <Border/>
            </Borders>
            <Font/>
            <Interior/>
        </Style>
    </Styles>
   
    <Worksheet>
        <Table>
            <Column/>
            <Row>
                <Cell>
                    <Data/>
                </Cell>
            </Row>
        </Table>
    </Worksheet>

</Workbook>

[zikitrake]

hello,

i began a lib (pb4) for writing excel files in XML format.
Since MS Office use this format it becames much easier to implement.

don't works in Office 2000

[Flype]

oh sorry, i forgot to say that MS Office understand XML Worksheets only since MS Office XP/2002/2003/+

[ABBKlaus]

recompiled for PB4.10 Final

http://www.purebasicpower.de/?ExcelWriter

[mskuma]

Thanks alot for this. Looks very useful. However I quickly tried the supplied example to write out some unicode text, and open the resultant excel file and the text appeared as garbage chars instead of the Japanese text I typed (compiled with UTF-8 source & set compile to unicode & specified subsystem 'UserLibUnicode'). I also tried changing the font to a Japanese one, but same result. Has the unicode version been tested? Thanks again.

[Rook Zimbabwe]

I cannot get it to work in 4.2b2

I get the same error attempting to run the example code:

http://www.bluemesapc.com/image/excelwrite1.jpg

What am I not doing.

And how many of those User Libraries do I have to install?

[Rook Zimbabwe]

I remmed out:



; XLS_Init() ; Wichtig !!! muss hier stehen ist ja keine PB lib

Debug XLS_CreateFile("C:\Data\Test.xls")
Debug GetLastError_()

And debug showed

0
6
0
6

But it appears to have worked... the file exists. 4.1 not 4.2b2

And I have to put the two resource files in the same directory as the program.

[ABBKlaus]

Sorry Rook, i had no time to compile a new userlib for Beta2.
You could use it as include file :

Code: Select all

XIncludeFile #PB_Compiler_Home+"Examples\Excel_Writer\Source\ExcelWriter.pb"
;include the resident file if needed
XIncludeFile #PB_Compiler_Home+"Examples\Excel_Writer\Source\ExcelWriter_res.pb"
;Init
XLS_Init()

[Rook Zimbabwe]

I keep getting this error

Mind yuo, I am not using UNICODE or threadsafe...





It opens one of the include files and stops on that line...