Xlsx-Reader-Writer

Reader & Writer for Xlsx in Erlang

USAGE:

shell>git clone [email protected]:adrianx77/Xlsx-Reader-Writer.git
shell>./rebar co
shell>erl xlsxio -pa ebin -s xlsxio test
shell>erl xlsxio -pa ebin -s xlsxio test2

xlsx_reader:read(XlsxFile, RowHandler)

    XlsxFile  : only support higher than excel 2003 ,could be .xlsx or .xlsxm
    RowHandler: callback function =>fun(SheetName,RowData)
        SheetName:Sheet Name
        RowData  : true text list
        return   : next_sheet | next_row | break
            next_sheet  : ignor left rows ,continue process next sheet
            next_row    : continue next row
            break       : ignor next rows and sheets

so you can write such code:

test()->
    XlsxFile = "xlsx/t.xlsx",
    RowHandler =
        fun(SheetName, [1 | Row]) ->
            io:format("~n~ts=====>~p | ", [SheetName, 1]),
            lists:foreach(fun(R)-> io:format("\t~ts",[R]) end,Row),
            next_row;
            (SheetName, [Line | Row]) ->
                io:format("~n~ts=====>~p | ", [SheetName, Line]),
                lists:foreach(fun(R)-> io:format("\t~ts",[R]) end,Row),
            next_sheet
        end,

    case xlsx_reader:read(XlsxFile,RowHandler) of
        {error,Reason}-> io:format("read error:~p~n",[Reason]);
        ok-> io:format("~n")
    end.

use Writer should with 4 step
Author should be iolist or binary ,if your data with unicode code bigger
 than 255 you shoud convert by unicode:characters_to_binary
If CellData in Rows is string ，you should call unicode:characters_to_binary first.

1、xlsx_writer:create(XlsxFile,Author)=>XlsxHandle
2、xlsx_writer:create_sheet(Title,Rows)=>SheetHandle
3、xlsx_writer:add_sheet(XlsxHandle,SheetHandle)=> ok.
4、xlsx_writer:close(XlsxHandle).

test2()->
    XlsxFile = "xlsx/t2.xlsx",
    XlsxHandle = xlsx_writer:create(XlsxFile,"[email protected]"),
    SheetHandle = xlsx_writer:create_sheet("Hello",[[2,1,1,2],[3,2,2]]),  %% no first line
    SheetHandle2 = xlsx_writer:create_sheet("Hello2",[[1,1,1,2],[4,2,2]]), %% ignor line 2,3
    xlsx_writer:add_sheet(XlsxHandle,SheetHandle),
    xlsx_writer:add_sheet(XlsxHandle,SheetHandle2),
    xlsx_writer:close(XlsxHandle).

Future

I will add some prompt for writer.

我的Erlang技术交流QQ群:221307508