larray.Session.to_excel

Session.to_excel(self, fname, names=None, overwrite=True, display=False, **kwargs)

Dumps LArray, Axis and Group objects from the current session to an Excel file.

Parameters

fnamestr

Path of the file for the dump.

nameslist of str or None, optional

Names of LArray/Axis/Group objects to dump. Defaults to all objects present in the Session.

overwrite: bool, optional

Whether or not to overwrite an existing file, if any. If False, file is updated. Defaults to True.

displaybool, optional

Whether or not to display which file is being worked on. Defaults to False.

Notes

• each array is saved in a separate sheet

• all Axis objects are saved together in the same sheet named __axes__

• all Group objects are saved together in the same sheet named __groups__

• all session metadata is saved in the same sheet named __metadata__

Examples

>>> # axes
>>> a, b = Axis("a=a0..a2"), Axis("b=b0..b2")    # doctest: +SKIP
>>> # groups
>>> a01 = a['a0,a1'] >> 'a01'                    # doctest: +SKIP
>>> # arrays
>>> arr1, arr2 = ndtest((a, b)), ndtest(a)       # doctest: +SKIP
>>> s = Session([('a', a), ('b', b), ('a01', a01), ('arr1', arr1), ('arr2', arr2)])  # doctest: +SKIP
>>> # metadata
>>> s.meta.title = 'my title'                    # doctest: +SKIP
>>> s.meta.author = 'John Smith'                 # doctest: +SKIP

Save all arrays

>>> s.to_excel('output.xlsx')  # doctest: +SKIP

Save only some objects

>>> s.to_excel('output.xlsx', ['a', 'b', 'arr1'])  # doctest: +SKIP