www.digitalmars.com         C & C++   DMDScript  

digitalmars.D.announce - xlsxd: A Excel xlsx writer

reply Robert Schadek <rschadek symmetryinvestments.com> writes:
https://code.dlang.org/packages/xlsxd

Announcing xlsxd a OO wrapper for the C library libxlsxwriter [1].

Run:

     import libxlsxd;
     auto workbook  = newWorkbook("demo.xlsx");
     auto worksheet = workbook.addWorksheet("a_worksheet");
     worksheet.write(0, 0, "Hello to Excel from D");


and you have created a Excel spreadsheet in the xlsx format with 
name demo.xlsx
that contains the string "Hello to Excel from D" in row 0, column 
0.

[1] https://github.com/jmcnamara/libxlsxwriter
Nov 07 2018
next sibling parent reply "H. S. Teoh" <hsteoh quickfur.ath.cx> writes:
On Wed, Nov 07, 2018 at 04:41:39PM +0000, Robert Schadek via
Digitalmars-d-announce wrote:

 https://code.dlang.org/packages/xlsxd
 
 Announcing xlsxd a OO wrapper for the C library libxlsxwriter [1].
 
 Run:
 
     import libxlsxd;
     auto workbook  = newWorkbook("demo.xlsx");
     auto worksheet = workbook.addWorksheet("a_worksheet");
     worksheet.write(0, 0, "Hello to Excel from D");
 
 
 and you have created a Excel spreadsheet in the xlsx format with name
 demo.xlsx
 that contains the string "Hello to Excel from D" in row 0, column 0.
 
 [1] https://github.com/jmcnamara/libxlsxwriter


Is there support for reading xlsx files too?


T

-- 
Старый друг лучше новых двух.
Nov 07 2018
next sibling parent reply Robert Schadek <rschadek symmetryinvestments.com> writes:
On Wednesday, 7 November 2018 at 16:49:58 UTC, H. S. Teoh wrote:

 Is there support for reading xlsx files too?


No, Pull Requests are welcome
Nov 07 2018
parent "H. S. Teoh" <hsteoh quickfur.ath.cx> writes:
On Wed, Nov 07, 2018 at 04:58:46PM +0000, Robert Schadek via
Digitalmars-d-announce wrote:

 On Wednesday, 7 November 2018 at 16:49:58 UTC, H. S. Teoh wrote:

 
 Is there support for reading xlsx files too?
 


 
 No, Pull Requests are welcome


Ah, unfortunately I have no experience working with xlsx or with
libxlsx.  I was hoping for read access in D so that I can write a simple
utility to extract data from xlsx files.  Maybe next time.


T

-- 
It always amuses me that Windows has a Safe Mode during bootup. Does that mean
that Windows is normally unsafe?
Nov 07 2018
prev sibling parent Laeeth Isharc <Laeeth laeeth.com> writes:
On Wednesday, 7 November 2018 at 16:49:58 UTC, H. S. Teoh wrote:

 On Wed, Nov 07, 2018 at 04:41:39PM +0000, Robert Schadek via 
 Digitalmars-d-announce wrote:

 https://code.dlang.org/packages/xlsxd
 
 Announcing xlsxd a OO wrapper for the C library libxlsxwriter 
 [1].
 
 Run:
 
     import libxlsxd;
     auto workbook  = newWorkbook("demo.xlsx");
     auto worksheet = workbook.addWorksheet("a_worksheet");
     worksheet.write(0, 0, "Hello to Excel from D");
 
 
 and you have created a Excel spreadsheet in the xlsx format 
 with name
 demo.xlsx
 that contains the string "Hello to Excel from D" in row 0, 
 column 0.
 
 [1] https://github.com/jmcnamara/libxlsxwriter


 Is there support for reading xlsx files too?


 T


There are various C libraries.you could just use DPP to call 
them..
Nov 09 2018
prev sibling next sibling parent reply jmh530 <john.michael.hall gmail.com> writes:
On Wednesday, 7 November 2018 at 16:41:39 UTC, Robert Schadek 
wrote:

 https://code.dlang.org/packages/xlsxd

 [snip]


You folks at Kaleidic keep doing great things.
Nov 07 2018
parent reply Robert Schadek <rschadek symmetryinvestments.com> writes:
dpp and a handful of vim macros did most of the work
Nov 08 2018
parent reply Dave <scherd3113 gmail.com> writes:
On Thursday, 8 November 2018 at 08:43:10 UTC, Robert Schadek 
wrote:

 dpp and a handful of vim macros did most of the work


Could you please elaborate a bit on your workflow for D with Vim? 
I often struggle with the tooling around D but consider Vim as a 
great tool to use for D development. I am aware of dutyl and also 
use it but you seem to have more tools at hand ...

E.g. what do you use for debugging, refactoring, ... ?
Nov 10 2018
parent reply Robert Schadek <rschadek symmetryinvestments.com> writes:
On Saturday, 10 November 2018 at 10:55:04 UTC, Dave wrote:

 Could you please elaborate a bit on your workflow for D with 
 Vim? E.g. what do you use for debugging, refactoring, ... ?


I had a lot of functions looking like this

     void chart_axis_set_name(lxw_chart_axis* handle, const(char)* 
name)

I had to transform into

     void setName(string name) {
         chart_axis_set_name(this.handle, toStringz(name));
     }

For that I created a handful of (neo)vim macros that basically it 
the transformations for me.

On my neovim setup. I use dutly. Dscanner generates ctags 
recursively when I press F7. Which Ctrl-P uses for jump marks.
I use kdbg to debug, its just a somewhat pretty frontend to gdb. 
Thats pretty much it.
Nov 12 2018
parent Dave <kraxli77 gmail.com> writes:
On Monday, 12 November 2018 at 10:38:28 UTC, Robert Schadek wrote:

 On Saturday, 10 November 2018 at 10:55:04 UTC, Dave wrote:

 Could you please elaborate a bit on your workflow for D with 
 Vim? E.g. what do you use for debugging, refactoring, ... ?


 I had a lot of functions looking like this

     void chart_axis_set_name(lxw_chart_axis* handle, 
 const(char)* name)

 I had to transform into

     void setName(string name) {
         chart_axis_set_name(this.handle, toStringz(name));
     }

 For that I created a handful of (neo)vim macros that basically 
 it the transformations for me.

 On my neovim setup. I use dutly. Dscanner generates ctags 
 recursively when I press F7. Which Ctrl-P uses for jump marks.
 I use kdbg to debug, its just a somewhat pretty frontend to 
 gdb. Thats pretty much it.


Many thank! I have followed your setup and it helps :-)
Nov 29 2018
prev sibling parent kevin brack <kevinbrack45 gmail.com> writes:
On Wednesday, 7 November 2018 at 16:41:39 UTC, Robert Schadek 
wrote:

 https://code.dlang.org/packages/xlsxd

 Announcing xlsxd a OO wrapper for the C library libxlsxwriter 
 [1].

 Run:

     import libxlsxd;
     auto workbook  = newWorkbook("demo.xlsx");
     auto worksheet = workbook.addWorksheet("a_worksheet");
     worksheet.write(0, 0, "Hello to Excel from D");


 and you have created a Excel spreadsheet in the xlsx format 
 with name demo.xlsx
 that contains the string "Hello to Excel from D" in row 0, 
 column 0.

 [1] https://github.com/jmcnamara/libxlsxwriter


this problem solved ZetExcel.com you try this. This is very 
helpful and fastest app specially for excel library. Thanks
Mar 18 2019