ExcelWriter (creates MS-Excel '97 compatible files)
ExcelWriter (creates MS-Excel '97 compatible files)
Hi,
i made a conversion of the excelapi from Paul Squires. (see here http://www.planetsquires.com)
http://www.purebasicpower.de/?ExcelWriter
Klaus
i made a conversion of the excelapi from Paul Squires. (see here http://www.planetsquires.com)
http://www.purebasicpower.de/?ExcelWriter
Klaus
Last edited by ABBKlaus on Mon Jan 05, 2009 7:40 pm, edited 3 times in total.
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 :
Klaus
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_()
In opencalc i see nothing, but in excel is good
PureBasic 5.73 | SpiderBasic 2.30 | Windows 10 Pro (x64) | Linux Mint 20.1 (x64)
Old bugs good, new bugs bad! Updates are evil: might fix old bugs and introduce no new ones.
Old bugs good, new bugs bad! Updates are evil: might fix old bugs and introduce no new ones.
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 :
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>
No programming language is perfect. There is not even a single best language.
There are only languages well suited or perhaps poorly suited for particular purposes. Herbert Mayer
There are only languages well suited or perhaps poorly suited for particular purposes. Herbert Mayer
don't works in Office 2000Flype wrote: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.
PB 6.0x, PureVision User.
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
- Addict
- Posts: 4326
- Joined: Tue Jan 02, 2007 8:16 pm
- Location: Cypress TX
- Contact:
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?
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?
Last edited by Rook Zimbabwe on Tue Mar 04, 2008 4:17 pm, edited 2 times in total.
- Rook Zimbabwe
- Addict
- Posts: 4326
- Joined: Tue Jan 02, 2007 8:16 pm
- Location: Cypress TX
- Contact:
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
And I have to put the two resource files in the same directory as the program.
; XLS_Init() ; Wichtig !!! muss hier stehen ist ja keine PB lib
Debug XLS_CreateFile("C:\Data\Test.xls")
Debug GetLastError_()
And debug showed
But it appears to have worked... the file exists. 4.1 not 4.2b20
6
0
6
And I have to put the two resource files in the same directory as the program.
Sorry Rook, i had no time to compile a new userlib for Beta2.
You could use it as include file :
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
- Addict
- Posts: 4326
- Joined: Tue Jan 02, 2007 8:16 pm
- Location: Cypress TX
- Contact: