OpenEuphoria

1. The libxlsxwriter library

• Posted by ghaberek (admin) Sep 09, 2015
• 3489 views
• Last edited Sep 11, 2015

I have completed wrapping libxlsxwriter and posted it to The Archive. This does require Euphoria 4.1 with memstruct support. There are a few structure-heavy elements to this library and it was a lot easier to wrap with memstruct instead of the ol' peek 'n' poke method. That being said, if there is enough interest in this library, I can put in some extra effort to make it compatible with Euphoria 4.0 as well. I have provided a Windows 32-bit DLL in the download. Linux users should be able to download the source and make/make install. I can try to provide 64-bit and Linux binaries if requested. Update: Now supports all 32-bit Euhporia! (4.0/4.1) Just add with define MEMSTRUCT before including xlsxwriter.e in your 4.1 in order to use memstructs.

libxlsxwriter

Sample code to create the above spreadsheet:

/* 

 * A simple example of some of the features of the libxlsxwriter library. 
 * 
 * Copyright 2014-2015, John McNamara, jmcnamara@cpan.org 
 * 
 */ 
 
include "xlsxwriter.e" 
 
procedure main() 
     
    /* Create a new workbook and add a worksheet. */ 
    atom workbook = new_workbook( "demo.xlsx" ) 
    atom worksheet = workbook_add_worksheet( workbook, NULL ) 
     
    /* Add a format. */ 
    atom format = workbook_add_format( workbook ) 
     
    /* Set the bold property for the format */ 
    format_set_bold( format ) 
     
    /* Widen the first column to make the text clearer. */ 
    worksheet_set_column( worksheet, {0, 0}, 20, NULL, NULL ) 
     
    /* Write some simple text. */ 
    worksheet_write_string( worksheet, {0, 0}, "Hello", NULL ) 
     
    /* Text with formatting. */ 
    worksheet_write_string( worksheet, {1, 0}, "World", format ) 
     
    /* Writer some numbers. */ 
    worksheet_write_number( worksheet, {2, 0}, 123,     NULL ) 
    worksheet_write_number( worksheet, {3, 0}, 123.456, NULL ) 
     
    workbook_close( workbook ) 
     
end procedure 

Get it here: libxlsxwriter.zip (144 KB)

-Greg

3. Re: The libxlsxwriter library

• Posted by ghaberek (admin) Sep 10, 2015
• 3395 views

This won't really be too difficult; it will just take more time. Bear with me and I'll have it ready soon.

The Euphoria developers don't really support OpenWatcom any more AFAIK. I built this with 32-bit TDM-GCC 4.8.1 (aka MinGW).

-Greg

5. Re: The libxlsxwriter library

• Posted by ghaberek (admin) Sep 11, 2015
• 3305 views

I believe Jim said that 4.1 is currently feature-frozen for release without memstruct. So we can more likely expect memstruct in 4.2. (circa 2018?)

-Greg

7. Re: The libxlsxwriter library

• Posted by jmduro Sep 11, 2015
• 3334 views

My Windows 32-bit All-ii-One package uses EU41 with memstruct:

http://rapideuphoria.com/euphoria32_for_win64_with_win32lib_and_wxeuphoria.zip

I tried the libxlswriter library with it and it works.

Regards

Jean-Marc

9. Re: The libxlsxwriter library

• Posted by ghaberek (admin) Sep 11, 2015
• 3314 views
• Last edited Sep 12, 2015

Updated: added support for non-memstruct Euphoria (4.0, 4.1).

http://www.rapideuphoria.com/libxlsxwriter.zip (145 KB)

-Greg

11. Re: The libxlsxwriter library

• Posted by ghaberek (admin) Sep 14, 2015
• 3216 views

Curious. What problem are you having? Maybe I or someone else here can help if you need.

Glad to be of service. I stumbled across this library when I used the Python version for a project at work.

When I found the C library version, I immediately set out to get it wrapped in Euphoria, thinking "I know someone will have a need for this!"

-Greg